实例探究 > Building Karmic’s Data Infrastructure

Building Karmic’s Data Infrastructure

公司规模

SME

地区

America

国家

United States

产品

Amazon Redshift
Stitch Data
Apache Airflow
Postgres

技术栈

ETL
Data Warehousing
Cloud Platform
Serverless Architecture

实施规模

Enterprise-wide Deployment

影响指标

Productivity Improvements
Customer Satisfaction
Digital Expertise

技术

平台即服务 (PaaS) - 数据管理平台
分析与建模 - 大数据分析
应用基础设施与中间件 - 数据交换与集成

适用行业

金融与保险
零售

适用功能

商业运营
销售与市场营销

服务

云规划/设计/实施服务
系统集成
软件设计与工程服务

关于客户

Karmic Labs delivers the future of expense management with a platform for employers, banks, and retailers to manage debit card and fund distribution amongst their customers and members. At a time of momentous growth for Karmic, their ability to build a strong, scalable data infrastructure became increasingly critical. Echoing what Airbnb refers to as “Data Democratization,” Karmic’s Data Science Product Manager, Yang Wang, explains that, “the more accessible data is, the faster we can iterate, and the further we can get in the game.” Yang joined Karmic when that data infrastructure was largely nonexistent, but it soon became one of this team’s highest priorities to fill that gap. “The second you build a software, you want to know what works and what doesn’t. We desperately needed more high-level analysis,” he said.

登录后查看完整内容

挑战

One of the biggest challenges Yang faced was in choosing and leveraging third-party tools. “How do you weigh vendors when you don’t really know what your needs are, and how those needs will change over time?” For a data warehousing solution, Yang ended up siding with Amazon Redshift, as it met all of his needs for storage, speed, and security. But to get data into Redshift, he needed an ETL solution to match it. Stitch Data was the first provider that caught his eye and that he later implemented - but it wasn’t long before his team outgrew it. “Plug-and-play tools like Stitch work great for straightforward workflows, but we needed more customization and access under the hood to not only comply with our security requirements, but also stay competitive with companies that have more developed data infrastructures” said Yang. “The fact that we didn’t have control over transformations forced us to consider other, more comprehensive options.”

登录后查看完整内容

解决方案

In his research for other options, Yang came across Astronomer’s Managed Apache Airflow module. While he hadn’t heard of Apache Airflow, his research proved that the open-source software had a strong community behind it and was a good fit for the job. “There were no other managed Airflow services out there, and we didn’t have the DevOps resources to run it ourselves” he said. Not long thereafter, he migrated his workflows to our Cloud platform. Karmic now uses Apache Airflow on Astronomer to sync their application database (Postgres) to their data warehouse (Amazon Redshift). Directly on our platform, Yang created a dynamic workflow that both automates that process and complies with Karmic’s security requirements. Due to the sensitive nature of their business, Karmic requires a whitelisted IP and SSH for some database connections. Since Astronomer’s Cloud Airflow service runs in a serverless architecture where each task instance runs in a separate container, there was no immediately obvious place to store the key file needed for an SSH connection (in this case, for Postgres). But by working with Astronomer, Karmic was able to configure a custom Airflow hook that opens an SSH tunnel in each task instance that requires access to that database - and closes that tunnel once the task finishes.

登录后查看完整内容

运营影响

With Astronomer, Karmic can trust that their data in Redshift remains reliable for both external and internal reporting.
At an organizational level, Astronomer allows Yang to fulfill a two-pronged goal: to make sure that data is widely available and, more importantly, accessible.
For Karmic, having reliable data in Redshift is the gateway to leveraging complementary analytics tools used by the rest of the team.
Astronomer Airflow not only allows for Karmic’s ETL processes to comply with security requirements, but also reliably ensures that data is in a place where the entire company can use it - and learn from it.
Since implementing Astronomer, Karmic has been able to more fully embrace data-centric solutions, better understand and serve their users, and stay agile at a time of constant product iteration.

登录后查看完整内容