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
- 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:
"account": "abc1231231.eu-west-1",
"username": "exampleuser",
"password": "examplepassword",
"role": "example_role",
"database": "example_database",
"warehouse": "example_Wh",
"schema": "example_schema",
"table": "example_table"
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
Inventory
| Column name | Type | Description | Optional |
|---|
InDeliveries
| Column name | Type | Description | Optional |
|---|
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