Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Which timezone is `_AIRBYTE_EXTRACTED_AT` in in the raw tables?

The `_airbyte_extracted_at` column in the raw tables represents a timestamp for when the event was pulled from the data source. The column type is `TIMESTAMP WITH TIME ZONE` in most destinations like [Postgres](<https://docs.airbyte.com/integrations/destinations/postgres#output-schema-raw-tables>), [Yellowbrick](<https://docs.airbyte.com/integrations/destinations/yellowbrick#output-schema-raw-tables>), [Redshift](<https://docs.airbyte.com/integrations/destinations/redshift#output-schema>), and [Snowflake](<https://docs.airbyte.com/integrations/destinations/snowflake#output-schema>). This means that the timestamp includes timezone information.  However, in [BigQuery](<https://docs.airbyte.com/integrations/destinations/bigquery#output-schema>), the column type is `TIMESTAMP`, which represents a point in time independent of any time zone.  Please note that the timezone of `_airbyte_extracted_at` can be influenced by the timezone settings of the source system or the Airbyte server. For example, a user reported an issue where the `_airbyte_extracted_at` column in Snowflake was in local timezone, and they managed to change it to UTC by setting the timezone for the Airbyte destination user to `UTC` ([source](<https://github.com/airbytehq/airbyte/issues/29199>)).