Cant transform data from CSV to MS SQL Server as transform option is missing #48753
Unanswered
nkemter
asked this question in
Connector Questions
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I'm currently able to load data from the CSV file into MS SQL Server. There it is stored in a single column as JSON in a separate table. However, I want to store the data in an existing table and want to specify which CSV column should be stored in which table column and also I want to transform some data while loading (mostly: Column A * Column B = Column C and transform a date 2022-04-01 to 220104).

The problem is that I cannot find the option where I should be able to specify the transformation. According to several tutorials there is a menu missing on the right side. My UI looks like this
I use open source with those versions:
SUCCESS Found Docker installation: version 20.10.23
SUCCESS Existing cluster 'airbyte-abctl' found
INFO Found helm chart 'airbyte-abctl'
Status: deployed
Chart Version: 1.2.0
App Version: 1.2.0
INFO Found helm chart 'ingress-nginx'
Status: deployed
Chart Version: 4.12.0-beta.0
App Version: 1.12.0-beta.0
INFO A new release of abctl is available: v0.21.0 -> v0.22.0
Beta Was this translation helpful? Give feedback.
All reactions