Connect Isofold to Snowflake

Isofold can proxy Snowflake queries via JDBC, ODBC, or native client libraries. It rewrites your SQL in-flight to reduce cost while preserving exact results.


JDBC Integration

Update your connection string to route through Isofold:

jdbc:snowflake://myteam.proxy.isofold.com/?user=YOUR_USER&password=YOUR_PASSWORD

Ensure that your proxy is configured to forward requests to the original Snowflake hostname.


Python Connector (snowflake-connector-python)

Specify the proxy host using the host argument:

import snowflake.connector

conn = snowflake.connector.connect(
  user='YOUR_USER',
  password='YOUR_PASSWORD',
  account='your-account-id',
  host='myteam.proxy.isofold.com'
)

Node.js (snowflake-sdk)

Pass the Isofold proxy as the host field:

const snowflake = require('snowflake-sdk')

const connection = snowflake.createConnection({
  account: 'your-account-id',
  username: 'YOUR_USER',
  password: 'YOUR_PASSWORD',
  host: 'myteam.proxy.isofold.com'
})

Things to Know

  • The Isofold proxy must know how to route to your original Snowflake account domain.
  • For full compatibility, the proxy should forward TLS connections using SNI passthrough or application-level routing.
  • You can run Isofold inside your cloud or VPC for lower-latency and compliance control. See self-hosted setup.

Verification & Auditing

Enable verification mode to compare original vs rewritten queries:

export ISOFOLD_VERIFY_MODE=true

Monitoring and Optimization Reports

Once your Snowflake traffic is flowing through Isofold:

  • Query rewrites and costs will appear in your dashboard
  • You can inspect differences and run dry-run simulations (for supported queries)

Need help debugging a Snowflake setup? Contact support