Redshift Coalesce: What you need to know to use it correctly

redshift coalesce cover image of girl on computer

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 […]

Athena SQL basics – How to write SQL against files

athena sql picture

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 […]