Skip to main content
Snowflake is the most commonly connected data warehouse in Prizm. Once connected, Prizm continuously monitors your Snowflake tables for quality anomalies, tracks schema and volume changes, builds column-level lineage, and surfaces performance and cost insights all without writing pipelines or custom queries.

Why Connect Snowflake to Prizm?

Connecting Snowflake gives Prizm access to three layers of intelligence: Catalog & Context Prizm discovers every database, schema, table, view, and column in your Snowflake account and indexes them in the Prizm catalog. Tags defined in Snowflake are imported automatically. Descriptions, owners, and classifications can be managed in Prizm and optionally written back to Snowflake. Data Quality & Profiling Prizm runs profile scans on your tables to compute null rates, cardinality, min/max, distribution, and completeness scores at the column level. Quality scores are tracked over time so you can see trends and catch degradation before it reaches consumers. Observability Prizm monitors every in-scope table for freshness (last updated time), volume (row count changes), and schema drift (added, removed, or renamed columns). Machine-learning anomaly detection sets adaptive thresholds so alerts fire on real deviations — not noise.

Feature Support

CategoryCapabilitySupport
ObservabilityFreshness monitoring
ObservabilityVolume monitoring
ObservabilitySchema change detection
ObservabilityNull rate & distribution drift alerts
QualityColumn-level profiling (null rate, cardinality, min/max, mean, std dev)
QualityDuplicate row detection
QualityCustom SQL quality rules
CatalogMetadata discovery (databases, schemas, tables, views, columns)
CatalogTag ingestion — Snowflake → Prizm
CatalogTag bi-directional sync(Enterprise)
LineageTable-level lineage
LineageColumn-level lineage(Enterprise)
PerformanceQuery performance (execution time, bytes scanned)
PerformanceWarehouse compute & storage cost

Supported Snowflake Objects

ObjectCatalogQualityObservabilityLineage
Table
ViewSchema only
Column-level lineage requires the Enterprise Snowflake edition to access SNOWFLAKE.CORE.GET_LINEAGE. Standard edition uses query log parsing to derive lineage.

Next Steps

Setup

Connect Snowflake to Prizm — prerequisites, authentication, and configuration.

What We Collect

Full field-level breakdown of every metadata object Prizm extracts from Snowflake.

FAQ

Common questions about the Snowflake connector.

Databricks Connector

Connect your Databricks Unity Catalog workspace.