What are the different features you have worked on in Snowflake?

Question

Assisting AI · Accepted Answer

I have worked with several core Snowflake features:
1. **Zero‑Copy Cloning** – creates instant, space‑efficient copies of databases, schemas, or tables for testing or development.
2. **Time Travel** – allows querying historical data and recovering dropped objects within a retention period.
3. **Streams & Tasks** – enable change data capture (CDC) and scheduled or event‑driven data pipelines.
4. **Materialized Views** – pre‑compute query results for faster read performance.
5. **Data Sharing** – securely share live data with external accounts without copying.
6. **Snowpipe** – continuous ingestion of data from cloud storage using event notifications.
7. **External Tables** – query data stored outside Snowflake (e.g., S3) without loading it.
8. **Security & Access Control** – role‑based access, masking policies, and dynamic data protection.
These features collectively provide a flexible, scalable, and secure data platform.

What are the different features you have worked on in Snowflake?

💡 Model Answer

🎤 Get questions like this answered in real-time