Snowflake, BigQuery, or ClickHouse? Pro Tricks to Build Cost Efficient Analytics for Any Business
Vložit
- čas přidán 5. 07. 2024
- Have burning ClickHouse questions? Get a free consultation with Altinity.
No pressure, no sales talk. Just answers to your questions. Book a call here: hubs.la/Q02qr1RZ0
______________________________
Be the smartest ClickHouse developer in the room. Get curated ClickHouse tips and tricks straight to your inbox. Sign up here: hubs.la/Q02pp8Bs0
______________________
Do you ever look at your bill for Snowflake or BigQuery and just sigh? This talk is for you.
In this webinar, you'll learn how pricing works for popular analytic databases, how to get the best deal, and how to build an alternative using open-source ClickHouse data warehouses. As the pros say, open source may be free but it ain’t cheap!
We teach you the tricks to build your own ClickHouse analytic stack that’s less expensive and faster than Snowflake. Join us to become a wizard of cloud cost management.
👀 Looking for the presentation slides? Here you go:
altinity.com/wp-content/uploa...
0:00 Introduction
5:33 How Cloud Businesses Work
8:01 Snowflake's Virtual Data Warehouse Model
10:58 BigQuery's Serverless Query Model
17:03 ClickHouse's Database Architecture
18:32 Better Comparison: Modernized 'Buy-the-Box'
20:08 Effect Of Storage & Compute on ClickHouse Prices
21:36 Quick Comparison of Models
23:40 What Snowflake Does Well
24:50 What Snowflake Does Not Do
25:48 How Can You Get a Better Price on Cloud Analytics?
28:13 When Is Cloud Analytic Database Pricing a Good Deal?
30:29 Pick A Specific Problem
31:00 Reality Check Against Snowflake
33:00 Modern Analytic Stacks Are Custom Data Platforms
33:58 Choose a Kubernetes Distribution
34:58 Pick an Open-Source Analytic Database
35:24 Pick an Operator to Run the Database
36:31 Choose the Observability Platform
37:35 Pick a Kubernetes GitOps Implementation
50:08 Best Practices for Do-It-Yourself Modern Analytic Stacks
#snowflake #bigquery #clickhouse #datawarehouse #cloud #devops #realtimedata #databasemanagement #dbms #realtimeanalytics #webinar #Altinity #dataanalytics
--------------
Join ClickHouse Meetups: www.meetup.com/san-francisco-...
Check out more ClickHouse resources: altinity.com/resources/
Visit the Altinity Documentation site: docs.altinity.com/
Contribute to ClickHouse Knowledge Base: kb.altinity.com/
Join the ClickHouse Reddit community: / clickhouse
-------------
More about Altinity! 💡
Site: www.altinity.com
LinkedIn: / altinity
Twitter: / altinitydb
Slack: altinitydbworkspace.slack.com... - Věda a technologie
Want to be the smartest ClickHouse developer in the room? Then sign up to our newsletter to get ClickHouse tips and tricks straight to your inbox.
Sign up here: hubs.ly/Q02pp8vh0
Great webinar and presentation Robert ! I loved the cost analysis upfront. Exactly reflects my experience and its too often overlooked in the early stages of a project..
Another Great webinar by Robert, Thank you!
What I miss is application of Clickhouse in BI reporting in comparison with other DW solutions. Especially using complex queries from multiple large tables. Snowflake has subjectively a decent performance but there is nothing to compare with in mentioned scenarios.
I wish if I can present like Robert.. In 50 mins you covered a lot of technology stack. Well done.
Comparison of different analytics databases was good. I wish I could see normalized pricing across vendors. I know it depends on the workload, but I get to see the difference clearly.
Thank you !Normalized pricing is very difficult across products because analytic databases are so different. What helps is to compare the archicture against your needs because you can often rule out databases based on other things than detailed operating cost.