Skip to main content

Push Data to Snowflake

Who gets this? Data Warehouse Push is currently only available in beta for Postscript brands on the Enterprise plan. To begin using Data Warehouse Push, please be sure to first contact your Customer Success Manager.

Data Warehouse Push allows Postscript to automatically send both historical and new data stored in-app, including clicks, order attribution, and more, to your designated data warehouse.

In this article, you'll learn how Postscript securely connects to your Snowflake destination using Prequel, where you simply provide an initial detail, use a secure setup link to configure your bucket and permissions, and submit your credentials directly to Prequel so Postscript never accesses them.

NOTE: If your Snowflake account has a network policy with IP restrictions, you'll need to allowlist Postscript's IP addresses (provided by your Postscript contact) before connecting.

What We Need From You


To get started, share the following with your Postscript contact:

Field

Description

Account Hostname

The portion of your Snowflake URL before .snowflakecomputing.com (e.g. myaccount.us-east-1, or myaccount.us-east-1.gcp for non-AWS deployments). Find it by clicking your account name in the bottom-left of the Snowflake UI and copying the Account URL.

What Happens Next


  1. Once we have your account hostname, we'll send you a secure Prequel connection link.

  2. Open the link and follow Prequel's guided setup for Snowflake. Prequel will walk you through creating the dedicated user, role, warehouse, and database, and granting the permissions required for access. It also supports password or key-pair authentication.

  3. Enter your credentials directly and securely in Prequel. Postscript never sees them.

  4. Once connected, your historical data is pushed first, followed by new data every hour.

Get Support


Have questions? Please feel free to reach out to our Support team at [email protected] or via live chat.

Need ongoing channel strategy guidance? Please fill out this form and we'll connect you to one of our certified partners.

Did this answer your question?