Snowflake
Connect to your users' Snowflake accounts
You'll need the following information to set up your Snowflake App with Paragon Connect:
- Snowflake subdomain
- Snowflake Private Key
- Snowflake Passphrase
- Snowflake Username
This is an API-only integration - workflow actions for this integration are still in development. You can still connect user accounts, build workflows, and access the API for this integration.
Once your users have connected their Snowflake account, you can use the Paragon SDK to access the Snowflake API on behalf of connected users.
Any Snowflake API endpoints can be accessed with the Paragon SDK as shown in this example.
// You can find your project ID in the Overview tab of any Integration
// Authenticate the user
paragon.authenticate(<ProjectId>, <UserToken>);
// Perform a simple select query
await paragon.request('snowflake', '/statements', {
method: 'POST',
body: {
"statement": "SELECT * FROM country",
"schema": "LOCATION",
"warehouse": "COMPUT_WH"
});
// Using Bind Variables in a select query
await paragon.request('snowflake', '/statements', {
method: 'POST',
body: {
{
"statement": "select * from T where c1=?",
"timeout": 60,
"database": "TESTDB",
"schema": "TESTSCHEMA",
"warehouse": "TESTWH",
"role": "TESTROLE",
"bindings": {
"1": {
"type": "FIXED",
"value": "123"
}
}
}
});
Once your Snowflake account is connected, you use the Snowflake Request step to access any of Snowflake's API endpoints without the authentication piece.
When creating or updating records in Snowflake, you can reference data from previous steps by typing
{{ to invoke the variable menu.Last modified 6mo ago