Skip to main content

​
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
We recommend creating a dedicated Snowflake user with read-only access for TierZero.

​
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