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.
Use the table's full path in your ⚠️ Can't select a database, or getting a "table not found" error?
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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise