cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

How to read data from Azure Log Analitycs ?

William_Scardua
Contributor III

Hi guys,

I need to read data from Azure Log Analitycs Workspace directaly, have any idea ?

thank you

1 ACCEPTED SOLUTION

Accepted Solutions

jenykooe
New Contributor III

Yes, there are several ways to read data from Azure Log Analytics Workspace:

  1. Azure portal: You can view and query your data directly from the Azure portal. Simply go to your Log Analytics Workspace, select the "Logs" option, and start writing queries to retrieve the data you need.
  2. REST API: You can use the Log Analytics REST API to programmatically retrieve data from your workspace. The API provides endpoints for running queries, retrieving data, and managing data sources and tables.
  3. Azure Monitor API: Azure Monitor provides a unified API for retrieving data from various monitoring services, including Log Analytics. You can use the Azure Monitor API to retrieve data from your Log Analytics Workspace in a variety of formats, including JSON, CSV, and SQL.
  4. Power BI: Power BI is a business intelligence tool that can connect to your Log Analytics Workspace and retrieve data for visualization and analysis.
  5. Azure Functions: You can use Azure Functions to retrieve data from your Log Analytics Workspace and process it in real-time. You can trigger functions based on data changes or schedule them to run on a regular basis.
  6. Azure Stream Analytics: Azure Stream Analytics provides a real-time data processing service that can ingest data from Log Analytics and other sources. You can use Stream Analytics to analyze and transform data in real-time and output the results to various destinations, including Power BI and Azure SQL Database.

Choose the method that best fits your needs and technical expertise. TellCulvers Survey

View solution in original post

3 REPLIES 3

jenykooe
New Contributor III

Yes, there are several ways to read data from Azure Log Analytics Workspace:

  1. Azure portal: You can view and query your data directly from the Azure portal. Simply go to your Log Analytics Workspace, select the "Logs" option, and start writing queries to retrieve the data you need.
  2. REST API: You can use the Log Analytics REST API to programmatically retrieve data from your workspace. The API provides endpoints for running queries, retrieving data, and managing data sources and tables.
  3. Azure Monitor API: Azure Monitor provides a unified API for retrieving data from various monitoring services, including Log Analytics. You can use the Azure Monitor API to retrieve data from your Log Analytics Workspace in a variety of formats, including JSON, CSV, and SQL.
  4. Power BI: Power BI is a business intelligence tool that can connect to your Log Analytics Workspace and retrieve data for visualization and analysis.
  5. Azure Functions: You can use Azure Functions to retrieve data from your Log Analytics Workspace and process it in real-time. You can trigger functions based on data changes or schedule them to run on a regular basis.
  6. Azure Stream Analytics: Azure Stream Analytics provides a real-time data processing service that can ingest data from Log Analytics and other sources. You can use Stream Analytics to analyze and transform data in real-time and output the results to various destinations, including Power BI and Azure SQL Database.

Choose the method that best fits your needs and technical expertise. TellCulvers Survey

Ajay-Pandey
Esteemed Contributor II

Hi @William Scardua​ 

You can use Log Analytics REST API to extract the data from databricks.

Please refer below link for more information-

Log Analytics REST API | Microsoft Learn

Priyag1
Honored Contributor II

Thank you for sharing best answers here

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.