Snowflake

Replace Function in Snowflake – Usage and Examples

The Replace function in Snowflake is one of the commonly used functions in string manipulations. For example, you can use the replace function to remove the unwanted or junk characters from your string. This function is similar to the translate function available in Snowflake. We will discuss about translate function in another post. For now, let us continue with the replace function, its syntax and some examples. Replace Function in Snowflake Replace Function in Snowflake In general, replace function in SQL replaces each instance of a pattern in the input…

Comments Off on Replace Function in Snowflake – Usage and Examples
May 31, 2022
Snowflake

How to Handle Error in Snowflake Procedures and Functions?

Snowflake Cloud data warehouse supports stored procedures and user defined functions to help migration from other relational databases such as Oracle, Teradata. You can write stored procedures using JavaScript APIs. You can also write user defined functions using JavaScript APIs. JavaScript support error handling using try/catch block. However, Snowflake also supports built-in functions such as try_cast to handle error during type conversion. In this article, we will check how to handle error in Snowflake procedures and functions. Snowflake Stored Procedure How to Handle Error in Snowflake? The Snowflake cloud database…

Comments Off on How to Handle Error in Snowflake Procedures and Functions?
February 18, 2022
Snowflake

How to Handle NULL in Snowflake? Functions

Snowflake is one of the leading cloud databases that you can use to create cloud data warehouse. It is built for a cloud and supports almost all features that are available in the current on-premises or cloud databases. In my other article, we have seen why you should learn Snowflake database. In this article, we will check how to handle NULL values in a Snowflake cloud database. We will also check null handling functions available in Snowflake. How to Handle NULL in Snowflake? A NULL value in any relational database is a…

Comments Off on How to Handle NULL in Snowflake? Functions
February 10, 2022
Snowflake

Why You Should Learn Snowflake? Complete Features

Snowflake is an analytic data warehouse on cloud provided as Software-as-a-Service (SaaS). The Snowflake database support ANSI SQL with added functionalities. It is faster and easier to use cloud data warehouse compared other cloud databases such as Redshift, Azure Synapse or GCP BigQuery. In this article, we will explain why you should learn Snowflake cloud database. We will also check the features that makes Snowflake a unique cloud database for data warehouse design. Why You Should Learn Snowflake? Snowflake is a cloud database specifically designed for a cloud. As per…

Comments Off on Why You Should Learn Snowflake? Complete Features
January 24, 2022