Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Azure 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"