> ## Documentation Index
> Fetch the complete documentation index at: https://docs.tierzero.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake

> Query and inspect your Snowflake data warehouse

## Overview

Connect Snowflake to give TierZero the ability to query your data warehouse during investigations. TierZero can run read-only SQL queries to analyze data, check pipeline health, and investigate data quality issues.

## Prerequisites

* Access to your Snowflake account
* Permission to create users or roles with read access

## Setup Instructions

### Step 1: Navigate to Integration Settings

1. Log into your TierZero dashboard
2. Go to **Settings → Integrations**
3. Click **Connect** next to Snowflake

### Step 2: Enter Connection Details

1. Enter your Snowflake **Account Identifier** (e.g., `xy12345.us-east-1`)
2. Enter a **Username** and **Password** (or key pair) for TierZero
3. Specify the **Warehouse**, **Database**, and **Schema** to use
4. Click **Connect**

<Info>
  We recommend creating a dedicated Snowflake user with read-only access for TierZero.
</Info>

## What TierZero Accesses

* **SQL queries**: Read-only queries against your specified databases and schemas
* **Table metadata**: Schema information, column types, and row counts
* **Query history**: Recent query patterns for debugging

## Security

* TierZero only executes **read-only queries**; no INSERT, UPDATE, DELETE, or DDL operations are performed
* Credentials are encrypted at rest
* Scope access using Snowflake roles to control which databases and schemas TierZero can query
* Revoke by deleting or disabling the Snowflake user

## Troubleshooting

### Connection Fails

* Verify the account identifier is correct (include the region suffix)
* Check that the username and password are valid
* Ensure the specified warehouse exists and is not suspended
* Confirm the user has access to the specified database and schema