Skip to main content

Data Management

CategoryDescriptionKey FeaturesCommon Operations
Data LifecycleCreate and manage objects• Database & Table
• External Tables
• Streams & Views
• Indexes & Stages
• CREATE/DROP/ALTER
• SHOW TABLES
• DESCRIBE TABLE
Data RecoveryAccess and restore past data• Time Travel
• Flashback Tables
• Backup & Restore
• AT & UNDROP
• SELECT ... AT
• FLASHBACK TABLE
• BENDSAVE BACKUP
Data ProtectionSecure access and prevent loss• Network Policies
• Access Control
• Time Travel & Fail-safe
• Data Encryption
• NETWORK POLICY
• GRANT/REVOKE
• USER/ROLE
Data RecycleFree 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 LineageTrace data flow and dependencies• Upstream & Downstream
• Object & Column Lineage
• Impact Analysis
• GET_LINEAGE
• REFRESH LINEAGE
• Lineage Graph