Solution for API hosted on Databricks

[Nilave]

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

[Prabakar · Accepted solution]

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

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

[Nilave]

@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