Invalid time zone in BigQuery
Since the last update in tzdata previous week (2025b - March 22, 2025), a new timezone named America/Coyhaique was introduced.
However, BigQuery still doesn't support it and produces an error when trying to handle this timezone.
I see that BigQuery still didn't updated its internal parser to support this new timezone yet. But what should we do in these cases? Wait for them to support it? Is there an alternative approach?
EDIT 27/mar/2025: I made a mistake because I thought the America/Coyhaique was removed, but it actually is a new timezone. This is why BigQuery doesn't support it.
Solution
Problem fixed by Google on April 25, 2025.
- Invalid time zone in BigQuery
- How to get current TIMESTAMP in UTC from BigQuery?
- BigQuery giving error of expression not grouped by when order by is included in the sql statement
- Implementing iteration in Standard SQL (BigQuery)
- Format a number to have commas (1000000 -> 1,000,000)
- Long form record view in looker studio
- Vertex AI feature store vs BigQuery
- Permissioning Dataflow to read a BigQuery table that is pointing to Drive?
- Allowed Range in case of Date/Timestamp Partitioned table in bigquery
- What does it cost to query files/data in different GCS storage classes from BigQuery (federated/external query)?
- How to efficiently query BigQuery external table (Bigtable) using keys from a smaller table
- Grant access on BigQuery based on table prefix
- ImportError: cannot import name pubsub_v1
- When using Apache Beam locally, how to utilize persistant caching for queries in BigQuery?
- SELECT * with GROUP BY col(s)
- Bigquery - Select a column with not grouping them in group by clause
- What's the difference between BigQuery and Bigtable?
- BigQuery REGEXP_EXTRACT end of URL without unsupported lookback
- SSIS ODBC Google BigQuery (Simba) works in local but return ODBC-1 error when I launch pakcage from SQL Agent
- How to download all data in a Google BigQuery dataset?
- Exporting data from BigQuery into a local PostgreSQL/MySql database
- ValueError: install DBtypes to use this function
- How to calculate ages in BigQuery?
- Connecting Simba ODBC driver for big query issue : REST API Timeout was reached
- Adding new columns to existing bigquery table via API
- How to add a Jinja function to .sqlfluff config
- EXTRACT QUARTER FROM DATE IN BIGQUERY
- Correctly Migrate Postgres least() Behavior to BigQuery
- BigQuery: Running Several Queries Sequentially in One Scheduled Query
- what it means by string is first class type in Bigquery?