Snowflake Postgres¶

About Snowflake Postgres¶

Snowflake Postgres lets you create, manage, and use Postgres instances directly from Snowflake. Each instance runs a PostgreSQL database server on a dedicated virtual machine managed by Snowflake. You connect directly to your instances using any postgres client. Snowflake Postgres brings the reliable and trusted transactional database capabilities of PostgreSQL to the Snowflake data platform.

About PostgreSQL¶

PostgreSQL is a mature, open-source relational database management system that has been actively developed for nearly 40 years. As a general-purpose transactional database, PostgreSQL is designed for operational applications that require highly-concurrent read/write operations, and low-latency data processing. PostgreSQL offers a wide array of data types, including JSONB, and sophisticated indexing capabilities. PostgreSQL is increasingly becoming the database of choice for a wide range of use cases, and is supported by an ecosystem of community-sponsored developer tools and extensions that offer enhanced capabilities. With its proven reliability and performance, and active developer community, PostgreSQL is a great addition to the Snowflake data platform that supports an expanded set of customer workloads.

Private Preview scope and goals¶

Private preview is an opportunity for customers to get an early look at a pre-release version of Snowflake Postgres. Customers can create, manage, and directly connect to PostgreSQL instances in their Snowflake account. See below for a guide to using the private preview, and check out the Coming Soon section for a list of features we’ll deliver in the near future.

Getting help¶

If you need support, find bugs, have feedback, or would otherwise like to contact our team during Private Preview, please email snowflake-postgres-support-DL@snowflake.com. Our team will assist you on a best-effort basis during regular business hours.

Cost & billing¶

You will be billed for your use of Snowflake Postgres based on the hourly price for the instances you provision, and the GB-month price for the amount of storage your provision. Contact us for a Preview Price List.

Customer Configurable Security Controls¶

Customers are responsible for managing the following controls to ensure a level of security appropriate to the particular content of their Postgres instances:

• Securing, keeping confidential, and rotating Postgres instance credentials, including passwords and connection strings.

• Maintaining appropriate password uniqueness, length, complexity, and expiration; and

• Configuring user and role-based access controls, including scope and duration of user access.

PostgreSQL major versions¶

PostgreSQL major versions 16 and 17 are currently available. We will automatically use the latest minor version when creating a new instance.

Coming soon¶

The private preview has an early subset of Snowflake Postgres functionality. Many features are not yet available but coming soon. We will add new capabilities continuously over the coming weeks and months. We appreciate your engagement and look forward to your continued partnership, so if you’d like to test any of these features please let us know and we’ll contact you when they become available.

Features coming soon.

• Network ingress controls

• Network egress

• TSS, PrivateLink, VPC peering

• Authentication to PG instances with Snowflake user credentials.

• Metrics and logs

• PITR or Forking

• Read replicas

• Customer-initiated backups and restores

• Cross-region replication

• Querying postgres directly from Snowsight or other Snowflake clients

• Automated data movement between Snowflake Postgres and the rest of Snowflake