Using Transformer for Snowflake to create a fact table for Citibike Trips data

  • 12 March 2022
  • 0 replies
  • 19 views

Userlevel 1
  • StreamSets Employee
  • 0 replies
Transformer for Snowflake: Pipeline to Create Fact Table

This pipeline uses the NYC Citibike data to populate a fact table enriched with station and weather data.  

Since this is using Transformer for Snowflake, none of the data leaves the Snowflake Data Cloud since the raw trips data is already loaded in Snowflake! The pipeline generates the SQL that is then executed on Snowflake, inserting the query results into the target tables. The pipeline is using weather data from Weather Source’s free Global Weather & Climate Data for BI data set on the Snowflake Data Marketplace so you can see the weather conditions for each ride.


0 replies

Be the first to reply!

Reply