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 vote173 views1 answer
Applies a function to all elements of this RDD.
Python
0 vote161 views1 answer
Python operator overloading deal with type
Python
0 vote189 views1 answer
Install easygui
Python
0 vote212 views1 answer
Django fixtures. To dump data
Python Django
10 votes157 views4 answers
Numpy distance between two points
Python
0 vote163 views1 answer
Dynamic grid using tkinter
Python
6 votes243 views4 answers
Django change password command line
Python Django
0 vote184 views1 answer
Range function in python use cases
Python
0 vote208 views1 answer
Source code for making Telegram robot with Python
Python
2 votes155 views1 answer
Django.core.exceptions.improperlyconfigured: wsgi application 'backend.wsgi.application' could not be loaded; error importing module.
Python Django