/Python/Gcp jupyter use python variables in magic bigquery

Gcp jupyter use python variables in magic bigquery

date_str_query = '2019-02-%'
sql = """
select * from `project.dataset.table`
where date_str like {0}
""".format(date_str_query)
df = client.query(sql).to_dataframe()

Source: stackoverflow.com

Gcp jupyter use python variables in magic bigquery

params = {'date_str_query': '%-2019-02-%'}

%%bigquery df --params $params
select * from `project.dataset.table`
where date_str like @date_str_query

Source: stackoverflow.com

Similar codes

12 votes200 views2 answers
Python pip version check
Python
0 vote180 views1 answer
Remove first 2 rows in pandas
Python
0 vote184 views1 answer
How to write a table from 1 to 10 with for loop in fython in 3 lines
Python
1 vote177 views1 answer
Dictionary with double key python
Python
1 vote133 views1 answer
Set window size with sizers wxpython
Python
10 votes170 views1 answer
How to get specific row in pandas
Python
34 votes188 views6 answers
Python to exe converter online
Python
4 votes171 views3 answers
Python vs Java
Python
0 vote197 views1 answer
Python pool
Python
0 vote189 views1 answer
Prints out the schema in the tree format
Python