Skip to main content
Version: 4

Creating an account for Snowflake connector

In Adeptia Connect, you can create an account that contains the details for connecting to Snowflake and exchanging data with it. Below are the steps for creating an account in the following scenarios:

While defining the Source or Destination in a Template/Transaction​

  1. At the Select Account step, click  .

  2. On the Create New Account screen, enter a name for the account, and then provide values for the fields described in the following table:

    Field
    		Description
    Authentication Type

    The type fo authentication you want to use to authenticate to Snowflake.

    The possible values are:

    • Bearer
    • OAuth

  3. Specify the following details based on the Authentication Type. 

    Field
    		Description
    Account Identifier

    Enter the identifier for your Snowflake account. The example given below shows the account identifier in the account URL.
    https://<account_identifier>.snowflakecomputing.com


    You get the Account Identifier after registering Adeptia Connect with Snowflake. 

    Database Name
    		Enter the name of the Snowflake database that you want to use for fetching and sending the data. The value for this field is case-sensitive.
    Schema Name
    		Enter the name of the Snowflake database schema that you want to use for fetching and sending the data. The value for this field is case-sensitive.
    Warehouse Name
    		Enter the name of the snowflake warehouse that you want to use for fetching and sending the data. The value for this field is case-sensitive.
    Account Locator
    Enter the Account Locator (in uppercase) which is a random string of unique characters and numbers, for example, AB56789. 
    • This field is available only when you have selected Bearer as the Authentication Type.
    • You get the account locator after registering Adeptia Connect with Snowflake.
    User Name 

    Enter the Snowflake username to which you have assigned the RSA public key.

    • This field is available only when you have selected Bearer as the Authentication Type.
    • You get the RSA public key after registering Adeptia Connect with Snowflake.
    Public Key Fingerprint 
    		Enter the fingerprint of the RSA public key that you get after assigning the public key to the user.
    • This field is available only when you have selected Bearer as the Authentication Type. 
    Private Key 

    Enter the private key corresponding to the RSA public key. 

    • This field is available only when you have selected Bearer as the Authentication Type. 
    • You get the private key after registering Adeptia Connect with Snowflake.

  4. Expand Advanced properties, and then provide values for the fields described in the following table: 

    Field
    		Description
    Select OAuth Client 

    The OAuth Client you may have created in Adeptia Connect.

    • This is an optional field and is available only when you select OAuth as the Authentication Type.
    • For the OAuth Client to work, you must enter the Redirect URI (Callback URL) in the following format while registering Adeptia Connect with the app.
      https://<domainName>/rest/connectors/oauth/account.
    • In this field, you can select the OAuth Client you may have created for the Snowflake app connector you are using in the Template/Transaction. To learn more about creating an OAuth Client, refer to this section.
    Provide Date Format
    The date format for your data.
    The supported date format is yyyy-MM-dd HH:mm:ss.SSS. 
    Provide Time Zone
    		Select a time zone. 
    Select Project
    		Select a Project. 

  5. Click Continue.
    You will be redirected to the Snowflake login page if you are not logged in to it. 

While defining the Application Trigger for a Process Flow​

You can create an account for Snowflake connector from within an Application Trigger (having Snowflake as the Source).

For more details on how to create an Application Trigger, refer to this page. 

Follow the steps given below to create an account.

  1. At the Provide account information step on the Create Application Trigger screen, click .
  2. Follow the steps given here (step 2 through 5).

While defining the Application Action for a Process Flow​

An Application Action enables you to use an App Connector as a Source, or Destination, or both in a Process Flow. An Application Action is an activity wherein you can select Snowflake connector and define what data you want to fetch from or send to Snowflake.

While defining the Application Action, you can create an account that you can use for exchanging data with Salesforce.

Follow the steps given below to create an account.

  1. At the Provide account information step on the Create Application Action screen, click .
  2. Follow the steps given here (step 2 through 5).