.drop ingestion mapping command

Applies to: ✅ Microsoft FabricAzure Data Explorer

Drops the ingestion mapping from a database or table.

Permissions

The command to drop a database ingestion mapping requires at least Database Ingestor permissions, and the command to drop a table ingestion mapping requires at least Table Ingestor permissions.

Syntax

.drop (table | database) TableOrDatabaseName ingestion MappingKind mapping MappingName

Learn more about syntax conventions.

Parameters

Name Type Required Description
TableOrDatabaseName string ✔️ The name of the table or database containing the ingestion mapping to drop.
MappingKind string ✔️ The kind of the ingestion mapping. Valid values are csv, json, avro, parquet, and orc.
MappingName string ✔️ The name of the ingestion mapping to drop.

Examples

Drop a CSV table mapping

.drop table MyTable ingestion csv mapping "Mapping1" 

Drop a JSON table mapping

.drop table MyTable ingestion json mapping "Mapping1" 

Drop a CSV database mapping

.drop database MyDatabase ingestion csv mapping "Mapping2"