VantageCloud Lake can access data from multiple storage sources:
- Object storage: Low cost storage provided by public cloud vendors and includes the following:
- Object File System: This storage is integrated with VantageCloud Lake and provides benefits based on the compute cluster architecture. The tables are accessible to the primary cluster and compute clusters.
- External object storage: This storage is outside of VantageCloud Lake and is created and managed by customers. VantageCloud Lake accesses this storage using Native Object Store (NOS) capabilities such as NOS read, NOS write, and foreign table SQL.
- Block Storage: Low-latency persistent block-level storage offered by public cloud vendors. AMPs on the primary cluster use block storage to store user perm data and database data, such as dictionary tables.
By default, database tables are stored on Block Storage, unless otherwise specified with the CREATE TABLE STORAGE Option or by Setting DEFAULT STORAGE for Users and Databases.