Search code examples
azureazure-data-explorertableau-desktopexternal-tables

Azure Data Explorer ODBC External Tables - Tableau


Does ODBC Tableau for Azure Data Explorer have support to connect to external tables. I have these 3 tables I am able to query: enter image description here

But in Tableau, I am unable to search and see the tables:

enter image description here


Solution

  • While it seems the ADX external tables are indeed not listed, they can be referenced by a New Custom SQL.
    Below is a demonstration on the publicly available cluster, Help.

    Although in KQL external tables are referenced with a special syntax, e.g.:

    external_table('TaxiRides')
    | take 10
    

    When using the SQL syntax, you refer to it as a regular table, e.g.:

    select top 10 * from TaxiRides
    

    New Custom SQL