Parameters as query strings in the URL

danieleads — Wed, 28 Jun 2023 17:19:05 GMT

Working with a query that was imported to Databricks from Redash.

There are a couple fields set as parameters on this query:

In Redash, it was possible to pre-fill the values for those parameters in the URL. Here's an example showing a valid pre-fill from Redash:

redash.site.com/queries/12345?p_Dates=2023-02-28--2023-06-28%26p_UserID=12345

Those parameters don't seem to work anymore in the Databricks version of this query. Interestingly though when I enter parameters on the page and submit them in the Databricks query, the URL does update with those parameters -

https://site.databricks.com/sql/editor/queryid?o=ownerid&p_Dates=2023-06-28--2023-06-30&p_UserID=1234

It just doesn't seem to carry over if I copy that link and open it in a new tab. It's like the page just ignores the query strings, but oddly decides to write them to the URL if you update the parameters.

Was this a half-implemented function? It doesn't make sense to me that it would rewrite the URL if it also couldn't take parameters in from the URL. Or is there something I'm missing about how they need to be formatted?

topic Parameters as query strings in the URL in Data Engineering

Parameters as query strings in the URL