Spark SQL - declaring and using variables in SQl Notebook

Question

In Azure data bricks i created SQL note book. I am trying to use the variables and use that across multiple SQL statements. e.g. declare fiscal year and use that across where criteria. Intent is to avoid hardcoding.

It looks i have to use Python / Scala. Is there any way to achieve this using pure SQL statements?

e.g.:

var @fiscalYear = 2018;

select * from table where fiscalyear = @fiscalyear

Ronieri Marques · Accepted Answer · 2020-01-30 22:17:02Z

2

Check this link out:

https://forums.databricks.com/questions/176/how-do-i-pass-argumentsvariables-to-notebooks.html

Another way is to do this (to set variable value):

%python
dbutils.widgets.text("var","text")
dbutils.widgets.remove("var")

Then you can go:

%sql
select * from table where value = '$var'

answered Jan 30, 2020 at 22:17

Ronieri Marques

4595 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spark SQL - declaring and using variables in SQl Notebook

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related