Snowflake and Redshift projects now support data types for objects like Views and Dynamic tables (where they are not part of the DDL). Data types can be maintained through the UI and retrieved automatically through direct connect. Also, Virtual relationships and constraints are now available for views and dynamic tables for marking (virtual) Primary and Business keys.

Changes with no impact on existing DDL/API functions

Relational Modeling

• Virtual Relationship enhancements - Visibility, Naming, and Constraints unification for Views and Dynamic tables (all projects)
• Data types in the UI for Views and Dynamic tables (for all projects with view column support [Redshift, Snowflake])
• Snowflake get data types for Views and Dynamic tables through direct connect
• Redshift get data types for Views through direct connect