How can we insert 40 lac record in Snowflake via Alteryx in one go.
use the bulk loader. this should be fine.
I tried but it is giving me error stating that PRIV_KEY File Error
can you show a screen grab? whats your config on your snowflake in-db in the bulk loader or your output data/snowflake bulk loader? basically - this is an issue with your connection to snowflake/set up - not with the number of records. The number of records shouldn't really matter here (until you get up to a few million)...