Does ODBC Tableau for Azure Data Explorer have support to connect to external tables. I have these 3 tables I am able to query:
But in Tableau, I am unable to search and see the tables:
Asked
Active
Viewed 119 times
1
David דודו Markovitz
- 42,900
- 6
- 64
- 88
enavuio
- 1,428
- 2
- 19
- 31
-
search with schema name eg dbo.test – Debayan Aug 25 '22 at 05:47
-
@MKD - I will keep trying to search with schema name but unable to find still. Thank you! – enavuio Aug 25 '22 at 15:31
1 Answers
1
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
David דודו Markovitz
- 42,900
- 6
- 64
- 88