What is Apache Spark – explained using mind maps
This blog post introduces the basic of Apache Spark concepts, with an overview of Resilient Distributed Datasets (RDD), DataFrames and more.
May 18, 2022
Menu
Blog
Read More »
Redshift materialized views: The good, the bad and the ugly
A comprehensive post on Materialized views in Redshift focused on its best features such as auto rewriting, limitations and best practices
April 25, 2022
Redshift Coalesce: One for all and all for NULL
Coalesce means to combine! Redshift Coalesce is a conditional expression which returns the first non-null value from multiple input values. The beauty of coalesce is,
April 10, 2022
15 Redshift date functions – frequently used by most developers
This post on Redshift date functions is intended to simplify the core list of date functions. The 15 date functions with examples are the most
March 29, 2022
What is Amazon Redshift you ask?
Amazon Redshift is more than just an optimized relational database, able to handle structured, unstructured and semi-structured data
October 13, 2021
SQL Add a New Column: 4 ways with examples
SQL How to Add a column explained using DROP, ALTER, CTAS and CREATE methods. 4 examples to sql add column in a database agnostic way
September 15, 2021
Athena SQL basics – How to write SQL against files
Athena SQL is the query language used in Amazon Athena to interact with data in S3. Mastering Athena SQL is not a monumental task if
September 14, 2021
14 Redshift Data Types to make you the office hero
The less is more approach to Redshift data types. Focus on these 14 character, numeric, datetime and boolean data types in Redshift.
September 14, 2021
CloudFormation Parameters: Make your life simple
Learn how to use CloudFormation parameters in your template. Master the basics of CloudFormation parameter types & properties from examples.
September 13, 2021
Spark Scala Examples: Your baby steps to Big Data
This post elaborates on Apache Spark transformation and action operations by providing a step by step walk through of Spark examples in Scala. Before you
September 10, 2021
SQL Find Duplicates Like a Pro: 3 Guaranteed Techniques
Aah…. duplicates! They are everywhere! Look around you – multiple charger cables, headphones, pictures in your smartphone! But we are not here to talk about
September 8, 2021
10 Redshift Create Table Examples to make you an expert
In this blog post, let us look at some Redshift Create Table Examples, 10 to be exact ! However, before we get started, what exactly
August 24, 2021
Spark SQL Date Functions – Complete list with examples
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
August 16, 2021