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

[Kaniz]

Hi @ Nilave! My name is Kaniz, and I'm the technical moderator here. Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question first. Or else I will get back to you soon. Thanks.

[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

[Kaniz]

Hi @Nilave Chakraborty​ , Azure Databricks and Azure SQL database can be used amazingly well together. This repo will help you to use the latest connector to load data into Azure SQL as fast as possible, using table partitions and column-store and all the known best practices.

Source