Category: Redshift

In this post, we will see how you can create Redshift Stored Procedure with example. We will also talk about redshift stored procedure parameters and dynamic sql in stored procedure. What is a stored procedure ? Stored Procedure (SP) is a database object which encapsulates business transformation logic into one unit. Stored Procedure can consists…

My experience of AWS Certified Solutions Architect – Associate I recently appeared for AWS Certified Solutions Architect (Associate) exam and cleared it comfortably. I would like to share my experience and journey so far which may help you if you are preparing for it too. So let’s begin this post by sharing my background. My…

In this post, we will see a very simple example in which we will create a Redshift table with basic structure and then we will see what all additional properties Redshift will add to it by default. Then we will quickly discuss about those properties and in subsequent posts we will see how these properties…