Road to Snowflake SnowPro Core Certification: PUT & GET commands

Ninth Chapter: PUT and GET commands

Gonzalo Fernandez Plaza

--

Ninth Chapter of the Snowflake SnowPro Core Certification Complete Course.
Ninth Chapter of the Snowflake SnowPro Core Certification Complete Course.

The first step to load data into Snowflake tables is to send it to the Stages. In this chapter, we are going to understand how to do that. Once there, we will copy the data into the tables using either the COPY INTO command for batch files or SnowPipe for continuous data, as we saw in the previous chapter.

  1. PUT command
  2. GET command
  3. Typical exam questions

Remember that all the chapters from the course can be found in the following link.

PUT COMMAND

We will use the PUT command to UPLOAD files from a local directory/folder on a client machine into INTERNAL STAGES (named internal stage, user stage, or table stage). It does NOT work with external stages. It doesn’t copy the files in the tables; it copies them into the internal stages. After this command, if you want to move the data into tables, you need to use the COPY INTO command. You cannot use the PUT command from the Snowflake Web UI (and this is a typical exam question).

As we can see in the following diagram, the files are in the Local File System from the user. Using the PUT command using SnowSQL, the files are moved to the internal…

--

--

Gonzalo Fernandez Plaza

Computer Science Engineer & Tech Lead 🖥️. Publishing AWS & Snowflake ❄️ courses & exams. https://www.fullcertified.com