'Netezza to Redshift Conversion - _v_table and _v_relation_columns alternatives
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')
Solution 1:[1]
The alternative to Netezza's _v_table could be SVV_ALL_TABLES in Redshift. There's no relversion 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 the information_schema.columns table.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Jaap van der Herberg |