
SUCCESS STORY · ACTIA
ACTIA|Product traceability centralized on Snowflake
KPC centralizes ACTIA's board and component traceability on Snowflake. Business teams view and check the data in a browser, without writing a single SQL query.



The impact in numbers
2
Consultants assigned
6+
Months of project
2
Tools integrated (Snowflake, Streamlit)

The impact in numbers
2
Consultants assigned
6+
Months of project
2
Tools integrated (Snowflake, Streamlit)

The impact in numbers
2
Consultants assigned
6+
Months of project
2
Tools integrated (Snowflake, Streamlit)
RESULTS
The results for ACTIA

A single entry point for the business
The quality and support teams view, check and administer traceability without depending on IT. The business works more independently.
The results for ACTIA

Zero SQL queries for the business
Searches that used to need a complex SQL query are now available from the browser. Manual analysis disappears. The results are more reliable.
The results for ACTIA

An architecture that holds the load
Separating the high-volume flows keeps the architecture maintainable. Snowflake compute stays available for heavy analysis on components.
RESULTS
The results for ACTIA

A single entry point for the business
The quality and support teams view, check and administer traceability without depending on IT. The business works more independently.
The results for ACTIA

Zero SQL queries for the business
Searches that used to need a complex SQL query are now available from the browser. Manual analysis disappears. The results are more reliable.
The results for ACTIA

An architecture that holds the load
Separating the high-volume flows keeps the architecture maintainable. Snowflake compute stays available for heavy analysis on components.
RESULTS
The results for ACTIA

A single entry point for the business
The quality and support teams view, check and administer traceability without depending on IT. The business works more independently.
The results for ACTIA

Zero SQL queries for the business
Searches that used to need a complex SQL query are now available from the browser. Manual analysis disappears. The results are more reliable.
The results for ACTIA

An architecture that holds the load
Separating the high-volume flows keeps the architecture maintainable. Snowflake compute stays available for heavy analysis on components.

Background & core challenges
Making traceability usable by the business
Data scattered across technical and business sources
ACTIA, an industrial group specialized in embedded electronic systems, needed to consolidate its traceability data for boards and components. That data was spread across several sources: production, product integration, components, packaging, suppliers and customers.
Searches went through complex SQL queries, barely accessible to the business. Volumes were large, especially on components. Bringing in new data stayed manual.

Centralize data spread across production, components, packaging, suppliers and customers

Make searches available with no SQL query for business users

Automate bringing in new data as it arrives

Simplify exports for exchanges with customers and suppliers

Background & core challenges
Making traceability usable by the business
Data scattered across technical and business sources
ACTIA, an industrial group specialized in embedded electronic systems, needed to consolidate its traceability data for boards and components. That data was spread across several sources: production, product integration, components, packaging, suppliers and customers.
Searches went through complex SQL queries, barely accessible to the business. Volumes were large, especially on components. Bringing in new data stayed manual.

Centralize data spread across production, components, packaging, suppliers and customers

Make searches available with no SQL query for business users

Automate bringing in new data as it arrives

Simplify exports for exchanges with customers and suppliers

Background & core challenges
Making traceability usable by the business
Data scattered across technical and business sources
ACTIA, an industrial group specialized in embedded electronic systems, needed to consolidate its traceability data for boards and components. That data was spread across several sources: production, product integration, components, packaging, suppliers and customers.
Searches went through complex SQL queries, barely accessible to the business. Volumes were large, especially on components. Bringing in new data stayed manual.

Centralize data spread across production, components, packaging, suppliers and customers

Make searches available with no SQL query for business users

Automate bringing in new data as it arrives

Simplify exports for exchanges with customers and suppliers
Our approach
A Snowflake Data platform, with usage driven by the business
KPC put a Data platform in place based on Snowflake. The traceability data is centralized and structured there, then exposed to the business through Streamlit applications built around how they actually work.

Centralization
Centralize traceability on Snowflake
The traceability data, scattered across production, components, packaging, suppliers and customers, is centralized and structured in Snowflake.

Processing & structuring
Transform and check the data
Python processes collect, transform and check the data. It is then structured into several layers and views to optimize how it is consumed in Streamlit.

