.show ingestion mapping
Show the ingestion mappings (all or the one specified by name).
.showtableTableNameingestionMappingKindmappings.showtableTableNameingestionMappingKindmappingMappingName
Show all ingestion mappings from all mapping types:
.showtableTableNameingestionmappings
Show all ingestion mappings on a database:
.showdatabaseDatabaseNameingestionMappingKindmappings
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}] |