/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

17 votes317 views1 answer
Take off character in python string
Python
-1 vote323 views1 answer
Python design patterns
Python
0 vote306 views1 answer
To_bytes python
Python
0 vote335 views1 answer
Date format django template filter
Python Django
2 votes325 views6 answers
How to download nltk in python
Python
1 vote405 views1 answer
Sum values in django models
Python Django
2 votes310 views2 answers
Python convert hex to binary
Python
1 vote307 views1 answer
Swapping of two numbers in python
Python
0 vote342 views1 answer
Listing of django model types
Python Django
1 vote285 views1 answer
List set python
Python