One of the broadest uses of Snowflake is building a data warehouse platform or enhancing the existing data lake. It offers all sorts of services to build an efficient Data warehouse with ETL capability and support for various external data partners. Slowly Changing dimensions are a common database modeling technique used to capture data in a table and show how it changes over time. The slowly changing dimension of the warehouse dimension is said to rarely change. However, when they change, there should be a systematic approach to capturing that change. Examples of SCDs are customer and products information. This project explains how to build a Slowly Changing Dimension (SCD) using Snowflake’s Stream functionality and how to automate the process using Snowflake’s Task functionality.
Given big data at taxi service (ride-hailing) i.e. OLA, you will learn multi-step time series forecasting and clustering with Mini-Batch K-means Algorithm on geospatial data to predict future ride requests for a particular region at a given time.