INSERT and Multi-Table Inserts in Snowflake
Learn how to perform Insert, Multi-Row Insert and Multi-Table Inserts in Snowflake using INSERT and INSERT ALL statements.
Data Loading and Handling
Creating Snowflake Iceberg tables using AWS Glue as Catalog
An Externally Managed Iceberg Table is a table where an external system such as AWS Glue manages both the table data and metadata.
HOW TO: Create Snowflake Iceberg Tables?
A Snowflake Iceberg table Snowflake employs the Apache Iceberg format for organizing and storing data within the Snowflake data warehouse environment.
HOW TO: Load and Query JSON data in Snowflake?
Snowflake supports loading JSON data in database tables and allows querying data along with flattening it into a columnar structure.
Snowflake File Formats
Snowflake File format simplifies the process of accessing the staged data and streamlines data loading/unloading in database tables.
Types of Views in Snowflake
There are three different types of views in Snowflake – Non-Materialized, Materialized and Secure Views.
HOW TO: Create Snowflake External Tables?
A quick guide explaining what are Snowflake External tables and how to create them using various methods.
HOW TO: Create External Stages in Snowflake
Learn how to create external stages on AWS S3, Microsoft Azure and Google Cloud platforms in Snowflake.
Types of Snowflake Stages: Data Loading and Unloading Features
A complete guide to types of Snowflake Stages and how to load data into and unload data from Snowflake tables using stages.
Types of Snowflake Tables
Snowflake supports three types of tables namely Permanent, Temporary and Transient tables.