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
Show the mappings for an external table, either the one specified by name or all mappings.
.show external table ExternalTableName mapping MappingName
.show external table ExternalTableName mappings
Learn more about syntax conventions.
| Name | Type | Required | Description |
|---|---|---|---|
| ExternalTableName | The name of the external table to which to assign the mapping. | ||
| MappingName | The name of the mapping. |
Returns a table containing the mapping name, mapping kind, and new mapping definition of all relevant mappings.
.show external table MyExternalTable mapping "Mapping1"
Output
| Name | Kind | Mapping |
|---|---|---|
| mapping1 | JSON | [{"ColumnName":"rownumber","Properties":{"Path":"$.rownumber"}},{"ColumnName":"rowguid","Properties":{"Path":"$.rowguid"}}] |