Explained: RIGHT() function in Snowflake ?

Are you looking to find how to use the RIGHT() function within the Snowflake cloud data warehouse or maybe you are looking for a solution to use the String function in the Snowflake? If you are looking for any of these problem solutions then you have landed on the correct page. I will also show you what and how to use the RIGHT() function. I will explain the RIGHT() function by taking a practical example. So don’t waste time let’s start step by step guide to understanding what is the RIGHT() expression.

What is RIGHT() Function?

Right() function helps to get the rightmost substring from the given input expression. If the given length is zero, then the resultant will be empty string.

How can we use RIGHT() Function ?

The RIGHT() function is used to return the rightmost substring of its input.

What is the syntax of the Right() function?

-- Syntax : 

RIGHT ( String_expression, Length )

RIGHT() Argument Details :

String_expressionString  or Binary value ( Mandatory )
LengthInteger ( Mandatory )

String_expression :

String value that should be the input on which the function is performed to get the substring.

Length :

Here the value should be an integer.

  • The number of characters to return if the given input is in varchar.
  • The number of bytes to return if the given input is in binary.

Return :

The data type of returned value is the same as the input data type.

Examples of Right Function in Snowflake:

select right('ABCDEFGH', 2);

+----------------------+
| RIGHT('ABCDEFGH', 2) |
|----------------------|
| GH                   |
+----------------------+

As we can see from the above example we got the last two characters as the output as we mentioned 2 in the place of length.

Full Example of RIGHT() function in Snowflake?

-- Create a table

create or replace TABLE EMP1 (
	ID NUMBER(38,0),
	NAME VARCHAR(30),
	INFO VARCHAR(20),
);

-- Insert Data

insert into emp(id,name,amount) values 
(1,'Ram'),
(2,'RAJU'),
(3,'Sameer'),
(4,'Sai Kumar'),
(5,'Naveen Sai'),
(6,'Seshi Kumar'),
(7,'Rajiv Ram'),
(8,NULL)


-- Table Data

SELECT * from emp;
+----+-------------+----------+
| ID | NAME        | INFO     |
|----+-------------+----------|
|  1 | Ram         | NOT-NULL |
|  2 | RAJU        | NOT-NULL |
|  3 | Sameer      | NOT-NULL |
|  4 | Sai Kumar   | NOT-NULL |
|  5 | Naveen Sai  | NOT-NULL |
|  6 | Seshi Kumar | NOT-NULL |
|  7 | Rajiv Ram   | NOT-NULL |
|  8 | NULL        | NOT-NULL |
+----+-------------+----------+

-- Applying Right function to the table data.

select id,name,right(name,3) as Right from emp ;
+----+-------------+-------+
| ID | NAME        | RIGHT |
|----+-------------+-------|
|  1 | Ram         | Ram   |
|  2 | RAJU        | AJU   |
|  3 | Sameer      | eer   |
|  4 | Sai Kumar   | mar   |
|  5 | Naveen Sai  | Sai   |
|  6 | Seshi Kumar | mar   |
|  7 | Rajiv Ram   | Ram   |
|  8 | NULL        | NULL  |
+----+-------------+-------+

When you should use RIGHT() Function in Snowflake?

There are certain use case scenarios when it is recommended to use the RIGHT function within the Snowflake cloud data warehouse which are as follows:

  • If you want to get the right most string or an expression then we can make use of this function.

Real World Use Case Scenarios for RIGHT Function in Snowflake

  • We can get the last names of the customers from their company accounts.
  • We can also get the contact number excluding the extension.

RIGHT() Snowflake Official Documentation Link

Final Thoughts

In this article, we have learned about the RIGHT() function and uses with the examples explained clearly. I have also covered different scenarios with a practical example that could be possible. I hope the information that was provided is helped in gaining the knowledge.

Please share your comments and suggestions in the comment section below and I will try to answer all your queries as time permits.

Leave a Comment