How to run SQL query on External Tables in Azure Data Explorer

This post has been republished via RSS; it originally appeared at: Azure Data Explorer articles.

As you probably already know ADX can process queries written in SQL (if you don't - you can learn about this feature here). A small addition shipped recently expands this support by allowing to query external tables (external data residing outside of Kusto cluster) using the same SQL dialect. A screenshot is worth a thousands words:
 
external_tables_through_tsql.PNG
As you can see from the screenshot above external tables are recognized as database entities, just like regular tables!

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.