Snowflake
Sync customer issue data into Snowflake
Last updated
Was this helpful?
Sync customer issue data into Snowflake
Last updated
Was this helpful?
Snowflake
Follow these to generate an unencrypted RSA private key and associated public key.
the public key to a Snowflake user that Pylon will authenticate as. We recommend creating a new role with access to just the database you wish to use with Pylon, and finally granting that role to the authenticating user.
Pylon
Install the Snowflake App from the .
This will require your snowflake Account Identifier which can be found using these . It should be in the form <organization_name>-<account_name>
You will also need the Snowflake login name of the user you associated the public key with as well as the generated private key. The login name may differ from the user name/display name. Find this in the Users & Roles page under Admin in you Snowflake account.
Ensure you provide Pylon with the full private key including the header/footer. It should look like:
Once the connection is tested and validated then you can create a Warehouse Sync.
Warehouse syncs require the following information:
Warehouse (Optional)
The warehouse that is used to write data. If one is not specified, the default warehouse will be used.
Database The database that data will be written to. We recommend creating a new database for Pylon data.
Schema
The schema that data will be written to. We recommend creating a new schema for Pylon data.
Role (Optional)
The role that database operations will be performed with. Must have write access to the database.
Table
The name of the table that data will be written to. Pylon will automatically create this table for you with the proper schema.
If you previously used password authentication to set up your warehouse sync you will need to disconnect the Snowflake app from the App Directory. Upon reconnecting the app it will ask you for the user, account ID, and private key.
The existing sync should be unaffected.