Skip to main content

Snowflake

Prefer guided AI setup?

Instead of following these steps manually, you can use the AI Credential Assistant — describe what you want to connect and the AI will walk you through the setup step by step, tailored to your account.

Overview​

Connect your Snowflake data warehouse to Nirvai to automate analytics, run queries, and manage your cloud data.

Supported Authentication Methods​

  • Basic Auth (Username + Password + Connection Parameters)

Prerequisites​

  • A Snowflake account
  • User credentials with appropriate permissions
  • Knowledge of your warehouse, database, and schema

Setup Instructions​

Finding Your Account Identifier​

Your Snowflake account identifier is in your login URL:

  • Format: orgname-accountname (from orgname-accountname.snowflakecomputing.com)
  • Example: If your URL is myorg-myaccount.snowflakecomputing.com, use myorg-myaccount

Configuring in Nirvai​

  1. In Nirvai, go to Credentials > Add Credential
  2. Select Snowflake Data Warehouse
  3. Enter:
    • Username: Your Snowflake username
    • Password: Your Snowflake password
    • Account Identifier: Your org-account (e.g., myorg-myaccount)
    • Warehouse: The warehouse to use (e.g., COMPUTE_WH)
    • Database: The database to connect to
    • Schema: The schema (default: PUBLIC)
  4. Click Save

Connection Parameters​

ParameterDescriptionExample
Account IdentifierYour unique account IDmyorg-myaccount
WarehouseCompute resource for queriesCOMPUTE_WH
DatabaseDefault databaseMY_DATABASE
SchemaDefault schemaPUBLIC

What You Can Do​

  • Execute SQL queries
  • Load and unload data
  • Manage tables and views
  • Run stored procedures
  • Access query history

Best Practices​

  1. Use Service Accounts: Create dedicated users for integrations
  2. Limit Permissions: Grant only necessary privileges
  3. Use Roles: Assign appropriate roles to users
  4. Monitor Usage: Track warehouse credits

Troubleshooting​

Common Issues​

  • Invalid Account: Verify your account identifier format
  • Authentication Failed: Check username/password
  • Warehouse Suspended: The warehouse may need to be resumed
  • Permission Denied: Verify user role and grants

Adapted from Snowflake documentation for Nirvai platform

Next Steps​

Got your credential? Connect it to an agent

Use the AI Tool Creator to turn this credential into agent-callable tools. Describe what your agent should be able to do and the AI investigates the API, configures the endpoints, and gives you a reviewable toolkit before saving anything.