cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Parameters as query strings in the URL

danieleads
New Contributor

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

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

danieleads_0-1687972165051.png

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?

0 REPLIES 0

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group