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

0 vote352 views1 answer
Cross_val_score scoring parameters types
Python
-2 votes363 views1 answer
Type python fast
Python
0 vote367 views1 answer
Django authenticate with email
Python Django
0 vote439 views1 answer
Bash: line 1: templates/addtask.html: No such file or directory in flask app
Python Flask
4 votes326 views1 answer
Python int binary
Python
0 vote305 views5 answers
Print string python
Python
0 vote330 views1 answer
Pyodbc cursor create list of dictionaries
Python
82 votes340 views6 answers
Arch Linux
Python
1 vote336 views1 answer
Django making a custom 403 page
Python
0 vote310 views1 answer
How to alight and place ipywidgets
Python