https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
n

Noel Gomez

10/25/2021, 10:47 PM
when loading a file from S3 to Snowflake, is it possible to prevent airbyte from inferring the table schema? e.g. I want everything to load as raw strings and I will cast with dbt, but I see some cols are coming in as integer. I set the connection with Raw data - no normalization
👀 1
h

Harshith (Airbyte)

10/26/2021, 5:32 AM
Hey Noel is there some problem in converting it from the raw tables ?
n

Noel Gomez

10/26/2021, 11:43 AM
I think it is safer to load all as strong and determine proper casting later. When I select raw I expected raw. Also, I think this is adding time to the initial setup because it is scanning all files in a directory.
Also providing a schema works, but it is a lot of work since table has 300+ cols
h

Harshith (Airbyte)

10/26/2021, 4:02 PM
Got it. Do you mind creating a feature request in github
n

Noel Gomez

10/27/2021, 12:37 AM
h

Harshith (Airbyte)

10/27/2021, 2:51 AM
Thanks Noel. Team will look into it some time
4 Views