Data Source

Snowflake

Query your Snowflake data warehouse directly from workflow nodes

Snowflake is a cloud data warehouse used for analytics and data engineering at scale. CipherSense Agents connects via account credentials to run SQL queries against your databases and schemas, passing structured results to Agent nodes as context.

Official documentation

Setup

Gather your connection details

You'll need your Snowflake account identifier (found in your account URL: <account>.snowflakecomputing.com), database, schema, warehouse, role, username, and password.

Create a least-privilege role and user

In Snowflake, create a dedicated role with USAGE on your warehouse and SELECT on required schemas. Assign this role to a new user for CipherSense Agents.

-- Create role
CREATE ROLE CipherSense Agents_role;
GRANT USAGE ON WAREHOUSE my_wh TO ROLE CipherSense Agents_role;
GRANT USAGE ON DATABASE my_db TO ROLE CipherSense Agents_role;
GRANT USAGE ON SCHEMA my_db.public TO ROLE CipherSense Agents_role;
GRANT SELECT ON ALL TABLES IN SCHEMA my_db.public TO ROLE CipherSense Agents_role;

-- Create user and assign role
CREATE USER CipherSense Agents_user PASSWORD='secure_password' DEFAULT_ROLE=CipherSense Agents_role;
GRANT ROLE CipherSense Agents_role TO USER CipherSense Agents_user;

Add the integration in CipherSense Agents

Go to Project > Integrations > Add Integration > Snowflake. Fill in account, database, schema, warehouse, role, username, and password. Click Save & Test.

Connection Fields

Fields required when adding this integration in your Project › Integrations.

Field	Required	Description
Account Identifier	Required	Your Snowflake account identifier. Found in your account URL before .snowflakecomputing.com.
Username	Required	Snowflake user login name.
Password	Required	Password for the Snowflake user.
Warehouse	Required	Virtual warehouse to use for query execution.
Database (optional)	Optional	Default database context for queries. Can be overridden per workflow node.
Schema (optional)	Optional	Default schema context for queries. Can be overridden per workflow node.

Common Use Cases

Query analytics tables for AI-driven reportingFetch customer segments for personalisation workflowsRead marketing attribution data for insights agentsAggregate pipeline metrics for executive summaries

Ready to connect Snowflake?

Add this integration from your project dashboard and wire it into a workflow.

Open Dashboard ← Back to Integrations