A Redshift Window function is a highly effective method to write queries for analytics, dashboards and reports. Window functions are a bit on the higher end of sql skills; however, I promise you, once you
Redshift data types are not a whole lot different from the standard relational database types. Relational Databases store data in tables, which are made up of rows and columns. A column is the smallest granularity
In this post we will address Spark SQL Date Functions, its syntax and what it does. There are 28 Spark SQL Date functions, meant to address string to date, date to timestamp, timestamp to date,
Aah…. duplicates! They are everywhere! Look around you – multiple charger cables, headphones, pictures in your smartphone! But we are not here to talk about those duplicates. No, Sir! We are here to address the duplicates in databases, how to find them and possibly resolve them in your SQL code.
In this post on SQL How to add a column, let us look at 4 different approaches to adding columns to a database table. But first, let’s start with some context. A column is the
Before we dive into the details of AWS Lambda CLI, it is important to understand what Lambda is. AWS Lambda is a compute web service that executes code in response to events. You do this
Amazon Redshift vs RDS In this post, let us look at Amazon Redshift vs RDS and the 6 significant differences between the two. To quote Lao Tzu, “A journey of a thousand miles, starts with
In this blog post, let us look at some Redshift Create Table Examples, 10 to be exact ! However, before we get started, what exactly is Redshift ? Amazon Redshift is a cloud based data
Before we dive into the details of CloudFormation Parameters, lets build some context around what CloudFormation is. It is a service by Amazon, used to model, provision and configure AWS resources in the Cloud. You do
If your are a beginner, understanding the basics of Apache Spark will help you build a strong foundation before you get to the more complex concepts. Often times these concepts are intertwined with new terminology.