How does Hyper-Q handle timezone information on BigQuery?

BigQuery does not support data types like TIMESTAMP with timezone. All time data is assumed to be in UTC.

Hyper-Q converts data types with timezone to the equivalent data type without timezone when used in DDLs and CAST expressions, for example. Hyper-Q automatically converts the data to UTC to ensure the correct point in time is recorded. Timezone information itself is not preserved, as BigQuery does not offer data types with timezone. Therefore, when retrieving values they are implicitly and only in timezone UTC.

Note that client application may receive the value converted to a time zone different than UTC, based on the setting of the timezone endpoint configuration option. This setting is independent of orthogonal to the conversion of data types with timezone to data types without timezone.