Data Loading Tutorials¶
The following tutorials provide examples you can follow as you learn to load data into Snowflake:
- Tutorial: Loading Basic CSV Files from a Local File System Using COPY
- Tutorial: Loading Data from a Local File System Using COPY
- Tutorial: Loading Data from Amazon S3 Using COPY
In this Topic:
Using These Tutorials¶
Practice Database and/or Schema¶
For convenience and to avoid mixing your data, we recommend that you create a separate database and/or schema for completing practice exercises, including Snowflake tutorials. Make certain to grant the USAGE privilege on a practice database and schema to any roles whose members will follow the tutorials. Also grant the following schema privileges, which are required to create specific objects in the schema:
- CREATE FILE FORMAT
- CREATE STAGE
- CREATE TABLE
Also, each of these tutorials requires an active warehouse to load data and execute queries. Grant the following virtual warehouse privileges to the same role:
- OPERATE
- USAGE
For example:
grant usage on database mydb to role analyst;
grant usage, create file format, create stage, create table on schema mydb.public to role analyst;
grant operate, usage on warehouse mywh to role analyst;
Usage Credits¶
Each tutorial requires an estimated 30 minutes or less to complete, with an average Snowflake credit usage of 1 credit for an X-Small warehouse.