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 - Snowflake Tutorial
From the course: Introduction to Modern Data Engineering with Snowflake
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
What is data ingestion?3m 49s
-
(Locked)
Batch ingestion with snowflake4m 14s
-
(Locked)
Loading data from snowflake marketplace6m 27s
-
(Locked)
Loading data using snowflake’s web interface7m 18s
-
(Locked)
Optimize compute resources for efficient batch ingestion6m 56s
-
Loading data using snowflake CLI7m 55s
-
(Locked)
Loading data using the COPY INTO command8m 19s
-
(Locked)
Scenario briefing and account setup2m 15s
-
(Locked)
Ingesting data from other data systems using connectors3m 8s
-
(Locked)
Recap and best practices for batch ingestion3m 8s
-
(Locked)
-
-
-