Stockout Monitoring with Snowflake

Connect to Snowflake and write Stockout data to database

Aggregate stockouts

Monitor stockout trends and make predictions

Inventory Stockout Monitoring with Snowflake

The workflow processes stockout data about different item categories and across different warehouses in the US, for the years 2022 and 2023. After connecting and loading the data to Snowflake, the workflow trims warehouse location names to keep only the city, aggregates stockout counts for all cities by month, and sorts the results by date. Next, it visualizes the monthly stockout trend for selected warehouse locations in respective item categories and returns stockout predictions for the current month.

📍Technical Note:

[For users with a free 30-day trial account] In the Write Stockout data to DB component, keep the default configurations and simply execute the component. The Table name is defined automatically.

[For users with a regular account] Double-click on the Write Stockout data to DB component and provide your preferred Database and Schema names (they must already exist). The Table name is defined automatically.

💡Pro tip: If your working with very large datasets, we recommend replacing the DB Writer node with the DB Table Structure Creator + DB Loader nodes for faster, bulk data loading to database.

📍Technical Note:

If you don't have a Snowflake account, you can sign up for a free 30-day trial account (when signing up, select Enterprise edition and choose any Snowflake cloud/region - preferably AWS or Azure).

Configure the Snowflake Connector node:

After signing up, navigate to your Snowflake Account details. There, you'll find key information to configure the node:

• Account identifier (input it in Full account name field)

• Login name (input it in Authentication > Username & password field). The password field is the password used to log in to your Snowflake account.

• Role (input it in Default access control role). Make sure the role is ACCOUNTADMIN.

• Stay in your Account details and navigate to the Config File tab. Select the warehouse you prefer (e.g., SNOWFLAKE_LEARNING_WH, if you're using a free trial account) and input the warehouse name in the Virtual warehouse field.