PipeRivSnowflake SQL
Below are some example SQL commands that can be copied and pasted into a Snowflake worksheet.
If you are using the demo data, the below commands are assuming you have called:
USE SCHEMA piperiv_demo.public;
If you are using the live data, the below commands are assuming you have called:
USE SCHEMA piperiv.public;
List Pipelines
SELECT * FROM pipelines;
List Notices
SELECT * FROM notices LIMIT 10;
Combine Data
SELECT * FROM pipelines, notices WHERE notices.pipeline_id = pipelines.id LIMIT 10;
Specific Pipeline By Slug
SELECT * FROM pipelines, notices WHERE notices.pipeline_id = pipelines.id AND pipelines.slug = 'transco' LIMIT 10;