Companies / Sigma Computing / incidents

Sigma Computing: Query failures for select organizations connected to Snowflake

Impact: criticalStatus: postmortemStarted Resolved (5.1 h)5 updatesSource: stspg.io (opens in new tab)
Summary

Sigma Computing reported a critical incident affecting Snowflake queries for a subset of users on AWS and GCP (US), returning "Bad request; operation not supported." It lasted 5 h 7 min, from 2023-10-03 13:41 UTC to 2023-10-03 18:48 UTC; Snowflake rolled back a server change globally, restoring access to workbooks and data warehouse connections.

Machine-written from the archived incident (Sol). Check the timeline before relying on it.

Affected components: AWS - Sigma - AWS (US)Sigma - AWS (US)GCP - Sigma - GCP (US)Sigma - GCP (US)

Timeline of updates

  1. investigating

    We are investigating an issue with queries resulting in the error message "Bad request; operation not supported." We are treating this as our highest priority. Our apologies for any inconvenience caused.

  2. investigating

    We are investigating an issue with queries resulting in the error message "Bad request; operation not supported." We have engaged with Snowflake support and are treating this as our highest priority. Our apologies for any inconvenience caused.

  3. investigating

    We were able to to reproduce locally and issue is fixed in our environment after Snowflake rolled back a server change on their side. We're now working with them to apply the rollback to all accounts.

  4. resolved

    We have received confirmation from Snowflake that they've rolled back globally for all impacted users. At this time we believe full functionality has been restored and expect all Snowflake users can now access their workbooks and data warehouse connections. Impacted Cloud Regions & Services: Snowflake connections for a subset of Sigma users hosted on GCP and AWS User Experience: Affected users can now access their workbooks and data warehouse connections. Incident Start Time: Approximately 13:00 UTC October 3, 2023 Incident End Time: Approximately 18:03 UTC October 3, 2023 We will perform a root cause analysis (RCA) and publish our findings in a postmortem note to the Sigma Community site in coming days.

  5. postmortem

    Sigma Engineering has completed the postmortem of this incident. A Root Cause Analysis \(RCA\) is available on the Sigma Community site: [Postmortem for Oct 03, 2023 Incident: Query failures for select organizations connected to Snowflake ](https://community.sigmacomputing.com/t/postmortem-for-oct-03-2023-incident-query-failures-for-select-organizations-connected-to-snowflake/2634)

Rewindex changes for this incident

Impact, status and times are the vendor’s own, as last archived. View on stspg.io (opens in new tab). Sigma Computing profile · Recent Sigma Computing incidents · Markdown · JSON