String to date in BQ

def save_to_bq_table():<br />bq_client = bigquery.Client()<br /># Saving data to a intermediate table then export it to GCS<br />query = "##Query with millions of records results##"<br />job_config = bigquery.QueryJobConfig()<br /># Set the destination table<br />table_ref = bq_client.dataset(dataset_id).table('TableID')<br />job_config.destination = table_ref<br />job_config.allow_large_results = True<br /># Start the query, passing in the extra configuration.<br />query_job = bq_client.query(<br />query,<br />location='US', # Location must match that of the source table<br />job_config=job_config) # API request - starts the query<br />query_job.result() # Waits for the query to finish<br />

Source: cardinalpath.com

Similar codes

2 votes144 views2 answers
Pandas shift column up
Python
6 votes176 views1 answer
Pandas standard deviation on column
Python
16 votes194 views6 answers
Show all columns in pandas
Python
2 votes162 views1 answer
Dice rolling simulator python
Python
0 vote192 views1 answer
Python method to filter vowels in a string
Python
0 vote160 views1 answer
Pivot table with lambda
Python
0 vote169 views1 answer
Create instances of a class in a for loop
Python
0 vote173 views1 answer
Python convert a dict to list or a list to dict or a slice a dict or sort a dict by key or value without import
Python
0 vote170 views1 answer
Get next multiple of a number
Python
3 votes172 views1 answer
Spotify api python
Python