The ‘Logiwa Data Pipeline’ is designed to provide our customers with direct access to their valuable operational and transactional data. Leveraging a state-of-the-art Snowflake-based Data Warehouse (DWH), this solution provides your internal teams with direct data access, opening up new possibilities for in-depth analysis and customized reports to meet specific analytical objectives, augmenting the robust reporting already available on our platform.
What is the Data Warehouse?
Our new Data Warehouse centralizes all of your existing transactional and operational data tables into a unified Snowflake environment. This consolidation ensures that you have a comprehensive and up-to-date view of your information. Transactional tables are updated frequently (every 15 minutes), while master and parameter tables are updated daily, ensuring the data you access is timely and relevant for your business decisions.
How Does This Benefit You?
Direct access to your data via our Snowflake Data Warehouse offers several key advantages:
Enhanced Analytics & Reporting: Equip your internal teams with the raw data they need to conduct sophisticated analyses and create bespoke reports tailored to your specific business requirements.
Seamless Integration: For customers already utilizing Snowflake, a direct connection can be established to our environment via Snowflake Data Sharing. This allows for direct access without data duplication or movement, meaning your teams can query the shared data seamlessly within your own Snowflake instance.
Efficient & Secure Data Transfer: We utilize Snowflake’s Secure Data Sharing feature, ensuring that your data is transferred efficiently and securely. Robust security measures, including data encryption at rest and in transit, along with Role-Based Access Control (RBAC), are implemented to safeguard your information. You will only have access to your specific datasets.
Improved Decision Making: With readily available, comprehensive data, you can make more informed, data-driven decisions to optimize your operations and strategy.
What Data is Available?
The shared dataset is designed to provide a comprehensive view of your core operations. Initially, this will include approximately 70 tables, encompassing key areas such as:
Inventory Data
Order Data
Shipment Data
Transactions Data
Additional supporting reference tables
A comprehensive Data Dictionary will be provided, detailing table names, structures, and field descriptions to help your teams navigate and utilize the data effectively.
Frequently Asked Questions (FAQ)
Is Logiwa responsible for routing data from Snowflake to our other internal systems ?
No. Logiwa will not support or configure custom data routing to any other internal system,on your behalf. Once the data is accessible in your Snowflake environment, your internal teams are fully responsible for any subsequent data movement or routing to other internal or third-party systems.