Al-Moatasem Mohammad
10/29/2023, 11:38 AMme-central1 region, however, this region is not listed in Airbyte open-source / API
how to handle this case?kapa.ai
10/29/2023, 11:38 AMme-central1 is not listed in the Airbyte open-source / API, it might not be currently supported. Here are the steps to set up the BigQuery connector in Airbyte: 1. Log into your Airbyte Cloud or Airbyte Open Source account. 2. Click Destinations and then click + New destination. 3. On the Set up the destination page, select BigQuery from the Destination type dropdown. 4. Enter the name for the BigQuery connector. 5. For Project ID, enter your Google Cloud project ID. 6. For Dataset Location, select the location of your BigQuery dataset. If your specific region is not listed, you might need to choose a different region that is supported. 7. For Default Dataset ID, enter the BigQuery Dataset ID. 8. For Loading Method, select Standard Inserts or GCS Staging. Airbyte recommends using the GCS Staging option. 9. For Service Account Key JSON, enter the Google Cloud Service Account Key in JSON format. 10. For Transformation Query Run Type, select interactive to have BigQuery run interactive query jobs or batch to have BigQuery run batch queries. Please note that you cannot change the location later. If your specific region is not supported, you might need to contact Airbyte support or check their documentation for updates or workarounds. Source: [Airbyte Documentation](https://docs.airbyte.com/integrations/destinations/bigquery)Al-Moatasem Mohammad
10/29/2023, 12:03 PMAl-Moatasem Mohammad
10/29/2023, 12:50 PMkapa.ai
10/29/2023, 12:50 PM