Overview

Introduction

Integrating Snowflake with our platform enables seamless data synchronization, enhancing your analytics capabilities by leveraging inventory, orders, and indeliveries data directly from Snowflake.

Available Data Types

  • Inventory
  • Orders
  • Costs
  • InDeliveries

Prerequisites

None

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 name” from the document. 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.

Schema

Indeliveries

Column nameFormatData TypeDescriptionOptionalExample

Inventory

Column nameFormatData TypeDescriptionOptionalExample

Orders

  • Orders are matched on productId and variantId so we expect a unique combination of orderId-productId-variantId. If multiple items of the same variant were bought we expect them be aggregated with quantity: number of items bought.
  • All prices should include tax.
  • Order header level fields should be repeated for all items in the same order. If an item is returned or updated. we expect the original values for all columns except what has been updated (eg. the returned… fields or status line).
  • If an order is updated, please fill out the updatedAt field and the fields that have been updated (eg. return details).
  • If you want data mapped to a specific storefront, fill out externalStorefrontId and provide us with info about your existing storefronts, see Merchant mappings.
Column nameFormatData TypeDescriptionOptionalExampleDefault
&uarr,

Troubleshooting and Support

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

Additional Resources