Data Management
| Category | Description | Key Features | Common Operations |
|---|---|---|---|
| External Tables | Store tables in your own S3 bucket | • Storage connections • S3 storage classes • Database defaults | • CREATE TABLE ... CONNECTION • S3_STORAGE_CLASS • DEFAULT_S3_STORAGE_CLASS |
| Data Lifecycle | Create and manage objects | • Database & Table • External Tables • Streams & Views • Indexes & Stages | • CREATE/DROP/ALTER • SHOW TABLES • DESCRIBE TABLE |
| Data Recovery | Access and restore past data | • Time Travel • Flashback Tables • Backup & Restore • AT & UNDROP | • SELECT ... AT • FLASHBACK TABLE • BENDSAVE BACKUP |
| Data Protection | Secure access and prevent loss | • Network Policies • Access Control • Time Travel & Fail-safe • Data Encryption | • NETWORK POLICY • GRANT/REVOKE • USER/ROLE |
| Data Recycle | Free up storage space | • VACUUM Commands • Retention Policies • Orphan File Cleanup • Temporary File Management | • VACUUM TABLE / TABLES • VACUUM DROPPED OBJECTS • VACUUM ALL • DATA_RETENTION_TIME |
| Data Lineage | Trace data flow and dependencies | • Upstream & Downstream • Object & Column Lineage • Impact Analysis | • GET_LINEAGE • REFRESH LINEAGE • Lineage Graph |
| Data Sharing | Give other tenants read-only access without copying data | • Same-Meta sharing • Consumer accounts • Shared-table streams | • CREATE/ALTER SHARE • GRANT/REVOKE ... SHARE • CREATE DATABASE ... FROM SHARE |