Data Management
Category | Description | Key Features | Common Operations |
---|---|---|---|
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 • VACUUM DROP TABLE • DATA_RETENTION_TIME |