Create a reader account or connection for Snowflake
In order to access Data Connect data, you must first create a Snowflake reader (or service) account for your organization, then create a new connection for each user or tool that you would like to have access to Data Connect.
After creating a connection, you can find its associated URL and username by clicking on it on the Data Connect page (Main menu > Setup > System > Data Connect) under the Existing Connections tab.
For information on using a newly created connection with an external product, see Establish a connection to Workfront Data Connect.
Access requirements
| table 0-row-2 1-row-2 2-row-2 layout-auto html-authored no-header | |
|---|---|
| Adobe Workfront package |
Ultimate Workflow Ultimate |
| Adobe Workfront license |
Standard Plan |
| Access level configurations | You must be a Workfront administrator |
For more detail about the information in this table, see Access requirements in Workfront documentation.
Create a reader account
You must create a new Snowflake reader account for your organization before you can begin creating connections.
To create a reader account:
-
Click the Main Menu icon
in the upper-right corner of Adobe Workfront, or (if available), click the Main Menu icon
in the upper-left corner, then click Setup.
-
In the left panel, click System > Data Connect.
-
Click the Create Reader Account button to begin creating your organization’s reader account. The process is automatic, but may take up to 24 hours to complete.
-
Once complete, a dialog window displays explaining that your reader account is now active. Refresh the browser page to gain access to the Create New Connection button.
Create a connection
-
Click the Main Menu icon
in the upper-right corner of Adobe Workfront, or (if available), click the Main Menu icon
in the upper-left corner, then click Setup.
-
In the left panel, click System > Data Connect.
-
Click Create New Connection.
-
In the window that appears, enter a name for your connection in Connection reference description and a username in Connection user, then click Generate Connection.
{width="500"}
-
Choose an authentication method for your connection:
Password authentication
-
Click Password, then Generate Connection.
-
A Default password is generated, as well as a URL where your data can be viewed through Snowflake. You need to use the password with the username you chose to sign in to Snowflake for the first time, so ensure that you keep a record of it as well as the URL. Check the box claiming you have done so, then click Close.
{width="500"}
-
Open Snowflake using a browser to navigate to the URL from the previous step, enter the username you selected and the default password from the previous step, then click Sign in.
-
After successfully signing in for the first time, you will be prompted to choose a new password. Enter a password of your choice in both the New password and Confirm password fields, then click Submit.
{width="300"}
-
You may now use your username and new password to access your Data Connect data lake in Snowflake or the business visualization tool of your choice.
Programmatic Access Token authentication
-
Click Programmatic Access Token.
-
Enter an expiration date for your token in the Expiration date field. You can choose an expiration date up to 365 days in the future.
-
Click Generate Connection.
-
A PAT token is generated that can be used to authenticate, and your Snowflake environment URL is provided. You can use the PAT and the username you provided to connect to Snowflake from your third-party visualization tool or data processor. Ensure that you keep a record of it as well as the URL. Check the box claiming you have done so, then click Close.
RSA Key authentication
-
Click RSA Key.
-
Enter an RSA public key in the RSA Public Key field.
-
Click Generate Connection.
-
A connection is generated, and your Snowflake environment URL is provided. You can use the RSA key and the username you provided to connect to Snowflake from your third-party visualization tool or data processor.
You need to use the RSA key with the username you chose to sign in to Snowflake, so ensure that you keep a record of it as well as the URL. Check the box claiming you have done so, then click Close.

Revoke a reader account
-
Click the Main Menu icon
in the upper-right corner of Adobe Workfront, or (if available), click the Main Menu icon
in the upper-left corner, then click Setup.
-
In the left panel, click System > Data Access.
-
Click on the trashcan icon
to the right of the account you would like to revoke.
-
In the window that appears, check the box to confirm and then click Delete.