topic Re: Converting databricks query output in JSON and creating end point in Data Engineering

Converting databricks query output in JSON and creating end point

Mangeysh — Thu, 22 Aug 2024 15:11:35 GMT

Hello

I am very new to DB and building an UI where I need to show data from databricks table. Unfortunately , I am getting access delta sharing feature by administrator. Planning to develop own API and expose endpoint with JSON output. I am sure this very common and lots of people must have done it. If you can help me with this will be great help 🙂

Re: Converting databricks query output in JSON and creating end point

szymon_dybczak — Thu, 22 Aug 2024 16:16:37 GMT

Hi @Mangeysh ,

But what is your problem precisly? So far we only know that you're going to build some API and display results of delta table 🙂

Re: Converting databricks query output in JSON and creating end point

menotron — Fri, 23 Aug 2024 20:41:00 GMT

Hi @Mangeysh,
You could achieve this using Databricks SQL Statement Execution API. I would recommend going through the docs and looking at the functionality and limitations and see if it serves your need before planning to develop your own APIs.