CODEWITHSUNDEEP
azureazure-log-analyticsazure-synapse
Manjunath P N
Manjunath P N

Reputation: 13

Is it possible to query Azure data warehouse within log analytics

I have a scenario where I would like to query Azure Data warehouse tables within the Log Analytics workspace and using those records I need to create a result set and prepare a chart.

I do see some objects in log analytics workspace like a database, table but not sure what is the purpose and are these objects specific to a resource or generic and how to use them I couldn't get documentation for these objects can somebody guide me on this.

Upvotes: 1

Views: 447

Answers (1)

CHEEKATLAPRADEEP
CHEEKATLAPRADEEP

Reputation: 12788

Unfortunately, you cannot use Azure Log Analytics to query Azure SQL Data Warehouse.

Use Azure Data Studio to connect and query data in Azure SQL data warehouse.

Recommended tools for querying data in Azure SQL Data Warehouse.

Azure Log Analytics is used to write, execute, and manage Azure Monitor log queries in the Azure portal. You can use Log Analytics queries to search for terms, identify trends, analyze patterns, and provide many other insights from your data.

For more information about log queries, see Overview of log queries in Azure Monitor.

For a detailed tutorial on writing log queries, see Get started with log queries in Azure Monitor.

Upvotes: 0

Related Questions