SF0005 – Bulk Loading from a Local File System Using COPY Command

[Peter Jones]

Hi All,
I have found a video on how snowflake gets data from a local hard drive to a snowflake landing table. There is a command called snowsql that gets installed on the server and then you can connect to your snowflake account and issue commands to send local files to the snowflake account.

The snowsql command has an option to gzip the file before sending and then upzipping on the snowflake server when it arrives. I presume it also does the ftp. The specific piece you want to watch is at minute 7.

Bulk Loading from a Local File System Using COPY Command

https://docs.snowflake.com/en/user-guide/snowsql.html

https://docs.snowflake.com/en/user-guide/snowsql-install-config.html

https://docs.snowflake.com/en/user-guide/snowsql-config.html

https://docs.snowflake.com/en/user-guide/snowsql-start.html

https://docs.snowflake.com/en/user-guide/snowsql-use.html

• This topic was modified 3 years, 2 months ago by Peter Jones.
• This topic was modified 2 years, 5 months ago by Peter Jones.

Best Regards
Peter Jones

[Author]

Posts