I’m having issues with some of the DDLs that have been shared in the links above. For example, most of the financial DDLs for Redshift do not work due to syntax errors and such.
The CREATE EXTERNAL Table / COPY commands do not match w/ the conventions (and also just do not work period!) from https://github.com/llooker/datablocks-acs/blob/master/readme.md. Also, there seems to be a mismatch in the type for the id column in the FRED_metadata ddl. The forex DDL only applies for the forex_real (I assume current data) and there is nothing for the historical data.
The financial indicator measures do not take into account that different datasets may be measured differently (e.g. employment rates are not measured in dollars).