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

-1 vote174 views1 answer
Python matrix determinant without numpy
Python
0 vote179 views1 answer
Falcon 900 price
Python
1 vote180 views1 answer
Spike python
Python
0 vote123 views1 answer
List.fold_left
Python
0 vote176 views1 answer
AttributeError: 'tuple' object has no attribute 'reshape'
Python
2 votes171 views1 answer
Variable in regex python
Python
0 vote172 views1 answer
Distplot for 2 columns
Python
1 vote173 views1 answer
A0 = dict(zip(('a','b','c','d','e'),(1,2,3,4,5)))
Python
3 votes162 views1 answer
Python set return type
Python
0 vote226 views1 answer
Try python import
Python