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.
Switch services using the Version drop-down list. Learn more about navigation.
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"