Visualize data from Azure Data Explorer in Tableau
Tableau is a visual analytics platform for business intelligence. To connect to Azure Data Explorer from Tableau and bring in data from a sample cluster, use the SQL Server Open Database Connectivity (ODBC) driver.
You need the following to complete this article:
Connect to Azure Data Explorer with ODBC using the SQL Server ODBC driver, to connect to Azure Data Explorer from Tableau.
Tableau Desktop, full, or trial version.
A cluster that includes the StormEvents sample data. For more information, see Create an Azure Data Explorer cluster and database and Ingest sample data into Azure Data Explorer.
The StormEvents sample data set contains weather-related data from the National Centers for Environmental Information.
Visualize data in Tableau
Once you've finished configuring ODBC, you can bring sample data into Tableau.
In Tableau Desktop, in the left menu, select Other Databases (ODBC).
For DSN, select the data source you created for ODBC, then select Sign In.
For Database, select the database on your sample cluster, such as TestDatabase. For Schema, select dbo, and for Table, select the StormEvents sample table.
Tableau now shows the schema for the sample data. Select Update Now to bring the data into Tableau.
When the data is imported, Tableau shows rows of data similar to the following image.
Now you can create visualizations in Tableau based on the data you brought in from Azure Data Explorer. For more information, see Tableau Learning.