The document provides steps for loading data from AWS S3, Azure, and Google Cloud Storage into Snowflake. It describes creating a storage integration between Snowflake and the external storage services, defining external stages to reference the locations of data files, and using the COPY command to load the files into Snowflake tables.
The document provides steps for loading data from AWS S3, Azure, and Google Cloud Storage into Snowflake. It describes creating a storage integration between Snowflake and the external storage services, defining external stages to reference the locations of data files, and using the COPY command to load the files into Snowflake tables.
The document provides steps for loading data from AWS S3, Azure, and Google Cloud Storage into Snowflake. It describes creating a storage integration between Snowflake and the external storage services, defining external stages to reference the locations of data files, and using the COPY command to load the files into Snowflake tables.
The document provides steps for loading data from AWS S3, Azure, and Google Cloud Storage into Snowflake. It describes creating a storage integration between Snowflake and the external storage services, defining external stages to reference the locations of data files, and using the COPY command to load the files into Snowflake tables.
// S3 -- Simple Storage Service // IAM -- Integrated Account Management
----------------------------------- // Create database and schema CREATE DATABASE IF NOT EXISTS MYDB; CREATE SCHEMA IF NOT EXISTS MYDB.file_formats; CREATE SCHEMA IF NOT EXISTS MYDB.external_stages;
// Create file format object
CREATE OR REPLACE file format mydb.file_formats.csv_fileformat type = csv field_delimiter = '|' skip_header = 1 empty_field_as_null = TRUE;
// Create stage object with integration object & file format object CREATE OR REPLACE STAGE mydb.external_stages.aws_s3_csv URL = 's3://awss3bucketjana/csv/' STORAGE_INTEGRATION = s3_int FILE_FORMAT = mydb.file_formats.csv_fileformat ;
//Listing files under your s3 buckets
list @mydb.external_stages.aws_s3_csv;
// Create a table first
CREATE OR REPLACE TABLE mydb.public.customer_data ( customerid NUMBER, custname STRING, email STRING, city STRING, state STRING, DOB DATE );
// Use Copy command to load the files
COPY INTO mydb.public.customer_data FROM @mydb.external_stages.aws_s3_csv PATTERN = '.*customer.*';
//Validate the data
SELECT * FROM mydb.public.customer_data;
Steps to Load data from Azure
------------------------------ Step 1: Create storage integration between Snowflake and Azure: https://docs.snowflake.com/en/user-guide/data-load-azure-config.html
