It seems so simple, yet I’m stuck.
I want to limit the results that I have to only contain a certain amount of records,say 1000, per distinct value in column A. So for value 1, I need max 1000 returns, for value 2 as well etc. How do I set my limit clausule in Databricks SQL?

I have several streaming tables which I need to mask some columns on because they contain PID in delta live pipelines within databricks.

I’m working with a (Databricks) SQL database where I need to update the casing of the “State” field, which is stored as part of a JSON string inside the “Payload” column. The “State” field can have values like “granted”, “denied”, etc., and I need to ensure that these values are correctly capitalized (“Granted”, “Denied”).

I’m working with a (Databricks) SQL database where I need to update the casing of the “State” field, which is stored as part of a JSON string inside the “Payload” column. The “State” field can have values like “granted”, “denied”, etc., and I need to ensure that these values are correctly capitalized (“Granted”, “Denied”).

I’m working with a (Databricks) SQL database where I need to update the casing of the “State” field, which is stored as part of a JSON string inside the “Payload” column. The “State” field can have values like “granted”, “denied”, etc., and I need to ensure that these values are correctly capitalized (“Granted”, “Denied”).

I’m working with a (Databricks) SQL database where I need to update the casing of the “State” field, which is stored as part of a JSON string inside the “Payload” column. The “State” field can have values like “granted”, “denied”, etc., and I need to ensure that these values are correctly capitalized (“Granted”, “Denied”).

I’m trying to convert my string field to date field in my Databricks 10.4 LTS. So I wrote following query

One of my column’s value look like this :

I am writing this SQL query on Databricks SQL notebook