โ12-08-2021 05:10 AM
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
โ12-08-2021 08:43 AM
Hi @Nilave Chakrabortyโ , please check if this helps you.
https://docs.microsoft.com/en-us/azure/databricks/sql/api/queries-dashboards
โ12-08-2021 06:39 AM
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.
โ12-08-2021 08:43 AM
Hi @Nilave Chakrabortyโ , please check if this helps you.
https://docs.microsoft.com/en-us/azure/databricks/sql/api/queries-dashboards
โ12-09-2021 12:28 AM
@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
โ01-14-2022 02:20 AM
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.