Connecting to Snowflake db in Fusion

[ScottHu7]

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-hav...

[etaylor · Accepted solution]

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

1. Create an API Integration in Snowflake to generate a key‑pair and OAuth credentials.
2. In Fusion, use the HTTP > Make a Request module.
3. Point it to your Snowflake REST endpoint and include JSON queries or stored‑procedure calls.
4. 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/...