Connecting to Snowflake db in Fusion

Question

My company is exploring options for sharing information from Snowflake to Workfront, likely through Fusion. It doesn't look like Fusion has a Snowflake connection module, is there a way to connect directly or would we be forced to use an api?

This question is similar but closed since it's 3 years old.
https://experienceleaguecommunities.adobe.com/t5/workfront-fusion-2-0-questions/does-anyone-here-have-any-experience-integrating-with-snowflake/td-p/492280

etaylor-1 · Answer

Hi ScottHu7,

so we do not have a dedicated snowflake connector, if that is something the community would like then please upvote and we will consider.

You can connect using universal connector (HTTP)

REST API via Fusion’s HTTP or Custom API module

Best suited for: when your Snowflake data is accessible through the Snowflake REST API.
Fusion’s HTTP modules (“Make a request”, “Get a record”, etc.) can call that API directly.

Setup outline

Create an API Integration in Snowflake to generate a key‑pair and OAuth credentials.
In Fusion, use the HTTP > Make a Request module.
Point it to your Snowflake REST endpoint and include JSON queries or stored‑procedure calls.
Parse the response and feed it into a Workfront ‘Create/Update Record’ module.

✅ Pros: full control, real‑time queries, secure via JWT or OAuth.
⚠️ Cons: requires you to format JSON manually and handle pagination/limits.

https://experienceleague.adobe.com/en/docs/workfront-fusion/using/references/apps-and-their-modules/apps-and-modules-toc

REST API via Fusion’s HTTP or Custom API module

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

REST API via Fusion’s HTTP or Custom API module