/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

2 votes133 views1 answer
Python cv2 get image shape
Python
0 vote143 views1 answer
<b> bold tag in python
Python
2 votes133 views5 answers
Pandas rename single column
Python
0 vote139 views2 answers
Trace table python
Python
0 vote137 views1 answer
Python generate sine wave pyaudio
Python
96 votes166 views6 answers
If substring not in string python
Python
37 votes141 views6 answers
Turn list into string
Python
-1 vote133 views1 answer
Numpy apply function to array
Python
0 vote201 views1 answer
Subprocess.popen no output
Python
5 votes144 views2 answers
Put comma in numbers python
Python