---
title: Configuring a Snowpipe Route
description: A guide to creating a Notehub route to Snowpipe, a service of Snowflake, using Blues Notecard over Cellular, Satellite, LoRa, or WiFi connectivity.
source_url: https://dev.blues.io/notehub/messaging-and-data-pipelines/configuring-a-snowpipe-route/
canonical_url: https://dev.blues.io/notehub/messaging-and-data-pipelines/configuring-a-snowpipe-route/
markdown_url: https://dev.blues.io/notehub/messaging-and-data-pipelines/configuring-a-snowpipe-route.md
---

# Configuring a Snowpipe Route

Notehub allows you to automatically route specified Notefiles to [Snowpipe](https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro). Snowpipe is a continuous data ingestion service from [Snowflake](https://www.snowflake.com/) that allows you to automate the process of loading data into Snowflake tables as soon as Notes are synced with Notehub.

## Configuring the Route

To create a Snowpipe route, open your Notehub project, head to the **Settings** tab and click on the **Snowpipe** menu item.

![snowpipe menu option](https://dev.blues.io/images/notehub/snowpipe/snowpipe-menu.png?v=f49380df)

On the next screen you'll be asked to provide a variety of values to configure your Snowpipe route (all fields are required).

1. **Organization:** This is the name of your Snowflake organization. You can find this value by navigating to the **Projects** menu, creating a new **SQL Worksheet**, and executing the `show accounts` query like so:

   ![snowpipe organization name](https://dev.blues.io/images/notehub/snowpipe/snowpipe-org-name.png?v=8c0896ed)

2. **Account:** This is the name of your Snowflake account. You can also get the account name from the previous step.

3. **Username and Password:** This is the username and password for the Snowflake user you want the process to run under. If needed, you can create a new user account by navigating to the **Admin > Users & Roles** menu option. Please note that this must be performed by a user with the "ACCOUNTADMIN" role:

   ![snowpipe new user](https://dev.blues.io/images/notehub/snowpipe/snowpipe-new-user.png?v=8b5fae4b)

4. **Database and Schema:** This is the Snowflake database and the schema within the database into which you wish to automatically load data. In the example below, "NOTEHUB\_DATA" is the database and "SENSOR\_DATA" is the schema.

   ![snowpipe database and schema](https://dev.blues.io/images/notehub/snowpipe/snowpipe-database.png?v=1b142f90)

5. **Compute Warehouse:** This is the name of the cluster of compute warehouses for your organization. The default compute warehouse is "COMPUTE\_WH", but yours can be found under the **Admin > Warehouses** menu option.

   ![snowpipe compute warehouse](https://dev.blues.io/images/notehub/snowpipe/snowpipe-compute-wh.png?v=cd8e1288)

6. **Sync Frequency in Minutes:** This determines how frequently you would like Snowpipe to pull data from specified Notefiles stored in Notehub. The minimum frequency is one minute.

### Setting Up Filters

More than likely you will not want to sync every Notefile from every device in your fleet via Snowpipe. Therefore, you may specify one or more Notefile names (comma-separated), one or more fleets to sync data from, and (optionally) one or more fleets to exclude from syncing:

![snowpipe filters](https://dev.blues.io/images/notehub/snowpipe/snowpipe-filters.png?v=62ddea40)

### Save the Route

When you're all set, toggle the **Enable Snowpipe service** "on" and click the **Save** button to save your Snowpipe route.

## Testing the Route

With your Snowpipe route created, you're now ready to test it out.

1. Click on the **Test connection** button to verify the integration between Snowpipe and Notehub. You should see a "success" message like so:

   ![snowpipe test connection](https://dev.blues.io/images/notehub/snowpipe/snowpipe-test-conn.png?v=1de98f03)

2. To test the delivery of Notefile data to Snowpipe, simply sync a new Note to Notehub that matches your filters. Then, at the cadence you previously specified, the data should automatically appear in your Snowflake database in a new "BLUES\_EVENTS" table:

   ![snowpipe data](https://dev.blues.io/images/notehub/snowpipe/snowpipe-data.png?v=ae8bcea5)