.show ingestion mapping

Applies to: ✅ Azure Data Explorer

Use this command to view a specific ingestion mapping, or all ingestion mappings, for a database or table.

Syntax

View a specific mapping:

.show (table | database) EntityName ingestion MappingKind mapping MappingName

View all mappings or all mappings of a specific type:

.show (table | database) EntityName ingestion [ MappingKind ] mappings

Learn more about syntax conventions.

Parameters

Name Type Required Description
EntityName string ✔️ The name of the table or database for which to show the ingestion mappings.
MappingKind string The type of mappings to view. Possible values: csv, json, avro, w3clogfile, parquet, and orc.
MappingName string The name of the mapping to view. This argument is required if you specify that you want to view a single mapping instead of multiple mappings for the entity. See syntax options.

Returns

The command returns a table with the columns Name, Kind, and Mapping that describe one or more ingestion mappings names, types, and specifications.

Example

Show a specific ingestion mapping

.show table MyTable ingestion csv mapping "mapping1"

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}]

If the table only contained one CSV formatted mapping named mapping1, the following query would return the same output as the previous query.

.show table MyTable ingestion csv mappings 

.show database MyDatabase ingestion csv mappings

Related content