CloudFormation Intrinsic functions: These 4 are a must know!
CloudFormation Intrinsic functions helps you create efficient reusable templates. Mastering a few simple functions to get started.
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.
CloudFormation Pseudo parameters – 8 parameters that pack a punch
Use CloudFormation Pseudo Parameters instead of hard coding values. Pseudo Parameters like Region, StackName, StackID have major advantages.
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
Redshift Coalesce: What you need to know to use it correctly
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, there is no limit to the number of values you can input. It’s a complex sounding word, but one of the most helpful expressions in Redshift. The syntax for the coalesce […]
15 Redshift date functions frequently used by developers
Redshift date functions with syntax, definition and examples on the most frequently used 15 by developers.
What is Amazon Redshift explained in 10 minutes or less
Amazon Redshift is more than just an optimized relational database, able to handle structured, unstructured and semi-structured data
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
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 you get the basics right. There are 5 areas you need to understand as listed below. Athena Data Types Athena SQL Operators Athena SQL Functions Aggregate Functions Date Functions String […]
14 Redshift Data Types to make you the office hero(2022)
The less is more approach to Redshift data types. Focus on these 14 character, numeric, datetime and boolean data types in Redshift.