Parameters as query strings in the URL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2023 10:19 AM
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=12345Those 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=1234It 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?