Hi everyone, am loading a table into snowflake, the table is about 1.4Gb and it has 160M records, and is taking about 15 hours, how can i optimized the process in airbyte?

are you using internal staging?

am not sure, am using the standar normalization, after that nothing else

i mean for snowflake

in snowflake it takes about 11 seconds to load the data, like 300,000 records

Can you check in your sync how much normalizatoin takes to run? Normalization runs in Snowflake side and if it's taking a long time you need to increase resources in your Snowflake instance.

for example is taking about 6-8 min to load 1M

Yes, but you need to change the connector code and re-build the connector image.

in the snoflake conector how does it work, i haven't being able to change that

The batch size is related to source and not destination