This message was deleted.

No good reason. Most other data warehouses either don't have multiple data types for this, or let you compare between them. BigQuery is unusually strict in that regard. It does seem like TIMESTAMP is much more popular than DATETIME though, so it might make sense to make that an option

👍 makes sense to me. not a big deal in the meantime - there's an easy workaround by casting our query columns to datetime. i can add a quick note to the docs if you want

Following up on this. We pushed a change to support both DATETIME and TIMESTAMP data types for BigQuery, so no need to cast anymore.

awesome, thanks!!