Google BigQuery API, How to set the field type of destinationTable?

Vote count:

0

We are using BigQuery's Python API, specifically the jobs resource, to run a query on an existing BigQuery table, and to export the results by inserting the resulting dataset in a new BigQuery table (destinationTable).

Is there a way to also update the schema of the newly created table and set a specific datatype? By default, all fields are set to a 'string' type, but we need one of the fields to be 'timestamp'.

asked 1 min ago

user2692901

1

Google BigQuery API, How to set the field type of destinationTable?