About Reglo
Reglo is a committed French brand specializing in hypoallergenic, grain-free natural kibble with insect proteins for dogs and cats. As an e-commerce company, they initially faced challenges with their data management, juggling multiple platforms to refresh and process data. It was during their search for a solution to these challenges that they discovered Kestra.
Technology Stack at Reglo
To manage their data landscape, Reglo implemented a multifaceted technology stack:
- Shopify: Used as their primary e-commerce platform, handling sales, inventory, and customer data.
- Google Spreadsheet: Employed for manual data ingestion, typically for ad-hoc adjustments and one-time data entries.
- Airbyte: Utilized for data extraction and loading, pulling in data from various sources into their data warehouse.
- BigQuery: Serves as their data warehouse where all the data collected from different sources is stored for analysis.
- dbt (Data Build Tool): Takes care of data transformations, turning raw data into more useful, structured formats for analysis.
- Data Studio: Used for visualizing data, turning raw numbers into actionable insights through dashboards and reports.
- Kestra: The orchestration layer that ties all the above technologies together, simplifying complex workflows and automations.
The Challenge
Reglo faced a significant issue: their team had to navigate through multiple platforms, including Google Spreadsheets, Airbyte, and dbt to refresh and process their data. This fragmented approach was not only time-consuming but also prone to errors, affecting their overall operational efficiency.
Kestra's Solution
Reglo turned to Kestra to address these challenges. Kestra not only offered a solution for automated data workflow but also provided seamless integration with their existing stack. They developed a custom Slack command, which when triggered, initiates a Kestra Flow that automates Airbyte data ingestion and dbt transformations.
How Kestra Helped
- Unified Control Plane: Kestra consolidated the data workflow into a single dashboard where team members could modify Flows and monitor their executions without switching between different platforms.
- Simplified Orchestration: Kestra allowed for the orchestration of Airbyte and dbt tasks from within its environment. This eliminated the fragmented nature of their previous system and enabled a smoother data pipeline.
By adopting Kestra, Reglo has significantly improved their data management. They now enjoy a centralized, streamlined, and efficient system that addresses their initial challenges effectively.