Writting a column with date format in Big Query

Level 2
Writting a column with date format in Big Query

Hi everyone,

I'm using Dataiku 11.2 with Big Query and GCS. 

I need to upload to Big Query (using a sync recipe) a table with a column in DATE format, the problem is that Dataiku uses TIMESTAMP instead of DATE format, so when i do the sync, the format of the resulting table in Big Query is TIMESTAMP

If you need further information, I'll be pleased to give you more details about this.

Best regards,


0 Kudos
1 Reply
In DSS 11.1.0, we changed the way BigQuery creates BigQuery tables for managed datasets to match what the other recipes do. DSS will now only create BigQuery tables with TIMESTAMP columns and no longer with DATE or DATETIME columns. This prevents issues in downstreams recipes where DSS is not capable of correctly reading back the DATE or DATETIME columns (i.e. without unexpected timeshifts).
It's this line in the release notes
* Fixed issue with date types coming from BigQuery
Please let me know if you have any questions.
0 Kudos