external_table()

References an external table by name.

external_table('StormEvent')

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 ] )

Arguments

• TableName: The name of the external table being queried. Must be a string literal referencing an external table of kind blob, adl or sql.

• MappingName: An optional name of the mapping object that maps the fields in the actual (external) data shards to the columns output by this function.

Next steps

• External tables overview
• Create and alter Azure Storage external tables
• Create and alter SQL Server external tables