Databricks Community

sujai_sparks · 02-24-2023

Let's say I have a delta table in Azure databricks that stores the staff details (denormalized). I wanted to export the data in the JSON format and save it as a single file on a storage location. I need help with the databricks sql query to group/co...

sujai_sparks · 02-24-2023

Final sql:%sql select collect_list( struct(department_id, department_name, staff_members) ) from ( select department_id, department_name, collect_list(struct(employee_id, first_name, last_name)) as staff_members fr...

sujai_sparks · 02-24-2023

How do I mark this question as answered?

sujai_sparks · 02-24-2023

@Ryan Chynoweth , regarding your question "Why do you need to have a json file?", the intension of required JSON output as a file, is for the file based integration with other systems downstream.

sujai_sparks · 02-24-2023

@Nathan Anthony , Thank you, Thank you so much! Thank you @Ryan Chynoweth and @Joseph Kambourakis as well! All of you guys are great helping the community. There is a lot to learn from the community!

sujai_sparks · 02-24-2023

On Microsoft SQL Server, the following TSQL query would produce the desired output. But, I'm unable to replicate the same in Databricks SQL SELECT DISTINCT department_id, department_name ,( SELECT employee_id ,first_name ,last_name FROM ...

Databricks Community

User Stats

User Activity

How to convert records in Azure Databricks delta table to a nested JSON structure?

Re: How to convert records in Azure Databricks delta table to a nested JSON structure?

Re: How to convert records in Azure Databricks delta table to a nested JSON structure?

Re: How to convert records in Azure Databricks delta table to a nested JSON structure?

Re: How to convert records in Azure Databricks delta table to a nested JSON structure?

Re: How to convert records in Azure Databricks delta table to a nested JSON structure?