--- title: ezCater Engineering & Product Blog | data warehousing description: data warehousing | --- [![ezCater](https://engineering.ezcater.com/hs-fs/hubfs/RGB-ezCater-large.png?width=102&height=26&name=RGB-ezCater-large.png "ezCater")](http://www.ezcater.com) ## [The Long, Long Journey of Connecting to Snowflake with Ruby](https://engineering.ezcater.com/the-long-long-journey-of-connecting-to-snowflake-with-ruby) Aug 8 by [Jon Gherardini](https://engineering.ezcater.com/author/jon-gherardini) ## Charting a Path from Redshift to Snowflake ezCater is a data-driven company. For a long time, the principal source for our metrics was our Redshift data warehouse. As a result, we invested heavily in building out the data systems that fed Redshift. We also staffed up a team of engineers dedicated to building, enhancing, and growing our data systems. ([And yes, we're hiring!](https://www.ezcater.com/tech)) [Read More](https://engineering.ezcater.com/the-long-long-journey-of-connecting-to-snowflake-with-ruby) Tags: [data warehousing](https://engineering.ezcater.com/topic/data-warehousing), [snowflake](https://engineering.ezcater.com/topic/snowflake), [ruby](https://engineering.ezcater.com/topic/ruby) ## [Macgyver-ing for Marketers: How to Blow Minds with the Power of Hubspot Integrations](https://engineering.ezcater.com/macgyver-ing-for-marketers-how-to-blow-minds-with-the-power-of-hubspot-integrations) Oct 4 by [Jeff Dwyer](https://engineering.ezcater.com/author/jeff-dwyer) Prepare to have you mind expanded as you follow Jeff and Sam through a tour of the magic that can happen when you combine Slack, Zapier, Stitch, Redshift and more with workflows and the Hubspot APIs. [Read More](https://engineering.ezcater.com/macgyver-ing-for-marketers-how-to-blow-minds-with-the-power-of-hubspot-integrations) Tags: [data warehousing](https://engineering.ezcater.com/topic/data-warehousing), [redshift](https://engineering.ezcater.com/topic/redshift), [hubspot](https://engineering.ezcater.com/topic/hubspot) ## [Measuring AB Tests: SQL for p-value graphs in Redshift](https://engineering.ezcater.com/measuring-ab-tests-sql-for-pvalue-graphs-in-redshift) Jun 1 by [Jeff Dwyer](https://engineering.ezcater.com/author/jeff-dwyer) So, in [deciding when an AB test is actionable using p-value graphs](https://engineering.ezcater.com/deciding-when-to-call-an-ab-test-p-value-graphs) we saw some cool charts that looked like: [Read More](https://engineering.ezcater.com/measuring-ab-tests-sql-for-pvalue-graphs-in-redshift) Tags: [experiments](https://engineering.ezcater.com/topic/experiments), [data warehousing](https://engineering.ezcater.com/topic/data-warehousing), [redshift](https://engineering.ezcater.com/topic/redshift), [sql](https://engineering.ezcater.com/topic/sql) ## [AB Testing at ezCater Part 1: Event Taxonomy & Warehousing](https://engineering.ezcater.com/ezexperiments-ab-testing-at-ezcater-part-1-event-taxonomy-warehousing) Mar 30 by [Jeff Dwyer](https://engineering.ezcater.com/author/jeff-dwyer) Experiments! AB tests! On one hand it seems like everybody's doing it and on the other hand I regularly get the impression that a lot of people have found it to be more cumbersome than it’s worth. Worse, some blog posts I see imply that it’s leading folks down a path of micro-optimizations based on totally insignificant amounts of data. So what does it look like to have an AB testing framework that actually works? [Read More](https://engineering.ezcater.com/ezexperiments-ab-testing-at-ezcater-part-1-event-taxonomy-warehousing) Tags: [experiments](https://engineering.ezcater.com/topic/experiments), [data warehousing](https://engineering.ezcater.com/topic/data-warehousing) [All posts](https://engineering.ezcater.com/all) ### About ezCater We're the #1 online – and the only nationwide – marketplace for business catering in the United States. We make it easy to order food online for your office. From routine office lunches to offsite client meetings, from 5 to 2,000 people, we have a solution for you. ezCater connects business people with over 50,000 reliable local caterers and restaurants across the U.S. ### ezCater is hiring! We’re always looking for highly skilled full stack and iOS engineers to help execute our technology goals while riding this rocket ship of growth. Our people are terrifically talented straight-shooters who love what they do. And everyone is generous and kind, too — we have a strict no jerk policy. [![View ezCater Opportunities](https://no-cache.hubspot.com/cta/default/1703639/47d2a3d8-ffb7-4b28-8c3a-35bdb6d0605b.png)](https://cta-redirect.hubspot.com/cta/redirect/1703639/47d2a3d8-ffb7-4b28-8c3a-35bdb6d0605b) ### Recent Posts ### Posts by Tag - [experiments (6)](https://engineering.ezcater.com/topic/experiments) - [data warehousing (4)](https://engineering.ezcater.com/topic/data-warehousing) - [engineering (4)](https://engineering.ezcater.com/topic/engineering) - [ezcater (4)](https://engineering.ezcater.com/topic/ezcater) - [ruby (4)](https://engineering.ezcater.com/topic/ruby) - [activerecord (2)](https://engineering.ezcater.com/topic/activerecord) - [coding (2)](https://engineering.ezcater.com/topic/coding) - [development (2)](https://engineering.ezcater.com/topic/development) - [github (2)](https://engineering.ezcater.com/topic/github) - [javascript (2)](https://engineering.ezcater.com/topic/javascript) - [ltv (2)](https://engineering.ezcater.com/topic/ltv) - [machine learning (2)](https://engineering.ezcater.com/topic/machine-learning) - [rails (2)](https://engineering.ezcater.com/topic/rails) - [react (2)](https://engineering.ezcater.com/topic/react) - [redshift (2)](https://engineering.ezcater.com/topic/redshift) - [women\_in\_tech (2)](https://engineering.ezcater.com/topic/women_in_tech) - [active record (1)](https://engineering.ezcater.com/topic/active-record) - [creating (1)](https://engineering.ezcater.com/topic/creating) - [culture (1)](https://engineering.ezcater.com/topic/culture) - [database (1)](https://engineering.ezcater.com/topic/database) - [design (1)](https://engineering.ezcater.com/topic/design) - [devops (1)](https://engineering.ezcater.com/topic/devops) - [dynamodb (1)](https://engineering.ezcater.com/topic/dynamodb) - [growth (1)](https://engineering.ezcater.com/topic/growth) - [hubspot (1)](https://engineering.ezcater.com/topic/hubspot) - [jest (1)](https://engineering.ezcater.com/topic/jest) - [kafka (1)](https://engineering.ezcater.com/topic/kafka) - [kubernetes (1)](https://engineering.ezcater.com/topic/kubernetes) - [migrations (1)](https://engineering.ezcater.com/topic/migrations) - [snapshot testing (1)](https://engineering.ezcater.com/topic/snapshot-testing) - [snowflake (1)](https://engineering.ezcater.com/topic/snowflake) - [sql (1)](https://engineering.ezcater.com/topic/sql) - [time (1)](https://engineering.ezcater.com/topic/time) - [time zones (1)](https://engineering.ezcater.com/topic/time-zones) - [timeofday (1)](https://engineering.ezcater.com/topic/timeofday) - [unit testing (1)](https://engineering.ezcater.com/topic/unit-testing) - [values (1)](https://engineering.ezcater.com/topic/values) see all ### Subscribe to Email Updates © 2026 ezCater, Inc. | [Terms & Conditions](https://www.ezcater.com/terms_of_use) | [Privacy](https://www.ezcater.com/privacy_policy)