skills.rest
jamescha-earley
jamescha-earleyCOMMUNITY
Explore all skills by this author →
GitHub

snowflake-postgres

Sync Postgres tables as Iceberg lake tables for Snowflake analytics.

Updated Mar 20, 2026
Search Tags:#data-analytics#iceberg#postgres#snowflake#lake-tables#etl-free#data-bridging
One-click install
npx skills add https://github.com/jamescha-earley/agent-skills --skill snowflake-postgres
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: snowflake-postgres
Source: https://github.com/jamescha-earley/agent-skills/tree/main/snowflake-postgres
Command: npx skills add https://github.com/jamescha-earley/agent-skills --skill snowflake-postgres

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Bridge transactional Postgres data to Snowflake analytics using Iceberg lake tables, enabling seamless cross-platform analytics without bespoke ETL pipelines.

Core Features & Use Cases

  • Iceberg lake tables sync from Postgres to object storage via pg_lake for analytics in Snowflake
  • Automated archival and time-partitioned data management with pg_incremental
  • Zero-ETL bridge to Snowflake for direct querying and reporting across Postgres and Snowflake
  • Use cases: real-time dashboards, historical analytics, cross-service data collaboration

Quick Start

Configure a Snowflake Postgres instance and enable pg_lake to start syncing data.

Frequently Asked Questions about snowflake-postgres

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
What is a zero-ETL bridge for syncing Postgres data to Snowflake?▼

A zero-ETL bridge syncs transactional Postgres data to Snowflake analytics by writing tables directly as Iceberg lake tables to object storage, enabling cross-platform querying without bespoke ETL pipelines.

How do I sync Postgres tables to Snowflake using Iceberg lake tables?▼

Configure a Snowflake Postgres instance, enable a Snowflake catalog integration, and use the pg_lake extension to start syncing tables as Iceberg lake tables for analytics in Snowflake.

Do I need pg_lake and pg_incremental extensions to bridge Postgres to Snowflake?▼

Yes, the zero-ETL bridge requires the pg_lake extension to sync tables to object storage and pg_incremental for automated archival and time-partitioned data management.

Can I use this approach for near real-time dashboards and historical analytics?▼

Yes, bridging transactional Postgres data to Snowflake using Iceberg lake tables supports near real-time dashboards and historical analytics across OLTP-to-OLAP workflows.

Is a Snowflake catalog integration required for Postgres to Snowflake data bridging?▼

Yes, a Snowflake catalog integration is required alongside pg_lake and pg_incremental to enable the zero-ETL bridge and allow direct querying of Iceberg lake tables.

Related Skills

Explore More Data & Analytics Skills→
delta-and-betadelta-and-beta

engineer-cloud-ingestion

Configure cloud data ingestion connectors and transformation pipelines for Braze.

Community
Advanced
JingyiWngJingyiWng

databricks-iceberg

Create and manage Apache Iceberg tables on Databricks with REST Catalog.

Community
Advanced
BagelHoleBagelHole
46

aws-s3

Configure Amazon S3 buckets with policies and lifecycle rules.

Community
Intermediate
AradotsoAradotso
5

snowflake-dbt-airbnb-analytics

Automate ETL workflows with Snowflake, dbt, and Streamlit.

Official
Advanced