你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
external_table()
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
References an external table by name.
Note
The external_table function has similar restrictions as the table function.
Standard query limits apply to external table queries as well.
Syntax
external_table( TableName [, MappingName ] )
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the external table being queried. Must reference an external table of kind blob, adl, or sql. |
| MappingName | string |
A name of a mapping object that maps fields in the external data shards to columns output. |
Authentication and authorization
The authentication method to access an external table is based on the connection string provided during its creation, and the permissions required to access the table vary depending on the authentication method. For more information, see Azure Storage external table or SQL Server external table.