Get startedGet started for free

Querying a Stream

Harbr's pipeline ingests new shipment records into logistics.staging_shipments throughout the day. A stream called staging_shipments_stream already sits on that table and is ready to track every insert. Your task is to confirm the stream starts empty, then insert two new staging shipments and query the stream to see what it captured.

⚠️ Can't select a database, or getting a "table not found" error?

Use the table's full path in your FROM clause. Get it from the left panel: Databases tab → expand your COURSE_… database → select the table → Copy name.

This exercise is part of the course

Data Pipeline Automation in Snowflake

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise