Snowflake is the AI Data Cloud: a cloud-based platform used by more than 13,000 organizations worldwide for data warehousing, analytics, and AI application development. It runs across AWS, Azure, and Google Cloud, providing a single platform for structured and unstructured data with built-in governance and AI capabilities.

The Snowflake Wrapper brings your Snowflake data into Postgres as queryable foreign tables. Read and write Snowflake tables and views with plain SQL and join them against your application data. The wrapper uses key-pair authentication to access Snowflake's SQL REST API, works with Supabase Vault for secure private key management, and is built on WebAssembly (Wasm) for lightweight, sandboxed execution.

Supported Operations

Object	Select	Insert	Update	Delete
Tables / Views	✅	✅	✅	✅

Supported Data Types

Postgres Type	Snowflake Type
boolean	BOOLEAN
smallint	SMALLINT
integer	INT
bigint	BIGINT
float	FLOAT4
double precision	FLOAT8
numeric	NUMBER
text	VARCHAR
date	DATE
timestamp	TIMESTAMP_NTZ
timestamptz	TIMESTAMP_TZ

Resources

• supabase/wrappers on GitHub