Snowflake Directory Tables: Query and Manage Staged Files
Directory Tables in Snowflake provide a structured way to access file metadata in both internal and external stages.
Data Loading and Handling
Snowflake File URLs: Securely Access and Share Staged Files
Snowflake File URLs provides controlled and secure data access to the staged files without exposing the entire stage.
Data Load using COPY INTO Command in Snowflake
The COPY INTO command in Snowflake is a powerful tool for efficiently loading data from staged files into tables.
HOW TO: Make External API calls from Snowflake?
Explore how Snowflake offers a secure and efficient way to make external API calls directly within its environment.
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.
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.
Snowflake Micro-Partitions & Data Clustering
Learn about Snowflake Micro-partitioning method and how the storage can be organized using Data Clustering in Snowflake.