Misplaced columns in Google BigQuery Extractor component

2024-07-03 10:22 UTC: On Monday, July 1st, we released version 1.9.0 of the Google BigQuery Extractor. Unfortunately, it has come to our attention that this version does not properly respect the columns selected. Instead, it retrieves all columns, which could result in having different data in different columns than intended.

This issue may affect the accuracy of the data extracted and could lead to discrepancies in your data analysis and reporting.

Current Status:
• We have reverted the Google BigQuery Extractor to the previous version to prevent further impact.
• Our team is actively investigating the root cause of this issue.

Next Steps:
• We are working diligently to develop a fix that will ensure the correct columns are extracted as specified.
• We are also reviewing the data impacted by this issue and will provide further guidance on any corrective actions required.

What You Should Do:
• Review your recent data extractions performed since Monday July 1st 11:54 UTC. You can do that using Workspaces or Data Preview.
• If you notice any discrepancies or have concerns about your data, please contact our support team immediately.

We understand the importance of data accuracy and apologize for any inconvenience this issue may have caused. We are committed to resolving this promptly and keeping you informed throughout the process.

Thank you for your understanding and patience.

2024-07-03 13:15 UTC: We have identified the root cause. The issue occurs if the columns selected in the configuration are in a different order than the columns that already exist in the output table. This can result in:

Data Misplacement: Data in the resulting table being placed under the wrong column.
Import Failures: If the table has more columns than selected in the configuration, the platform attempts to add the missing columns, which caused an import failure.

We have a solution to fix the impacted data. If you find that your data was compromised by this issue, please contact our support team for assistance. They will help you out to revert your data to previous state.

Customer Action Required:
• If you notice any discrepancies or have concerns about your data, please contact our support team immediately.
• Our support team will assist in fixing any compromised data due to this incident.