Skip to main content

​
Supported data types

Indeliveries

Incoming products

Inventory

Stock levels

Orders

Customer transactions

Product Attributes

Product metadata & descriptions

​
Prerequisites

Before setting up the Snowflake integration, ensure you have:
  • Tables or views in Snowflake containing your data, with columns matching our schema
  • A Snowflake user with read access to the necessary tables/views for the integration

​
Good to know

If you operate multiple storefronts, include EXTERNAL_STOREFRONT_ID in your data for per-row storefront assignment.

​
Merchant mappings

​
Step-by-step integration guide

1

Initial setup

Create a dedicated user in Snowflake for the integration with read access to the necessary tables. Provide the following credentials to your Customer Success Manager:
Send the information via secure password sharing.
Example
  "account": "abc1231231.eu-west-1",
  "username": "exampleuser",
  "password": "examplepassword",
  "role": "example_role",
  "database": "example_database",
  "warehouse": "example_Wh",
  "schema": "example_schema",
  "table": "example_table"
2

Specifying data tables and schema

Ensure each Snowflake table aligns with our schema. Columns must be named according to the column names specified in the schema below. This is crucial for accurate data integration.
3

Finalizing integration

After setting up the user and ensuring data mapping accuracy, our team will finalize the integration process, enabling data flow from Snowflake into our platform.
Multiple values Some fields allow multiple values. These fields can be added as column of Array type, like ["value1", "value2", "value3"].

​
Data schema

​
Indeliveries

Track incoming product deliveries to your warehouses.
Required:Optional:

​
Inventory

Stock levels across your warehouses. Product attributes (name, brand, category, etc.) are sent separately via Product Attributes. See COGS priority for how cost values are resolved.

Fields

​
Orders

Customer transaction data including order details and line items. See COGS priority for how cost values are resolved.
Required:Optional:
Required:Optional:
Include these fields to record returns directly in your orders table.

​
Product Attributes

Product metadata including names, categories, and descriptive attributes for your catalog.

Required fields

​
Troubleshooting and support

For common issues and solutions, contact our support team directly for assistance.

​
Additional resources