Redshift Archives

How To Alter Column From NULL to NOT NULL

Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.

Cumulative Total allows you to track running totals over time. Here’s how to calculate running total in Redshift.

Rolling Average helps smoothen numerical trends in data. Here’s how to calculate moving average in Redshift using SQL query.