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.
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).