topic Re: How can we pass parameters while scheduling queries in Databricks SQL? in Data Engineering

How can we pass parameters while scheduling queries in Databricks SQL?

Sajid1 — Wed, 02 Nov 2022 17:53:08 GMT

Re: How can we pass parameters while scheduling queries in Databricks SQL?

Cami — Wed, 02 Nov 2022 20:59:08 GMT

Hello:)

How would you like pass a parameters and where? Is it ok for you to have value stored on the query level?

Did you checked documentation out?

What is your bussines case?

or perhaps this question resolve your issue

Re: How can we pass parameters while scheduling queries in Databricks SQL?

PrasanthM — Thu, 03 Nov 2022 06:39:56 GMT

Any string between double curly braces

is treated as a query parameter. widget can be an option here.

Re: How can we pass parameters while scheduling queries in Databricks SQL?

Sajid1 — Thu, 03 Nov 2022 08:16:54 GMT

How to create widget in sql warehouse query, not using a notebook so cannot use the dbutils to create widgets?

Re: How can we pass parameters while scheduling queries in Databricks SQL?

Sajid1 — Thu, 03 Nov 2022 08:22:07 GMT

I had gone through the documentation, not explored the query-based dropdown list. However, can the users change the parameter value once the query is refreshed and dashboard is populated? Primarily, I am not sure of how to pass default values for parameters as i need to schedule the queries and get the dashboard populated.

Re: How can we pass parameters while scheduling queries in Databricks SQL?

LaurentLeturgez — Fri, 04 Nov 2022 10:37:04 GMT

Hi @Sajid Thavalengal Rahiman

When you write your query into DBSQL, just add a variable into brackets like this, it will add automatically the widget with the name given in the SQL Code (You can customize the type of your widget by clicking on the icon on the right of the widget):