/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

1 vote210 views1 answer
Pytz
Python
1 vote205 views1 answer
Drop duplicate rows pandas except nan
Python
0 vote208 views2 answers
Looping over folder to extract zip winrar python
Python
3 votes207 views2 answers
Python save a dictionary as an object
Python
0 vote213 views3 answers
Python count
Python
1 vote208 views1 answer
Torch tensor equal to
Python
21 votes192 views4 answers
Floor function in python
Python
0 vote199 views1 answer
Slicing tuples
Python
11 votes191 views6 answers
If statements python
Python
11 votes199 views3 answers
Rotate axis labels matplotlib
Python