Docs · Connector reference

Snowflake connector reference

Operations, inputs, troubleshooting, and questions for the Snowflake connection. Policy decides each change before the credential is resolved, and the action record carries the result.

Set up and verify the Snowflake connection

Choose one task and its account, and match the reads and actions on the overview page to it before granting provider permissions.
Prepare the connection settings from the overview page, connect the provider in Deixic, and choose which tools your agent can use.
Try a small task with a known result, and compare the returned identity and resource with what the account owner expects.
Configure approval for sensitive changes, review the destination and inputs, and check the result in the provider before expanding the workflow.

Information your agent can use

Resource	Record identity	Start with	Page coverage
Warehouses	`name`	Top level	None configured
Databases	`name`	Top level	None configured
Statement submissions	`statementHandle`	Top level	None configured
Statement results	`statementHandle`	Statement submissions	None configured

Record identity: Match on these fields before joining or deduplicating results; where none is specified, check the returned record first.
Start with: Resolve the parent identifier first.
None configured: No page continuation is configured for this resource. Check the response and any provider limits before treating it as a complete inventory.

Supported operations

Review the inputs before granting an action to an agent. Required inputs must be supplied, optional inputs narrow the request, and provider permissions apply in addition to Deixic policy.

Action: Can change provider state; review the target and inputs, then retain the result to avoid repeating completed work.
Read: Retrieves information; check the returned scope and identifiers before use.

Operation	Effect	Approval	Provider permissions	Inputs
Rows Insert	Action	Approval required	rows.write	6
Rows Select	Read	By policy	statements.read	8
Statement Get	Read	By policy	statements.read	1
Row Get	Read	By policy	statements.read	7
Row Insert	Action	Approval required	rows.write, statements.read	9

Inputs by operation

Rows Insert Action · approval required

Inputs for Snowflake Rows Insert
Input	Requirement	Accepted value
`database`	Required	stringMinimum characters: 1Maximum characters: 128
`request_id`	Required	stringMinimum characters: 1Maximum characters: 36
`row`	Required	arrayMinimum items: 1Maximum items: 16
`schema`	Required	stringMinimum characters: 1Maximum characters: 128
`table`	Required	stringMinimum characters: 1Maximum characters: 128
`warehouse`	Required	stringMinimum characters: 1Maximum characters: 128

Rows Select Read

Inputs for Snowflake Rows Select
Input	Requirement	Accepted value
`columns`	Required	arrayMinimum items: 1Maximum items: 16
`database`	Required	stringMinimum characters: 1Maximum characters: 128
`filters`	Required	arrayMinimum items: 1Maximum items: 4
`limit`	Required	integerMinimum: 1Maximum: 100
`request_id`	Required	stringMinimum characters: 1Maximum characters: 36
`schema`	Required	stringMinimum characters: 1Maximum characters: 128
`table`	Required	stringMinimum characters: 1Maximum characters: 128
`warehouse`	Required	stringMinimum characters: 1Maximum characters: 128

Statement Get Read

Inputs for Snowflake Statement Get
Input	Requirement	Accepted value
`statement_handle`	Required	stringMinimum characters: 1Maximum characters: 256

Row Get Read

Inputs for Snowflake Row Get
Input	Requirement	Accepted value
`database`	Required	stringMinimum characters: 1Maximum characters: 128
`key`	Required	stringMinimum characters: 1Maximum characters: 64
`key_column`	Required	stringMinimum characters: 1Maximum characters: 128
`schema`	Required	stringMinimum characters: 1Maximum characters: 128
`table`	Required	stringMinimum characters: 1Maximum characters: 128
`value_column`	Required	stringMinimum characters: 1Maximum characters: 128
`warehouse`	Required	stringMinimum characters: 1Maximum characters: 128

Row Insert Action · approval required

Inputs for Snowflake Row Insert
Input	Requirement	Accepted value
`database`	Required	stringMinimum characters: 1Maximum characters: 128
`key`	Required	stringMinimum characters: 1Maximum characters: 64
`key_column`	Required	stringMinimum characters: 1Maximum characters: 128
`request_id`	Required	stringMinimum characters: 1Maximum characters: 36
`schema`	Required	stringMinimum characters: 1Maximum characters: 128
`table`	Required	stringMinimum characters: 1Maximum characters: 128
`value`	Required	stringMinimum characters: 0Maximum characters: 512
`value_column`	Required	stringMinimum characters: 1Maximum characters: 128
`warehouse`	Required	stringMinimum characters: 1Maximum characters: 128

When the Snowflake task does not produce the expected result

Connected, but the expected data is missing

Check the identity behind the bearer token connection and its access to the specific resource; a successful connection does not establish access to every object.

Resolve parent resources first: Statement submissions. A matching display name is not enough for a child lookup.

The answer covers only part of the data

Check the resource’s page coverage, query filters, and result limit, and have the agent state the account and time window it inspected, so a partial response yields a scoped answer.

The agent keeps doing the same work

Inspect the action history for repeated targets and inputs, keep the successful result’s identifiers with the task, and refresh a lookup only when the information changed.

A change is waiting or failed

Check whether the call awaits approval, was rejected by policy, lacks an input, or failed at the provider, and after a timeout inspect the destination before repeating a write.

See how an action proceeds and how to review an approval.

Questions about the Snowflake connector

Can I use my existing agent with Snowflake?

Yes: connect your agent to Deixic through MCP, choose which connected tools it can use, and Deixic checks calls routed through its gateway; Dex is available if your team also wants an agent.

Can an agent change data in Snowflake?

This connector supports 1 action, listed on its overview page. Configure a connection and choose the tools and provider permissions your task needs; an available action is not permission for every agent to run it, and Deixic policy and any required approval still apply to calls through the gateway.

What do I need to connect Snowflake?

Prepare Snowflake account identifier, Snowflake OAuth or key-pair JWT access token; the connection uses Bearer token, and the connected identity’s provider permissions determine which resources it can access.

Does connecting Snowflake keep every answer up to date?

No: an earlier answer is still an earlier answer, so for a decision that depends on current state, have the agent refresh the source and retain the lookup time, and save stable instructions separately from facts that can change.

Snowflake connector overview Docs All connectors