Property description

The queries property defines a list of queries to be executed against external data source or be processed in the ingestion process. At least one query should be specified.

Minimal JSON

{
  "key": "",
  "baseType": "",
  "type": ""
}
{
  "key": "data_source_definition",
  "queries": [
    {
      "key": "database",
      "abbreviation": "database",
      "description": "",
      "type": "object"
    }
  ]
}

Example taken from the core_sql_server package.

Nested properties

PropertyDescriptionValuesMandatory
keyUnique key of the query.stringYes
baseTypeBase type in a code list form for objects that the scanning query extracts from the data source. For example, for both external_table and file_table, you can use table as a base type to describe that both queries are scanning objects of the table type.stringYes
typeDefined graph level type of the query. Supported values are: object: The query result contains objects. Each row is one object and each column is one object attribute., relation: Relations between objects., generic: Generic query type used in case you want to ingest some metadata for custom processing.stringYes
abbreviationShortened form of the query name.stringNo
descriptionDescription of the property.stringNo
nameName of the property.stringNo