Company Name - Thrive Restaurant Group

Website - https://www.thriverestaurantgroup.com/

Partner role in project:

As a Google partner, Evonence excels in Data engineering and Looker. Evonence worked to centralize data from various sources, optimize, secure and establish logical data structures and create visually appealing dashboards for valuable insights.

The challenge: 

The challenges encountered while ingesting data from various APIs into BigQuery include dependent jobs fetching outdated files daily and weekly, BigQuery tables not updating with the latest data, and "Saleschecks" columns appearing as JSON instead of RECORD. Additional issues include limited error handling for response codes (429, 503, 200), a misplaced cursor outside the response header condition, and query performance problems during Looker dashboard creation.

The solution:

External tables were created instead of native tables. A JSON schema was provided while creating tables to handle "Saleschecks" columns. An if-else condition was added in the Cloud Run job script to improve error handling, along with incorporating a cursor and limit in the headers. Native partitioned tables with a date range were created to optimize query performance in Looker dashboards.

The Result:

The tables are now properly updated with the latest data for both daily and weekly schedules. Response codes (429, 503, 200) are functioning as expected, with data correctly ingesting when the response code is 200. Additionally, query performance has improved, with data now loading in seconds.

Customer Testimonial:

“I want to express my sincere gratitude to Google, Evonence, and the dedicated team at Thrive Restaurant Group for the successful completion of our recent project. Together, we achieved a significant milestone by implementing BigQuery and Looker, which has greatly increased our data analysis capabilities.

The collaborative effort between our internal teams and the talented professionals at Evonence. Their expertise and commitment have enabled us to create powerful dashboards and reports that provide valuable insights into our business operations.

We are particularly pleased with the optics we have been able to develop, which have enhanced our ability to aggregate and monitor key performance indicators, identify trends, and make informed decisions. The successful launch of BigQuery and Looker has equipped us with the tools and capabilities to drive further growth and success.

Thank you to everyone involved in this project for your hard work, dedication, and outstanding contributions. We look forward to continuing our partnership with Evonence and leveraging the power of Google Cloud to achieve even greater heights.“

Patrick Bobrukiewicz, VP