Databricks Community

QueryingQuagga · 02-27-2025

Hello all (and, if you are watching these posts, Databricks employees/representatives  ),I hope you take this idea into account - I haven't been able to find a place where one can vote on features, but I believe that this idea would make very real i...

QueryingQuagga · 12-10-2024

Edit: value of inner key "value" was an array - I have added the square brackets to the example below.Hello all,I'm working with Spark SQL API for querying semi-structured data in Databricks. Currently I'm having a hard time understanding how I can n...

QueryingQuagga · 03-18-2025

Although this is not getting any visibility, I've got another feature idea to add:* Colour coding or otherwise marking columns to reflect table relationIn a simple join between e.g. table "cart" and table "cartItems", columns from "cart" would be mar...

QueryingQuagga · 01-02-2025

So your problem comes from the fact, that you have nested json string as a value.This is of course the case and I see this now. I think I might have been confused by not knowing enough by VARIANT and the fact that the online DBR SQL editor will do so...

QueryingQuagga · 12-11-2024

I'm unsure if the schema that you are parsing above is the correct one though (I might be misunderstanding). If I edit your json to the following: { "extendedinformation":[ { "name": "CHANNEL", "value": "[{\"id\":\"DUMMYID...

QueryingQuagga · 12-11-2024

Thank you - I'm looking into a solution using `LATERAL`.

Databricks Community

User Stats

User Activity

Databricks SQL editor - we can get a long way with a few Quality of Life improvements

Working with semi-structured data (complex - variant)

Re: Databricks SQL editor - we can get a long way with a few Quality of Life improvements

Re: Working with semi-structured data (complex - variant)

Re: Working with semi-structured data (complex - variant)

Re: Working with semi-structured data (complex - variant)