Hyper-Q Object Management
Database objects such as tables and views contain several properties that influence the semantics when accessing an object. Maintaining the properties—and therefore the semantics of the legacy data warehouse—is key to ensuring identical results when running legacy applications on the new cloud data warehouse through Hyper-Q.
Certain properties can be expressed natively within corresponding objects in the cloud data warehouse. Examples include column names, data types (with some exceptions), and nullability. Additional properties that have no native equivalent are recorded in Hyper-Q’s Metadata Store (MD Store). Examples include custom format strings, information on emulated data types, and non-constant default value expressions.
When creating or modifying objects through Hyper-Q, or in bulk with qShift, both the native object in the cloud data warehouse as well as the data in the MD Store are updated accordingly. Therefore, you must create and modify objects through Hyper-Q, qShift, and other Datometry products.
Related Topics
To learn more about the Metadata Store, see Metadata Store.