Snowflake
Guide on integrating Snowflake with our platform.
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
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.
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.
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 name | Format | Data Type | Description | Optional | Example |
---|
Inventory
Column name | Format | Data Type | Description | Optional | Example |
---|
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 name | Format | Data Type | Description | Optional | Example | Default | |
---|---|---|---|---|---|---|---|
&uarr, |
Troubleshooting and Support
For common issues and solutions, contact our support team directly for assistance.
Additional Resources
- Snowflake’s documentation for user creation and permission settings: Snowflake Documentation