Common BigQuery errors

Timestamp error

Error: No matching signature for operator >= for argument types: DATETIME, TIMESTAMP. Supported signature: ANY >= ANY at [4:87]

If you come across this error, it’s because Cube expects Timestamps instead of DateTime objects. You can solve this by changing the SQL to:

sql: TIMESTAMP(partition_date)