topic Solution for API hosted on Databricks in Data Engineering

Solution for API hosted on Databricks

Nilave — Wed, 08 Dec 2021 13:10:41 GMT

I'm using Azure Databricks Python notebooks. We are preparing a front end to display the Databricks tables via API to query the tables. Is there a solution from Databricks to host callable APIs for querying its table and sending it as response to front ends

Re: Solution for API hosted on Databricks

Prabakar — Wed, 08 Dec 2021 16:43:12 GMT

Hi @Nilave Chakraborty , please check if this helps you.

https://docs.microsoft.com/en-us/azure/databricks/sql/api/queries-dashboards

Re: Solution for API hosted on Databricks

Nilave — Thu, 09 Dec 2021 08:28:17 GMT

@Prabakar Ammeappin Thanks for the link

Also was wondering for web page front end will it be more effective to query from SQL Database or from Azure Databricks tables. If from Azure SQL database, is there any efficient way to sync the tables from Azure Databricks to Azure SQL database