Skip to main content

Querying your Try Snowplow data

note

This recipe is currently specific to Try Snowplow.

Accessing your data​

Try Snowplow creates a Postgres database where any events you capture are stored. This database contains the standard Snowplow schemas:

  • atomic for raw data
  • bad_rows for data that has failed pipeline validation
  • derived for modeled tables.

Connection details for accessing this data are available in the Try Snowplow console. You will also need to request the password from within the UI.

Querying your data​

Like Snowplow BDP, Try Snowplow encourages you to connect your data visualization or query tool of choice to access the database and query your data.

You can either copy a sample query from the console tutorial, check out the Recipes or start exploring your data with your own queries.

Example: Querying your data in Supersest / Preset​

You can access the PostgreSQL trial database using your preferred data visualization or SQL query tool. If you don’t have permissions to create a new connection in your data visualization tool, you can use Preset which is built on the popular open source project, Superset and has a 14 day free trial.

The steps to connect, access and visualize data are below.

  1. Select “Try for Free” on the Preset homepage and enter your details to create an account
  2. Select ‘Yes’ to connect to your team’s database

  1. Select PostgreSQL as your database

  1. Enter the connection details provided in the Try Snowplow UI: Hostname, Port, Database, Username and Password (request credentials on Try UI if you haven’t done so)

  1. Continue with default settings and finalize set up

  1. On the top bar, select the “SQL” section and “SQL lab” subsection

  1. Copy SQL query from the Try Snowplow UI
SELECT *
FROM atomic.events
LIMIT 10
  1. In Preset, select the Snowplow database, and the “atomic” schema on the left sidenav and, paste the query from the previous step and run it

You should now see Snowplow atomic data which you can explore.

Example: Create a simple time-series chart​

From the query results, select “Create chart” and select “Bar chart”, set these values and click “Update chart”:

  • X-axis: derived_tstamp
  • Metrics:
    • Column: event_id
    • Aggregate: COUNT

Was this page helpful?