How we Modernised our Data Warehouse with WhereScape and Snowflake
This session explores what the combination of WhereScape and Snowflake has allowed the Toyota Financial Services team to achieve at Toyota Kreditbank.
Carsten’s BI team received data from nine countries in different formats, at different times and with different frequencies, varying from daily to monthly. For this reason, fulfilling regulatory requirements with hand coding and ETL tools was a real challenge.
The team was looking for a new solution to harmonise the data model, renew the technical infrastructure and implement a unified data delivery.
During this session, you will learn:
- Why Toyota Kreditbank chose Snowflake and Data Vault modelling
- How the company automated their manual repetitive processes for long-term time savings
- What a switch from manual ETL to automated ELT has achieved
- How to get full documentation and lineage out of the box
- Lessons learned from two DW automation implementations
- How to do half a years’ worth of batch reloads in just 2 hours