How can streams be used in Snowflake?
💡 Model Answer
Snowflake streams are change data capture objects that record inserts, updates, and deletes on a base table. They are created with CREATE STREAM and can be queried like a table. The stream returns a row for each change, including metadata columns such as METADATA$ACTION and METADATA$ROW_ID. Streams are useful for incremental ETL, data replication, and real‑time analytics. They are read‑only; after you consume the changes you can drop or truncate the stream. Streams can be used in conjunction with Snowpipe, tasks, or external orchestration tools. They support both continuous and micro‑batch processing. Because they are part of Snowflake’s data sharing and security model, they can be used across accounts with secure views.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500