Just like translate function, replace function is also one of the widely used string functions in Snowflake. The replace function is commonly used to manipulate the strings or expression. For example, replace the part of sub-string across the input string or expression. In this article, we will check replace function, its syntax, usage with some examples. Snowflake REPLACE Function In general, SQL replace function replaces each instance of a pattern in the input with the value in the string replacement. Snowflake replace removes all occurrences of a specified substring, and…

There are many situations in data warehouse where you need to replace the one character with another. For example, replace special character such as symbol in the input expression with a space or remove it. In this article, we will check how to use the Snowflake TRANSLATE function to replace characters with some examples. Snowflake TRANSLATE Function In general, you can use translate function to translate or replace one or more characters into another set of characters. Snowflake supports the translate function, which performs the same job as translate function…

The cross database access does allows you to access the objects such as tables, view, synonyms, functions that are available on the same cloud warehouse server. In this article, we will check Snowflake cross database access and it's restrictions. Snowflake Cross Database Access Using cross database access method, you can refer the object present in another database. For example, you can refer function present in another database and use result in the current database. select demo_db..isnumeric(to_variant('hello')) is_numeric; +------------+ | IS_NUMERIC | |------------| | False | +------------+ You can use cross…

The data warehouse combines the data from various sources. Sometimes, data will be corrupted or erroneous values are introduced. For example, you may need to filter out non-numeric values from the salary field. In this article, we will check what is the isnumeric function alternative available in Snowflake. We will also check methods that you can use to validate data or expression. Snowflake isnumeric Function Alternative In a relational database such as SQL Server, isnumeric function is available as a built-in numeric function. But, as of now, Snowflake does not…

Snowflake cloud data warehouse supports the DECODE function which is similar to other relational databases such as Redhift, Netezza, Oracle, SQL Server, etc. The DECODE function is used to implement simple case statements. i.e. you can use it to implement simple if-then-else statement. This command is similar to the Snowflake CASE statement. Snowflake SQL DECODE Function The DECODE function compares the select expression to each search expression in order. As soon as a search expression matches the selection expression, the corresponding result expression is returned. Snowflake SQL DECODE Function Syntax…

In a Snowflake, a transaction is a set of SQL statements, both reads and writes on database objects, that are processed as a unit. All the statements in the transaction are either committed or undone using rolled back as a single unit. Similar to other databases such as Redshift, Netezza, etc, Snowflake transactions guarantees ACID properties. In this article, we will discuss about the Snowflake transaction management using BEGIN, COMMIT and ROLLBACK. Snowflake Transaction Management The default automatic commit behavior of the Snowflake database causes each SQL command that runs…