Real world Case Studies
- eLearning company: streaming data from 1600+ MySQL databases to Snowflake using CDC
- Professional social network: loading data into Amazon Redshift from multiple sources
- Manufacturing company: data synchronization between the OLTP database and data warehouse
- SaaS startup: loading data from JIRA into the data warehouse
- Real estate company: loading data from a web service into a staging database and copying images to Amazon S3
- Logistics company: transforming Excel with rolling dates into normalized format with a single Date column
- Data analytics company: building a data model by loading data from various sources in Snowflake
- Media company: loading metadata into MongoDB and creating API for retrieving metadata for movies and shows
- Major retailer: loading data from 600+ SQL Servers behind firewall into data warehouse in Snowflake
- Government contractor: creating REST API for loading data in Tableau
- Automotive company: loading sales transactions into the cloud-based data warehouse
- DevOps: loading notifications from the Amazon SNS into the database
- Fitness club: sharing data with Tableau using Google Sheets
- Marketing company: transforming XML using XSLT and sending it to the web service as a payload
- Financial company: creating an inventory of all users across all managed and cloud applications