From the course: Introduction to Modern Data Engineering with Snowflake
Unlock this course with a free trial
Join today to access over 24,400 courses taught by industry experts.
Loading data using snowflake’s web interface - Snowflake Tutorial
From the course: Introduction to Modern Data Engineering with Snowflake
Loading data using snowflake’s web interface
Another powerful way of ingesting data into Snowflake is by using one of the various options within Snowflake's web interface. In this video, we'll specifically cover how to ingest data from a local file directly into a table in Snowflake. But don't worry, you'll get a glimpse of all of the available options within your account shortly. Using the web interface is ideal when you have data that is ready to load and you need a quick and straightforward way of loading it into Snowflake. This might be something you do for an initial data migration, periodic data updates, or maybe one-off uploads. What's great is that Snowflake supports a variety of different file formats, and the UI is a fast way of getting data into Snowflake without having to worry too much about the format of the file. For example, Snowflake easily handles CSV, JSON, Parquet, XML, and many other file formats. But Snowflake can go even further. If you're loading data that's been compressed, Snowflake can also handle…
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)
-
-
-