Please consider using this DDL for the "optimized" Redshift. It specifies the data types more tightly, adds sort keys to the appropriate columns, and sets the smaller tables to be distributed on all nodes. Saves ~20% disk space and ~10-30% query time.
Please consider using this DDL for the "optimized" Redshift. It specifies the data types more tightly, adds sort keys to the appropriate columns, and sets the smaller tables to be distributed on all nodes. Saves ~20% disk space and ~10-30% query time.