- Alias Tables
- CREATE TABLE AS …
- CREATE VOLATILE TABLE AS …
Alias tables do not store column-level metadata in the dictionary, which allows them to avoid the issues typically associated with runtime views. They retrieve data from the current snapshot and are compatible with time travel queries.
The CREATE TABLE forms used in this context generate local database tables, functioning similarly to materialized views. However, unlike true OTF tables, they import data from the data lake into local storage, which means they do not fully adhere to the principles of the OTF.