What is happening?
The connector is failing to push data because the target BigQuery dataset is hosted in a region other than the European Union (EU). Alvie requires the dataset to be located in the EU to comply with data processing standards.
Error: The dataset has an invalid location. The location should be 'EU'.
Why did this happen?
This error typically occurs when a BigQuery dataset is manually created or automatically initialized in a non-EU region (such as US or asia-northeast1). Common causes include:
Default Project Settings: The Google Cloud project defaults to the
USmulti-region.Manual Setup Error: The dataset was created via the BigQuery console without specifically selecting "EU" as the Data Location.
Follow these steps to resolve the issue:
Warning: Deleting a dataset will permanently remove all existing data within it. If you need to preserve historical data, please contact Alvie support before proceeding.
Navigate to External Platform: Open the BigQuery Console in the Google Cloud Platform.
Locate the Source: Find the dataset mentioned in your Alvie configuration. Check the Dataset info to confirm the current location.
Action: * If the dataset contains no critical data: Delete the existing dataset.
Click Create Dataset.
In the Data location dropdown, explicitly select EU (multiple regions in European Union).
External Steps: Ensure the Dataset ID matches exactly what is entered in your Alvie connector configuration.
Verify: Return to Alvie and trigger a manual rerun of the connector. The status should turn Healthy (Green) once it successfully connects to the new EU-based dataset.
Prevention & Tips To avoid seeing this error again:
Regional Consistency: Always verify that the "Data Location" is set to EU during the initial setup of any new Google Cloud project intended for use with Alvie.
Infrastructure as Code: If using scripts to create datasets, ensure the
locationparameter is explicitly set toEU.
If you encounter any further issues or need additional assistance, please don't hesitate to reach out to the Alvie support team.