Is there a way to just store the data data when storing to MSSQL destination? I don't want all of the airbyte JSON output in my tables
s
Sunny Hashmi (Airbyte)
01/10/2023, 3:33 PM
Hey there, because Airbyte is an ELT solution where it loads data into the destination before running transformations, the json blobs and airbyte tables are necessary artifacts of this process. You can however use dbt or another tool to remove the data after airbyte is finished, this three part tutorial shows a few different ways: https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-sql/