Feedback Edit

.show ingestion mapping

  • Article
  • 2 minutes to read

Show the ingestion mappings (all or the one specified by name).

  • .show table TableName ingestion MappingKind mappings

  • .show table TableName ingestion MappingKind mapping MappingName

Show all ingestion mappings from all mapping types:

  • .show table TableName ingestion mappings

Show all ingestion mappings on a database:

  • .show database DatabaseName ingestion MappingKind mappings

Example

.show table MyTable ingestion csv mapping "Mapping1" 

.show table MyTable ingestion csv mappings 

.show table MyTable ingestion mappings 

.show database MyDatabase ingestion csv mappings

Sample output

Name Kind Mapping
mapping1 CSV [{"Name":"rownumber","DataType":"int","CsvDataType":null,"Ordinal":0,"ConstValue":null},{"Name":"rowguid","DataType":"string","CsvDataType":null,"Ordinal":1,"ConstValue":null}]