From the course: Introduction to Modern Data Engineering with Snowflake

Unlock this course with a free trial

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

Loading data using the COPY INTO command

Loading data using the COPY INTO command

So far, our batch ingestion techniques have been no-code or low-code, which is pretty neat. To quickly recap, we've pulled in data from the Snowflake Marketplace, performed ingestion of local data files using the web interface, and performed ingestion of data using the command line interface. Using these techniques, you've seen firsthand how easy it is to get data into Snowflake. Let's now dive into one of the most common and powerful techniques for batch data ingestion: Snowflake's COPY INTO command. The COPY INTO command is a SQL command that allows you to ingest data from stage files into a table. And when I say stage files, I simply mean files that live in a stage. A stage is where a file can be stored before its data is ingested into Snowflake. The stage can be a Snowflake internal stage or an external stage that points to third-party cloud storage. For example, you can create an external stage in Snowflake and specify that the stage should point to, say, an AWS S3 bucket, for…

Contents