Skip to main content

Snowflake Connector

Connect Snowflake data warehouses to Infino for analysis with natural language queries.

Prerequisites​

  • Snowflake Account with appropriate access
  • Database and Schema permissions
  • Account Credentials (username/password or key pair)

Required Snowflake Permissions​

  • USAGE on database and schema
  • SELECT on tables to query
  • CREATE TABLE if importing data to Infino

Connection Setup​

Access Connector​

Navigate to Data → Connectors and search for "Snowflake" or browse the Database category.

Connection Configuration​

  1. Click Snowflake connector - Opens connection modal
  2. Enter account identifier - Your Snowflake account URL (e.g., abc12345.us-east-1)
  3. Provide credentials - Username and password or key pair authentication
  4. Select database and schema - Choose which database/schema to access
  5. Test connection - Verify connectivity and permissions
  6. Save connection - Create reusable connection

Authentication Options​

  • Username/Password - Standard authentication
  • Key Pair - More secure for programmatic access
  • OAuth - Enterprise SSO integration

Using the Connection​

Query Data​

Once connected, access Snowflake tables via:

  • Fino AI Assistant (Home) - Ask natural language questions
  • Query → Query Console - Execute SQL directly
  • Dashboards → Visualizations - Build charts from Snowflake data

Browse Tables​

Navigate to Data → Sources to view all available Snowflake tables and schemas.

Optional: Import to Infino​

Use Data → Sources to import specific Snowflake tables into Infino for cross-source correlations.

Connection Management​

Monitor Connection​

Go to Data → Sources to:

  • View connection status and health
  • See last used timestamp
  • Import data if needed
  • Delete or reconfigure connection

Troubleshooting​

  • Connection failed: Verify account identifier and credentials
  • No tables visible: Check database/schema permissions
  • Query errors: Ensure user has SELECT permissions on target tables