Lumi Docs
  • About Lumi AI
  • Setting Up
    • Quick Start
    • 1. Connect
    • 2. Configure
      • Configuration Tips
      • Add Tables & Fields
      • Add Business Context
      • Advanced Configuration
    • 3. Distribute
  • Using Lumi
    • Getting Started
    • Lumi Use Cases
      • Data Exploration
      • Business Metrics
      • Anomaly Detection
      • Trend Analysis
      • Root Cause Analysis
      • Data Quality
    • Best Practices
      • Prompting Best Practices
      • Boards Best Practices
      • Versioning Best Practices
    • Chat Limitations
    • Knowledge Base Utility
      • Curated Prompts
      • Leveraging Memories
    • Network Configuration
  • Product Features
    • Chat
    • Boards
    • Knowledge Base
      • Overview
      • Connection
      • Tables
        • Custom Fields
      • Model
      • Business Context
      • Memories
      • Users
      • Restoration
    • Organization Settings
      • Organization Profile
      • Tool Integrations
      • Gateway Management
      • Members
    • User Profile
    • Notifications
    • Data Gateway
      • Deployment
      • Configuring for Boot
    • Source System Integrations
      • PostgreSQL
      • Microsoft SQL Server
      • MySQL
      • Databricks
      • BigQuery
      • Snowflake
      • SAP HANA
      • Oracle
      • AWS Athena (Pre-release)
    • Secondary Interfaces
      • Slack
      • Microsoft Teams
    • Release Notes
Powered by GitBook
On this page
  • Supported Methods
  • Supported Limits
  • Available Parameters
  • System Permissions & Configuration
  • Special Notes
  • Common Issues

Was this helpful?

  1. Product Features
  2. Source System Integrations

Snowflake

PreviousBigQueryNextSAP HANA

Last updated 9 months ago

Was this helpful?

A cloud-based data platform offers a scalable, secure, and high-performance relational database that offers online services and minimal management.

Supported Methods

Means for Lumi to connect to the client to implement the services required

Supported Limits

The following are limitations that can be set to fine tune the agents' actions:

Available Parameters

These properties are the essential source system connection properties that all queries are directed towards.

* Required parameters

Note: The Gateway parameter is common to all systems (when supported) and is only available when gateway is the selected connection method.

Account Identifier*

Provide the Snowflake unique account identifier within your organization.

Username*

Username of the generated database user which will be used for interactions and transactions.

Special Considerations

  • If double quotes are used, then the name will be case sensitive

  • Encasing a username with [ ] allows for a usage of reserved words and the @ character

  • Username can include alphanumeric characters, hyphens (-), underscores (_), and periods (.)

  • Uses alphanumeric characters : lumi1

  • Utilizing underscore (_) in place of spaces: user_number

  • Starting with a number: 1lumi

  • Utilizing spaces: user name

  • Using invalid characters: user#1

Password*

Password of the generated database user which will be used for interactions and transactions.

Database*

Literal database name that will be used for transactions within the agents.

  • Uses alphanumeric characters: lumi1

  • Utilizing underscore (_) in place of spaces: new_database

  • Starting with a number: 1lumi

  • Utilizing spaces: user name

  • Using reserved words unquoted: select

Warehouse*

Literal warehouse name that will be used for transactions within the agents.

  • Uses alphanumeric characters: lumi1

  • Utilizing underscore (_) in place of spaces: new_database

  • Starting with a number: 1lumi

  • Utilizing spaces: user name

  • Using reserved words unquoted: select

Role*

The role associated with the an account to provide access and permissions.

System Permissions & Configuration

Provided user must have the following:

For configurations:

Special Notes

  • If case sensitivity is required and other special characters, utilize double quotes for database name; ex. "New_database"

Common Issues

  • Ensure the firewall settings allow for a connection to the database

  • Ensure the username, password, and database values are explicitly provided

Valid Examples

Invalid Examples

Valid Examples

Invalid Examples

Valid Examples

Invalid Examples

👍
👎
👍
👎
👍
👎
Network Configuration
Data Gateway
Snowflake Account Identifier Documentation
How To Generate A Warehouse
How To Generate A Role