---
title: "Snowflake Basic integration for LuumenAI"
url: "https://www.luumen.ai/integrations/snowflake-basic/"
entity: SoftwareIntegration
category: "Databases & data platforms"
audience: "SRE, DevOps, platform engineering, IT operations"
---

# Snowflake Basic integration for LuumenAI

Explore Snowflake databases, schemas, and columns, then run SQL as an approved step

## What LuumenAI can do with Snowflake Basic

LuumenAI connects to Snowflake Basic with Basic auth and exposes 6 tools (5 read-only · 1 destructive). For connected tools, admins configure which actions may run automatically and which require approval, within the access granted to the user.

## Key facts

- Authentication: Basic auth
- Tools available: 6 tools (5 read-only · 1 destructive)
- Deployment: scoped as part of your Pilot, Platform, or Managed rollout
- Category: Databases & data platforms

## About Snowflake Basic with LuumenAI

Connect Snowflake and the agent can walk your account the way you would: list databases, list schemas, list tables with row counts and sizes, describe columns, and sample distinct values. That context is read on demand, no setup per question. Running SQL is a separate, approved step, so a query only reaches the warehouse once you say so.

## Example tools

Read-only (5 in total):

- `SNOWFLAKE_BASIC_DESCRIBE_TABLE` — Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified Snowflake table.
- `SNOWFLAKE_BASIC_EXPLORE_COLUMNS` — Retrieves a sample of distinct values for specified columns from a Snowflake table.
- `SNOWFLAKE_BASIC_SHOW_DATABASES` — Retrieves a list of all databases available in the Snowflake account.
- `SNOWFLAKE_BASIC_SHOW_SCHEMAS` — Retrieves a list of all schemas within a specified Snowflake database.
- `SNOWFLAKE_BASIC_SHOW_TABLES` — Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a Snowflake database.

Write and destructive (1 in total, subject to configured approval policy):

- `SNOWFLAKE_BASIC_RUN_QUERY` — Executes the given SQL query in Snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.

## Frequently asked questions

### How does LuumenAI connect to Snowflake Basic?

Authorize once with Basic auth. Luumen lists the scopes each action needs before you approve the connection, and credentials never appear in the chat.

### Can LuumenAI change things in Snowflake Basic on its own?

For connected tools, admins configure which actions may run automatically and which require approval, within the access granted to the user.

### Is there an audit trail?

Every call to Snowflake Basic — read or write, approved or declined — is recorded with the actor, the input, and the result.

Full page: https://www.luumen.ai/integrations/snowflake-basic/