Snowflake - Different methods of Data Loading
This video is on 4th module of snowflake certification and covering below topics
Domain 4.0: Data Loading and Unloading
4.1 Define concepts and best practices that should be considered when loading data.
Stages and stage types
File size
File formats
Folder structures
Adhoc/bulk loading using the Snowflake UI
4.2 Outline different commands used to load data and when they should be used.
CREATE PIPE
COPY INTO
GET
INSERT/INSERT OVERWRITE
PUT
STREAM
TASK
VALIDATE
Links :
Snowpipe using AWS S3:
https://anupamkushwah.medium.com/snowflake-snowpipe-automated-data-loading-from-s3-bucket-b395f8d508da
File Formats:
https://docs.snowflake.com/en/sql-reference/sql/create-file-format