Redshift

How use Lateral Column Alias in Redshift?

Redshift lateral column alias, also known as derived column, is created from previously computed columns in the same SELECT statement. These columns are virtual and not stored in the table; their values are recalculated each time they are used in a query. Many PostgreSQL databases, like Netezza, support lateral column aliases. Recently, Redshift has also started supporting this feature. In this post, let’s explore this new capability. Page Content Introduction Benefits of Using Lateral Column Alias in Redshift How Lateral Column Alias Works in Redshift (with Example) Lateral Column Alias…

Comments Off on How use Lateral Column Alias in Redshift?
September 24, 2024
Snowflake

Snowflake Scripting 101: Error Handling

In my other articles, we have talked about how to use basic blocks in Snowflake scripting, how to use Snowflake cursors and Snowflake scripting control structures. In this article, we will check handling error in Snowflake scripting with some relevant examples. Page Contents Introduction Understanding Errors in Snowflake Handling an Exception in Snowflake Scripting Built-in Variables in Snowflake Error Handling Declaring an User-Defined Exception in Snowflake Raising a Declared Exception in Snowflake Basic Snowflake Error Handling Examples Snowflake Anonymous Block with Error Handling Examples Snowflake Stored Procedure with Error Handling…

Comments Off on Snowflake Scripting 101: Error Handling
January 22, 2024
Snowflake

Snowflake Scripting 101: Control Structures

In my other articles, we have talked about how to use basic blocks in Snowflake scripting , how to use Snowflake cursors and Snowflake scripting error handling. In this article, we will check Snowflake scripting control structures such as IF, WHILE, FOR, REPEAT and LOOP with some relevant examples. Page Contents Introduction Fundamental Control Structures in Snowflake Snowflake Conditional control structures and Examples IF Statement Example: Snowflake Script Stored Procedure with IF-ELSE Block Snowflake Iterative control structures and Examples WHILE loops in Snowflake FOR loops in Snowflake REPEAT in Snowflake…

Comments Off on Snowflake Scripting 101: Control Structures
January 19, 2024
Snowflake

Snowflake Scripting 101: Snowflake Cursors

In another article, we talked about using blocks in Snowflake scripting and Snowflake scripting error handling.. Now, let's learn about something called the Snowflake cursors. We'll see how to use it in stored procedures and anonymous blocks. Page Content Introduction to Snowflake Cursors Understanding Cursor in Snowflake Cursor Syntax and how to use it? Declaring Cursors Opening Cursors Fetching Data from Cursors Closing Cursors Advanced Cursor Techniques Bulk fetching Avoiding large result sets Snowflake Cursor Examples Snowflake Anonymous Block with Cursor Snowflake Stored Procedure with Cursor Returning a Table for…

Comments Off on Snowflake Scripting 101: Snowflake Cursors
January 15, 2024
Snowflake

Snowflake Scripting 101: Blocks in Snowflake Scripting

Harness the full potential of Snowflake scripting to streamline data operations and automate complex business logics. Dive into this practical guide to discover how scripting blocks transform your Snowflake scripting experience, enabling: Precise control over data flows Optimized conditional logic Efficient looping structures Custom error handling And more! Page Content Understanding Blocks Structure of Block in a Snowflake Scripting Types of Blocks in Snowflake Scripting Common Block Use Cases Advanced Block Techniques Conclusion Understanding Blocks in Snowflake Scripting In Snowflake Scripting, blocks serve as essential building blocks for organizing and…

Comments Off on Snowflake Scripting 101: Blocks in Snowflake Scripting
January 15, 2024
Snowflake

How to Create Synonyms in Snowflake – Alternate Method

Relational databases utilize synonyms to conveniently assign names to lengthy tables, view names, or other objects like sequences, procedures, functions, and materialized views. Netezza and Oracle databases offer support for creating and managing synonyms. Synonyms serve as an alternative means of referencing tables or views within the current or other databases. However, Snowflake database presently lacks support for creating synonyms. In this article, we will explore an alternative method that resembles create synonyms in Snowflake. Page Content Introduction Understanding Synonyms in Databases Does Snowflake support Create Synonyms? Alternate Method for…

Comments Off on How to Create Synonyms in Snowflake – Alternate Method
May 31, 2023
Redshift

Redshift Pivot and Unpivot Functions: A Comprehensive Guide

Pivot and unpivot are common functions in relational databases for converting rows to columns and vice versa. These function are supported by many relational databases, including Amazon Redshift, which has recently added support for PIVOT and UNPIVOT functions. However, other methods such as CASE or DECODE can be used as alternatives for converting rows to columns or columns to rows. In this article, we will explore the Redshift pivot and unpivot table functions in detail for transforming your data. Post Content Introduction Redshift Pivot and Unpivot Functions Pivot Tables in…

Comments Off on Redshift Pivot and Unpivot Functions: A Comprehensive Guide
April 26, 2023
Redshift

Change Redshift Table Distribution: A Guide with Examples

Selecting an appropriate distribution style is a crucial factor in enhancing the efficiency of the Redshift Database. The distribution style you choose can have a direct impact on your query's performance. Using an incorrect distribution style for a table may adversely affect your Redshift cluster due to increased workload. This article will demonstrate how to change the distribution style of a Redshift table, along with an illustrative example. Page Content Introduction Redshift Table Distribution Styles Why to Change Redshift Table Distribution style? How to Change Redshift Table Distribution Style Changing…

Comments Off on Change Redshift Table Distribution: A Guide with Examples
April 20, 2023
Redshift

How to Choose the Right Distribution Style in Redshift?

Amazon Redshift uses the Massively parallel processing (MPP) technique, Redshift optimally distributes data and query load across all nodes available in the cluster. In this article, we will check how to choose the Right distribution style in Redshift and the importance of right distribution key. Right Distribution Style in Redshift When choosing a distribution style, it's important to consider the size and structure of your data and the types of queries you'll be running. Following are a few best practices to keep in mind while choosing an Amazon Redshift Data…

Comments Off on How to Choose the Right Distribution Style in Redshift?
February 3, 2023
Redshift

What are Amazon Redshift Distribution Styles? – Examples

Amazon Redshift is one of the popular cloud-based data warehousing solution offered by Amazon Web Services (AWS). Amazon Redshift is a cluster of nodes with separate disks, memory and CPU. One of the important features of Amazon Redshift is the ability to choose from different distribution styles to manage the distribution of data and computation across nodes in a cluster. In this article, we'll discuss the different Amazon Redshift distribution styles and the best practices for choosing the right Redshift distribution style for your needs. Amazon Redshift Key Distribution Styles…

Comments Off on What are Amazon Redshift Distribution Styles? – Examples
February 3, 2023