.show ingestion mapping

  • Article

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 mapping(s).
MappingKind string The type of mapping(s) 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 the ingestion mapping(s) 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 

```kusto
.show database MyDatabase ingestion csv mappings

Related content