I am running an Airbyte instance with version 0.63.3. I want to export all of the historic job, connector, source and destination data to bring into BigQuery as I have already migrated to another instance of BigQuery. How do I do that?

To export all of your historic job, connector, source, and destination data from Airbyte to BigQuery, you would typically follow these steps: 1. Set up BigQuery as a destination in Airbyte. You can do this by logging into your Airbyte account, clicking on "Destinations", and then clicking on "+ New destination". Select "BigQuery" from the "Destination type" dropdown. Enter the necessary details such as your Google Cloud project ID, dataset location, default dataset ID, and service account key JSON. You can find more details on this in the [Airbyte documentation](https://docs.airbyte.com/integrations/destinations/bigquery#step-2-set-up-the-bigquery-connector). 2. Set up a connection between your source (in this case, your Airbyte instance) and the BigQuery destination. This involves specifying the source and destination, setting the sync mode, and scheduling the sync frequency. More details can be found in the [Airbyte documentation](https://docs.airbyte.com/using-airbyte/getting-started/set-up-a-connection). However, it's important to note that the ability to export all historic job, connector, source, and destination data depends on the specific capabilities of the Airbyte connectors for those sources. Not all connectors may support exporting all historic data. Also, please note that the Airbyte version you're using (0.63.3) might not support all the features mentioned in the knowledge sources. You might need to upgrade to a newer version to use some features. For instance, the "Refresh" feature that ensures you have continued access to your data while loading in all historical data from the source is available from version 0.63.7 onwards for BigQuery ([source](https://github.com/airbytehq/airbyte/issues/36295)). Lastly, if you're looking to migrate configurations (like connectors, sources, and destinations) from one Airbyte instance to another, you can export the configuration from the old instance and import it into the new one. This is discussed in several forum posts ([source 1](https://discuss.airbyte.io/t/3514), [source 2](https://discuss.airbyte.io/t/370), [source 3](https://discuss.airbyte.io/t/1768)). However, this might not include job history. For that, you might need to directly access the underlying database where Airbyte stores this information.

@kapa.ai how do I access the underlying database?

To access the underlying database of your system, you will need to reach out to your service representative or system administrator. They should be able to provide you with the parameters required to connect to the database. Depending on the system you are using, you may need to use a specific Airbyte connector. For example, if your system runs on MySQL, you would use the [MySQL connector](https://docs.airbyte.com/integrations/sources/mysql). If it runs on MSSQL, you would use the [MSSQL connector](https://docs.airbyte.com/integrations/sources/mssql). Other connectors include [DB2](https://docs.airbyte.com/integrations/sources/db2), [Oracle](https://docs.airbyte.com/integrations/sources/oracle), and [Postgres](https://docs.airbyte.com/integrations/sources/postgres). Please refer to the specific documentation for your system for more detailed instructions.