# Building A Modern Data Stack for QazAI

DevFeed: [Building A Modern Data Stack for QazAI](<https://devfeed.tech/articles/building-a-modern-data-stack-for-qazai-8676.md>)

Original publisher: [Read original article](<https://trino.io/blog/2022/06/08/building-a-modern-data-stack-for-qaz-ai.html>)

Author: Baurzhan Kuspayev

Published: 2022-06-08T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [building](<https://devfeed.tech/tags/building.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [databases](<https://devfeed.tech/tags/databases.md>), [hadoop](<https://devfeed.tech/tags/hadoop.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [s3](<https://devfeed.tech/tags/s3.md>), [speed](<https://devfeed.tech/tags/speed.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

QazAI describes moving from a data stack built around S3, Hive, and Clickhouse toward Trino for faster, lower-cost analytics and ETL exploration. The article highlights Trino's SQL support, federated queries, setup simplicity, and a lack of fault tolerance for ETL pipelines.

## Source excerpt

At QazAI, we build data lakes as a service for companies. In the original architecture, we get raw data in S3, transform the S3 data with Hive, and then delivered the data to business units via our datamart built on Clickhouse (for optimal delivery speeds). Over time, we were dragged down by the slower speeds and high costs of running Hive, and started shopping for a faster and cheaper open source engine to do our ETL data transformations.