- 4263 Views
- 4 replies
- 4 kudos
I want to be able to denote the type of run from a predetermined list of values that a user can choose from when kicking off a run using different parameters. Our team does standardized job runs on a weekly cadence but can have timeframes that change...
- 4263 Views
- 4 replies
- 4 kudos
Latest Reply
I'm looking to this too. Wonder if there a way to make as a drop down for a job parameter
3 More Replies
by
wyzer
• Contributor II
- 8932 Views
- 8 replies
- 4 kudos
Hello,In SSRS/Power BI (report builder), how to query a table in Databricks with parameters please ?Because this code doesn't works :SELECT * FROM TempBase.Customers WHERE Name = {{ @P_Name }}Thanks.
- 8932 Views
- 8 replies
- 4 kudos
Latest Reply
Hi, I am not able to see the data in SSRS while I am using date parameters but with manual dates data is populating fine. The database is pointing to databricks. I am not sure what I am missing here. Please help me in this. ThanksI am trying with que...
7 More Replies
by
KVNARK
• Honored Contributor II
- 3446 Views
- 1 replies
- 4 kudos
how can we deploy global parameters from dev to higher environments in ADF. Could anyone throw some light on this.I'm using GIT in DEV and deploying it to PROD using Azure CICD pipeline.
- 3446 Views
- 1 replies
- 4 kudos
Latest Reply
@KVNARK . : To deploy global parameters from dev to higher environments in Azure Data Factory (ADF), you can follow these steps:In your DEV environment, create the global parameters in ADF and save them.Commit and push the changes to your Git reposi...
by
elgeo
• Valued Contributor II
- 2078 Views
- 2 replies
- 1 kudos
Hello. Following an older question SQL Declare Variable equivalent in databricks, we managed to find through the following article Converting Stored Procedures to Databricks | by Ryan Chynoweth | Dec, 2022 | Medium, a way to declaring more complicate...
- 2078 Views
- 2 replies
- 1 kudos
Latest Reply
Hi @ELENI GEORGOUSI Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Th...
1 More Replies
- 1209 Views
- 1 replies
- 1 kudos
In Databricks SQL, I have a query that has a dropdown parameter. How do I get this in the Databricks dashboard? I see the option of adding filters but there is nothing for dashboards
- 1209 Views
- 1 replies
- 1 kudos
Latest Reply
To answer my own question, it seems like if I add the visualisation from the query page then the parameters are automatically added. Added from the dashboard page seems to be bugged
by
g96g
• New Contributor III
- 5521 Views
- 1 replies
- 1 kudos
Im doing the self study and want pass df column name as a parameter.I have defined the widget column_name= dbutils.widgets.get('column_name')which is executing succefuly ( giving me a column name)then Im reading the df and do some transformation and ...
- 5521 Views
- 1 replies
- 1 kudos
Latest Reply
df2.select([column_name]).writeORdf2.select(column_name).write
by
Bency
• New Contributor III
- 1755 Views
- 2 replies
- 1 kudos
Hi ,Could someone help me understand how I would be able to get all the parameters in the task (from the widget). ie I want to get input as parameter 'Start_Date' , but the case is that this will not always be passed . It could be 'Run_Date' as well ...
- 1755 Views
- 2 replies
- 1 kudos
Latest Reply
Hi @Bency Mathew Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Thank...
1 More Replies
- 1916 Views
- 0 replies
- 0 kudos
How Can I pass parameters from the data factory to databricks Jobs that is using a notebook but I know how to pass parameters from data factory to databricks notebooks when ADF calling directly the Notebook.
- 1916 Views
- 0 replies
- 0 kudos
- 5876 Views
- 2 replies
- 6 kudos
I have separate column value defined in 13 diffrent notebook and i want merge into 1 databrick notebook and want to pass dynamic parameter using databrick so it will help me to run in single databricks notebook .
- 5876 Views
- 2 replies
- 6 kudos
Latest Reply
Hi @siddhesh Bhavar you can use widgets with the %run command to achieve this. https://docs.databricks.com/notebooks/widgets.html#use-widgets-with-run%run /path/to/notebook $X="10" $Y="1"
1 More Replies
by
SEOCO
• New Contributor II
- 3312 Views
- 3 replies
- 3 kudos
Hi,This is all a bit new to me.Does anybody have any idea how to pass a parameter to the Databricks notebook.I have a DevOps pipeline/release that moves my databricks notebooks towards QA and Production environment. The only problem I am facing is th...
- 3312 Views
- 3 replies
- 3 kudos
Latest Reply
@Mario Walle - If @Hubert Dudek's answer solved the issue, would you be happy to mark his answer as best so that it will be more visible to other members?
2 More Replies
