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.
Noel Gomez
10/26/2021, 11:44 AM
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