Can we use two different bigquery destinations in Airbyte open source

Yes, you can set up multiple BigQuery destinations in Airbyte Open Source. Each destination configuration would require its own unique settings such as Project ID, Dataset ID, and Service Account Key. Here are the steps to set up a BigQuery destination: 1. Log into your 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. You cannot change the location later. 7. For Default Dataset ID, enter the BigQuery Dataset ID. 8. For Loading Method, select Batched Standard Inserts or GCS Staging. 9. For Service Account Key JSON (Required for cloud, optional for open-source), enter the Google Cloud Service Account Key in JSON format. Be sure to copy all contents in the Account Key JSON file including the brackets. 10. For Transformation Query Run Type (Optional), select interactive to have BigQuery run interactive query jobs or batch to have BigQuery run batch queries. You can repeat these steps to set up another BigQuery destination with different settings. Please note that each destination will have its own unique settings and will operate independently of each other. For more detailed instructions, you can refer to the [BigQuery setup guide](https://docs.airbyte.com/integrations/destinations/bigquery#step-2-set-up-the-bigquery-connector) in the Airbyte documentation.