Business delivery
Putting data in the hands of the business
Streamlit applications let you check a product's traceability from A to Z. The business also manages the mappings, table and product generation, and the integration and non-regression checks. The data is refreshed hourly and can be exported to CSV or Excel.
Our approach
A Snowflake Data platform, with usage driven by the business
KPC put a Data platform in place based on Snowflake. The traceability data is centralized and structured there, then exposed to the business through Streamlit applications built around how they actually work.

Centralization
Centralize traceability on Snowflake
The traceability data, scattered across production, components, packaging, suppliers and customers, is centralized and structured in Snowflake.

Processing & structuring
Transform and check the data
Python processes collect, transform and check the data. It is then structured into several layers and views to optimize how it is consumed in Streamlit.

Business delivery
Putting data in the hands of the business
Streamlit applications let you check a product's traceability from A to Z. The business also manages the mappings, table and product generation, and the integration and non-regression checks. The data is refreshed hourly and can be exported to CSV or Excel.
Our approach
A Snowflake Data platform, with usage driven by the business
KPC put a Data platform in place based on Snowflake. The traceability data is centralized and structured there, then exposed to the business through Streamlit applications built around how they actually work.

Centralization
Centralize traceability on Snowflake
The traceability data, scattered across production, components, packaging, suppliers and customers, is centralized and structured in Snowflake.

Processing & structuring
Transform and check the data
Python processes collect, transform and check the data. It is then structured into several layers and views to optimize how it is consumed in Streamlit.

Business delivery
Putting data in the hands of the business
Streamlit applications let you check a product's traceability from A to Z. The business also manages the mappings, table and product generation, and the integration and non-regression checks. The data is refreshed hourly and can be exported to CSV or Excel.
Our clients
Our clients
They trust us.
They trust us.











Equipment rental
Professional Equipment Rental Company | Industrialized tender response 100% Snowflake
Gen AI
Snowflake
→

Transport & Logistics
Global shipping company — Data Science: from R&D to industrialization
AI
Data
→

Mobility
Axxès — Migration to a new data platform
Snowflake
Informatica
→

Food industry
Large agricultural cooperative — AI support, from framing to MVP
AI
Gen AI
→

Industry
Aqualung Group — Transforming the data platform
Snowflake
Data Platform
→

Business services
APAVE — Cross-office capacity planning
Pigment
EPM
→

Equipment rental
Professional Equipment Rental Company | Industrialized tender response 100% Snowflake
Gen AI
Snowflake
→

Transport & Logistics
Global shipping company — Data Science: from R&D to industrialization
AI
Data
→

Mobility
Axxès — Migration to a new data platform
Snowflake
Informatica
→

Food industry
Large agricultural cooperative — AI support, from framing to MVP
AI
Gen AI
→

Industry
Aqualung Group — Transforming the data platform
Snowflake
Data Platform
→

Business services
APAVE — Cross-office capacity planning
Pigment
EPM
→

Equipment rental
Professional Equipment Rental Company | Industrialized tender response 100% Snowflake
Gen AI
Snowflake
→

Transport & Logistics
Global shipping company — Data Science: from R&D to industrialization
AI
Data
→

Mobility
Axxès — Migration to a new data platform
Snowflake
Informatica
→

Food industry
Large agricultural cooperative — AI support, from framing to MVP
AI
Gen AI
→

Industry
Aqualung Group — Transforming the data platform
Snowflake
Data Platform
→

Business services
APAVE — Cross-office capacity planning
Pigment
EPM
→

A SIMILAR PROJECT IN MIND?
Product traceability to centralize?
Our Data & AI teams centralize your traceability data on Snowflake. The business views and checks the data with no SQL query.

A SIMILAR PROJECT IN MIND?
Product traceability to centralize?
Our Data & AI teams centralize your traceability data on Snowflake. The business views and checks the data with no SQL query.

A SIMILAR PROJECT IN MIND?
Product traceability to centralize?
Our Data & AI teams centralize your traceability data on Snowflake. The business views and checks the data with no SQL query.