Amazon Redshift Views, Sort Keys, and Outer Joins
My team built a process to load from a couple of base tables, in our Amazon Redshift enterprise data warehouse, into an other table which would act as a data mart entity. The data was rolled up and it included…