From the course: Snowflake SnowPro Core Cert Prep

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Key commands

Key commands - Snowflake Tutorial

From the course: Snowflake SnowPro Core Cert Prep

Start my 1-month free trial Buy for my team

Key commands

“

In this section, we're going to outline the different commands used to load data and when they should be used. So the first one we've got a PUT command. Now, this is used when you want to stage your data from a local folder on your machine to an internal stage in Snowflake, and to use the PUT command as follows. So we've got put file. We provide the directory location fully qualified to the file. And then we're specifying our internal stage as well as a compression option as well. Next up, we've got the COPY INTO command. So once you've staged your data in either an external or internal stage, you can load your data into a pre-existing target table using the COPY INTO command. COPY INTO also support some basic transformations of the data, including reordering of columns and excluding certain columns and casting of data types. Let's just take a quick look at what this looks like. Now, note and remember for the certification, you can't filter data as part of the COPY INTO command using…

Contents