Can I connect to a databricks table and pull data directly into AAS for our daily data refresh (processing)

Question

I want to connect to databricks tables directly using azure analysis services (AAS) and pull data into our AAS model during our daily model processing.

Answer 1

As of now, Azure Analysis Services (AAS) does not provide a built-in connector for Databricks. However, you can still integrate data from Azure Databricks into AAS by utilizing intermediate steps, such as:

1. Exporting Databricks Data to Azure SQL Database or Azure Synapse:
   • One common approach is to load data from Databricks into an Azure SQL Database or Azure Synapse Analytics. You can then connect AAS to this data source and schedule regular processing.
2. Using Azure Data Factory (ADF):
   • ADF can orchestrate the movement of data from Databricks to other supported sources such as Azure Blob Storage, Azure Data Lake, Azure SQL Database, or Azure Synapse. Once the data is stored, AAS can pull it from those sources.
3. Power BI and Direct Query:
   • If your goal is more focused on real-time data, consider using Power BI with Direct Query mode, which supports Databricks as a data source. You can either import the data into Power BI and then load it into AAS or create a direct query model that AAS can leverage.