Snowflake SnowPro Advanced Architect Certification Preparation
Explore the Snowflake SnowPro Advanced Architect Certification topics that may appear on the exam and enhance your preparation.
Snowflake
This category includes various articles about Snowflake.
SnowPro Advanced Architect Certification Exam Cram
Prepare effectively for the SnowPro Advanced Architect Certification with essential concepts and strategies for success.
Unlock Instant Data Quality and Data Enrichment on Snowflake Marketplace
This webinar is a must for IT professionals, data analysts, and business leaders who are eager to seamlessly enhance their data quality – a critical value in improving operational efficiency and driving better decision-making.
Snowflake Resource Monitors to Track Resource Usage
Learn about Snowflake resource monitors to track resource usage. This article covers how to set up, configure, and enable notifications.
Simple Examples to Mask Sensitive Data in Snowflake
In this article, we look at how you can mask sensitive data in Snowflake with a few simple examples to show how this can be done.
Compare Snowflake vs SQL Server GREATEST and LEAST Functions
In this article, we look at how to find the LEAST and GREATEST values in a set of numbers for Snowflake and SQL Server.
Snowflake SELECT Statement Unique Features
This article addresses the SQL SELECT statement and sheds light on some of its unique features in Snowflake.
Snowflake Scoped Transactions Behavior and Examples
In this article, we illustrate the behavior of scoped transactions when using Snowflake along with examples.
Snowflake Transactions in Stored Procedures
In this article, we discuss transactions in Snowflake and specifically transactions inside stored procedures.
Replace OUTER APPLY and CROSS APPLY with LEFT JOINs for Snowflake
Learn how to convert OUTER APPLY and CROSS APPLY joins using LEFT JOINS in Snowflake since OUTER APPLY and CROSS APPLY are not supported.
Learn How Snowflake Creates and Detects Deadlocks for Data Integrity
In this article, we look at how Snowflake handles deadlocks and the process of creating a deadlock and detecting a deadlock.
Transactions in Snowflake Stored Procedures with Code Examples
Learn about using transactions in stored procedures when working with Snowflake with these code examples and explanations.
Compare Snowflake Temporary and Transient Tables with SQL Temp Tables
Learn about the similarities and differences between Snowflake temporary tables and transient tables versus SQL temporary tables.
Learn about Snowflake Temporary Tables vs. Snowflake Transient Tables
Learn about Snowflake temporary tables and transient tables along with their similarities and differences and when to use these types of tables.
Snowflake NULL Functions – NVL2, ZEROIFNULL, EQUAL_NULL, IS_NULL_VALUE
Learn about NULL functions that exist in Snowflake but not in SQL Server like NVL2, ZEROIFNULL, EQUAL_NULL, and IS_NULL_VALUE.
SQL Server and Snowflake NULL Functions – ISNULL, COALESCE, NULLIF
Learn how to handle NULL values in Snowflake with this article that does a comparison of NULL related functions for SQL Server and Snowflake.
Create Transactions in Snowflake Plus Useful Commands for SQL Devs
In this article, we look at how to create transactions when using Snowflake along with several commands specific to working with transactions.
Snowflake Constraints Primary Key, Unique Key, Foreign Key, Not Null
In this article, we look at constraints in Snowflake like PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, and NOT NULL and how they are enforced in Snowflake.
DDL and DML Statements in transactions for SQL Server and Snowflake
In this article, we look at running DDL and DML statements in transactions for SQL Server and with Snowflake to see how these are handled differently.
Snowflake Transactions vs SQL Server Transactions
In this article we explore how to use transactions and a comparison of transactions in SQL Server versus Snowflake.
Snowflake vs SQL Server for a Data Warehouse
In this article we take a high level view of choosing to use Snowflake in the cloud versus SQL Server on-premises and some things to consider.
Why Choose a Snowflake Data Warehouse
In this article we look at some reasons why you might want to consider using Snowflake for your next data warehouse.
Understanding Snowflake Data Warehouse Capabilities
Learn about capabilities of Snowflake like security, governance, replication and failover features along with integration with Azure resources.
Snowflake Streams for Change Data Capture Scenario
In this article we look at using streams in Snowflake to set up a change data capture scenario where only new or modified rows are processed.