Data Loading and Handling

Learn how to implement SCD Type 1, 2, and 3 in Snowflake with practical SQL examples for handling dimension changes.

Identifying table structures from raw files and create tables dynamically using INFER_SCHEMA function in Snowflake.

Event Tables in Snowflake collect telemetry data (logs, traces, events) from components like stored procedures, UDFs.

The COPY INTO command in Snowflake enables unloading data from tables into internal or external stage locations in formats like CSV, JSON, or Parquet.

Snowflake File URLs provides controlled and secure data access to the staged files without exposing the entire stage.

The COPY INTO command in Snowflake is a powerful tool for efficiently loading data from staged files into tables.

Explore how Snowflake offers a secure and efficient way to make external API calls directly within its environment.

Learn how to perform Insert, Multi-Row Insert and Multi-Table Inserts in Snowflake using INSERT and INSERT ALL statements.

An Externally Managed Iceberg Table is a table where an external system such as AWS Glue manages both the table data and metadata.

A Snowflake Iceberg table Snowflake employs the Apache Iceberg format for organizing and storing data within the Snowflake data warehouse environment.