Querying External Table using KQL
Question
You have created an external table named ExtTable in Azure Data Explorer.
Now, a database user needs to run a KQL (Kusto Query Language) query on this external table.
Which of the following function should he use to refer to this table?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Correct Answer: A
After an external table is defined, the function external_table() should be used to refer to this table.
Any database reader or user can query an external table.
Option A is correct.
external_table() should be used to refer to the external table.
Option B is incorrect.
Access_table() is not the valid function.
Option C is incorrect.
There is no function like refer_table().
Option D is incorrect.
Any database reader or user can query an external table.
To know more about how to query data in Azure Data Lake using Azure Data Explorer, please visit the below-given link:
The correct function that the database user should use to refer to the external table named ExtTable in Azure Data Explorer is external_table().
external_table() is a Kusto Query Language (KQL) function that is used to query data from an external table. An external table is a table that is stored outside of Azure Data Explorer, but is accessible through Azure Data Explorer. To query data from an external table, you must use the external_table() function.
The access_table() and refer_table() functions are not valid KQL functions in Azure Data Explorer. Therefore, they cannot be used to refer to an external table.
The last option, "Only the table administrator can query the table," is not correct either. If an external table is created in Azure Data Explorer, it can be accessed by any user who has appropriate permissions to query it, regardless of whether they are the table administrator or not.
In summary, the correct function that the database user should use to refer to the external table named ExtTable in Azure Data Explorer is external_table().
