If you are using Snowflake as your data warehouse, Toolio can also integrate directly with your Snowflake instance. Below are the details to facilitate Snowflake integration.
Table Naming Conventions
You will need to set up a table for each core model. Below are the required table names:
Data Model | Table Name |
Product | toolio_products |
Inventory | toolio_inventory |
Sale | toolio_sales |
Purchase Order | toolio_purchase_orders |
Receipt | toolio_receipts |
Required Table Schema
You can think of each column on your table corresponding to an attribute on Toolio’s data models. Column names should be the same as the slugs. Please see core model documentation for the column types you should use.
Connection Details
Please share the following information with your Toolio Customer Success Manager to give access to your Data Warehouse:
<accountname>.snowflakecomputing.com
user=<username>
db=<database>
schema=<schemaname>
warehouse=<warehouse>
role=<myRole>
Pagination & UpdateAt Field
If possible, make sure to add an updatedAt field to each of the tables that you create. This helps Toolio keep track of the last value that has been synced from your Data Warehouse. To learn more please see how Toolio handles pagination here.