Propel

Progress >>> perfection

🎧 Tune into our latest podcast episode: Understanding ReplacingMergeTree in ClickHouse Dealing with data deduplication headaches? In our latest podcast episode, we explore the ReplacingMergeTree table engine, a powerful tool that can help you keep your ClickHouse data clean and up-to-date. Listen in as we discuss: ◆ How ReplacingMergeTree works to automatically deduplicate and update records ◆ Practical use cases for ReplacingMergeTree, such as real-time updates, deduplication, and managing slowly changing dimensions. ◆ Best practices for defining a good sorting key to optimize both query performance and uniqueness. ◆ Important caveats to keep in mind, such as merge timing and storage considerations. ◆ Real-world examples of how to define and query ReplacingMergeTree tables. Whether you're a seasoned ClickHouse pro or just getting started, this episode is packed with valuable insights. Spotify: https://lnkd.in/gPk38Kpk Apple podcasts: https://lnkd.in/gQD65Q7P

If you're a DynamoDB shop and want to make data more accessible for analytics, this one's for you. When working with DynamoDB, making data accessible for analytics is a challenge because you can't run GROUP BY queries that aggregate data in real-time. The data needs to be moved to a columnar store like ClickHouse and the JSON structure needs to be flattened. In our latest blog post, we walk you through using ClickHouse to flatten DynamoDB JSON, including: ◈ Ingest DynamoDB streams into ClickHouse using Propel's Webhook Data Pool. ◈ Create Materialized Views to extract and flatten top-level keys from the DynamoDB JSON. ◈ Separate individual tables or entities for more focused analytics. We cover step-by-step instructions, with sample SQL queries to help you get started quickly. 🎁 Bonus: Special SQL for those using single-table design. 👉 Read the full post here: https://lnkd.in/gWXxj9yW

If you've ever struggled with managing real-time updates and deduplication in ClickHouse, the ReplacingMergeTree table engine is your new best friend. It helps keep your data fresh, consistent, and without all the manual headache. Learn how to: ◆ Set up efficient sorting keys to balance performance and deduplication ◆ Manage real-time updates seamlessly using ReplacingMergeTree ◆ Avoid common pitfalls like inflated row counts and merge timing issues We've broken it all down in our latest blog post with practical examples and best practices. 🚀 Read it here: https://lnkd.in/dKkwaVhr

September Product Updates are out!

August product updates are out! 🚀

New: Propel's Serverless ClickHouse now integrates seamlessly with Kafka! Key features: ◆ Instant API for any Kafka topic ◆ Set up in minutes (even seconds!) ◆ Scales like crazy – with no effort And yes, it works with our amazing free tier, too! 😍

July Product Updates are out!

Shiny new GraphQL Playground 🤩 Features: ◆ GraphQL schema autocompletion ◆ Code examples ◆ Access token generator

June Product Updates are out!