Accessing Curated Data using SQL

Step 1: Open a Worksheet

1. Log in to your Snowflake Reader Account.
2. Navigate to the Worksheets tab in the Snowflake interface.
   
   
3. Create a new worksheet or use an existing one.

Step 2: Identify the Curated Data You Want

1. Explore the curated data available to you in the Data Explorer on the left-hand side. Curated data views generally have very specific names that include timeframes and data scope. e.g. prior_month_consumed_reservations. 
2. Locate the database, schema, and table containing the data you need.
   • For example, database_name.schema_name.table_name.

Step 3: Write Your Query

1. In the worksheet, type the following query to pull all data from the table:
    

   SELECT * FROM database_name.schema_name.table_name;

2. Replace database_name.schema_name.table_name with the actual location of your table.

Step 4: Run the Query

1. Click the Run button (or press Ctrl + Enter / Cmd + Enter) to execute your query.
2. Wait for the results to populate below the query editor.

Step 5: Review and Export

• Review the Results: Check that the data returned is what you expected. Learn more in Reviewing Query Results in Snowflake.
• Export the Data: Save the results as a CSV file for further use. Learn how in Exporting Data from Snowflake.

That’s It!

With just a few steps, you can access curated data, review it, and export it for use in your projects. For more advanced SQL queries, see our other guides or reach out to your team for support.

Happy querying!