<@U04SE163WC8> Data loaded as Json in BigQuery Wh...
# ask-ai
a
@kapa.ai Data loaded as Json in BigQuery When using MSSQL Server source connector and BigQuery Destination connector. SOURCE defined namespace was set. How do I make the data in Tabular format.
k
New message text here
a
@kapa.ai Normalisation and transformation are not supported for the connection
k
A message from kapa.ai
Based on the information provided in the knowledge sources, it appears that normalization and transformation operations are not supported for certain connections in Airbyte. This could be due to the specific source and destination connectors you are using, or the version of Airbyte you are running. For example, in one of the [Github issues](https://github.com/airbytehq/airbyte/issues/23398), a user reported that normalization and transformation operations were not supported for a connection using Hubspot as the source connector and S3 as the destination connector in Airbyte version 0.40.32. In another [discussion](https://github.com/airbytehq/airbyte/discussions/38168), it was mentioned that custom transformation and normalization were deprecated and Airbyte recommends using dbt with an orchestrator to run the job to your pipeline for post-transformations to your data. If you are facing this issue, it would be helpful to check the specific source and destination connectors you are using, and their respective versions. If the issue persists, consider raising an issue on the [Airbyte Github](https://github.com/airbytehq/airbyte/issues) or discussing it on the [Airbyte forum](https://discuss.airbyte.io/).
a
@kapa.ai How do I know the version of Airbyte OSS used
k
A message from kapa.ai
The version of Airbyte OSS used can be found in various places depending on where you are looking: 1. In the Airbyte UI: The version of Airbyte you are running is displayed in the bottom left corner of the Airbyte UI. 2. In the Documentation or Tutorials: If you are following a tutorial or documentation, the version of Airbyte used is usually mentioned. For example, in the [tutorial on using Airflow and Airbyte together](https://airbyte.com/tutorials/how-to-use-airflow-and-airbyte-together), the version of Airbyte OSS used was 0.40.32. 3. In the Release Notes: The version of Airbyte can also be found in the release notes. For example, in the [release notes for April 2024](https://docs.airbyte.com/release_notes/april_2024#airbyte-v0570-to-v0580), the versions of Airbyte discussed ranged from v0.57.0 to v0.58.0. 4. In the Public API: The version of the Airbyte Public API is mentioned in the [API reference](https://reference.airbyte.com/reference/start). As of the last update, the API version was 1.0.0. Please note that the version of Airbyte can change with updates and new releases, so it's always a good idea to check the latest version if you are setting up a new instance or updating an existing one.
a
@kapa.ai upgrade Airbyte platforms to 0.63.0
k
A message from kapa.ai
To upgrade your Airbyte platform to version 0.63.0, you can follow these steps: 1. Backup your data: Before starting the upgrade process, it's recommended to backup your data. This is to prevent any data loss in case something goes wrong during the upgrade process. 2. Pull the latest version of Airbyte: You can do this by running the following command in your terminal:
Copy code
docker-compose pull
This command will fetch the latest version of Airbyte from Docker Hub. 3. Run the upgrade command: After pulling the latest version, you can upgrade Airbyte by running:
Copy code
docker-compose up -d
This command will start all the services of Airbyte in the background. Please note that these steps assume that you have Docker and Docker Compose installed on your machine, and that you are using Docker Compose to manage your Airbyte services. If you encounter any issues during the upgrade process, you can refer to the [Airbyte Github issues](https://github.com/airbytehq/airbyte/issues) for help. You can also create a new issue if your problem hasn't been addressed yet. Remember to replace
0.63.0
with the version you want to upgrade to in the commands above.