HOW TO: Find and Kill long running queries in Snowflake?
Learn how to find and kill long running queries in Snowflake using the QUERY_HISTORY table functions available under Information Schema.
Snowflake
HOW TO: Get DDL of database objects in Snowflake?
Snowflake provides GET_DDL Function using which DDL of database objects like tables, views, procedures etc., can be extracted.
Top Snowflake Interview Questions
A complete collection of top Snowflake Interview questions and answers
Snowflake Dynamic Data Masking
Snowflake Dynamic Data Masking is a security feature that allows you to mask sensitive data in database tables, views, and query results in real-time.
HOW TO: Remove Duplicates in Snowflake?
Learn different ways to remove duplicate records from a Snowflake table using SWAP WITH and INSERT OVERWRITE commands.
Snowflake Resource Monitors
Snowflake Resource Monitors assist in cost management and prevent unforeseen credit usage caused by operating warehouses.
Snowflake Information Schema
The INFORMATION_SCHEMA is a read-only schema available automatically under each database. It stores metadata of all the objects built under the database.
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.
Overview of Snowflake Role Based Access Control
Learn various system define roles in Snowflake, their purpose and how you can create custom roles and Role Hierarchy.