Snowflake

Sync customer issue data into Snowflake

Setup

Head to the warehouse configuration page inside Pylon and fill in your Snowflake credentials.

We recommend creating a new database and schema within your account to store Pylon data. For best practice in access control, we also recommend creating a new role with access to just that database, and finally granting that role to the authenticating user.

You’ll need the following to configure your Snowflake connection:

1. User The username of the user who the connection will be on behalf of.

2. Password

   The password of the user who the connection will be on behalf of.

3. Account

   You can find your account identifier by using these instructions. The identifier will likely be in the form xxxxxx-xxxxxx.

4. (Optional) Warehouse

   The warehouse that is used to write data. If one is not specified, the default warehouse will be used.

5. Database The database that data will be written to. We recommend creating a new database for Pylon data.

6. Schema

   The schema that data will be written to. We recommend creating a new schema for Pylon data.

7. (Optional) Role

   The role that database operations will be performed with. Must have write access to the database.

8. Table

   The name of the table that data will be written to. Pylon will automatically create this table for you with the proper schema.

After you enter in these details, hit test to verify your connection!