What are the alternatives for the below Netezza Tables and columns that I could use in Redshift?
- _v_table (columns used: 'RELVERSION' and 'OBJTYPE')
- _v_relation_columns (columns used: 'NAME' and 'ATTNAME')
What are the alternatives for the below Netezza Tables and columns that I could use in Redshift?
The alternative to Netezza's _v_table could be
SVV_ALL_TABLES
in Redshift. There's norelversion
attribute because tables aren't versioned. (So you don't need to groom versions after adding a column).And as a replacement for
_v_relation_column
you could use theinformation_schema.columns
table.