Prerequisites

To connect your Snowflake account for retrieving Retail sales data, follow the below instructions. If you have any trouble accessing this information, your Prescient CSM is available to assist you.

Expected Table Schema

Our integration expects access to a single table that aggregates your key daily offline metrics. This table should follow the schema below:

Setup Instructions

Follow our setup guide to connect Offline Revenue.

To enable seamless ingestion of your retail performance data into our system, you must make data available through a Snowflake share, with access granted to the following destination:

Snowflake Organization: WBAFXUK.LQA14719
Region: AWS US-East 1 (Northern Virginia)

Follow the official Snowflake documentation to create and configure your share:

Create and configure shares - This guide will help you set up the share correctly (note: this is different from private listings)
Account identifiers - Reference for understanding account identifiers.