Property description

The dataSourceDefinitions asset defines how data is ingested from external data source into Dawiso. It configures:

  • Queries to be executed against the external data source to get metadata from it
  • The visual template for data source

Minimal JSON

{
  "key": "",
  "name": "",
  "provider": ""
}
{
  "key": "data_source_definition",
  "name": "SQL Server Data Source",
  "description": "SQL Server Ingestion Data Source",
  "provider": "core_sql_server",
  "queries": [
    {
      "key": "database",
      "abbreviation": "database",
      "description": "",
      "type": "object"
    }
  ],
  "versions": [
    {
      "key": "default",
      "name": "Version 1.0",
      "options": {},
      "queryDefinitions": [],
      "template": {
        "$schema": "https://schema.dawiso.com/provider-schema.json",
        "providerName": "core_sql_server",
        "steps": []
      }
    }
  ]
}

Example taken from the core_sql_server package.

Nested properties

PropertyDescriptionValuesMandatory
keyUnique key of the asset. Used for referencing in the same package or other packages using packageKey#assetKey.stringYes
nameName of the asset, used as the default EN translation.stringYes
providerKey of the data ingestion provider. Supported values are: core_amazon_redshift, core_databricks, core_dbt, core_google_bigquery, core_keboola, core_mongodb, core_mysql, core_oracle, core_postgresql, core_power_bi, core_sap_hana, core_snowflake, core_sql_server, core_tableau. The following can be used to ingest any kind of data into Dawiso: Amazon Redshift, Google BigQuery, MySQL, Oracle, PostgreSQL, SAP Hana, Snowflake, SQL Server. The remaining providers are platform-specific and only the mapping specified in the data integrations asset can be changed.stringYes
descriptionDescription of the property.stringNo
queriesArray with a list of queries that can be executed using the provider to get metadata from the external data source.arrayNo
versionsArray of versions of the data source ingestion queries and visual template. Each data source can have multiple versions to cover different product versions or the evolution of the source schema.arrayNo