Propel
@propeldata.bsky.social
The easiest way to run ClickHouse at any scale.
Follow us for tips and tricks building on ClickHouse ⚡.
Follow us for tips and tricks building on ClickHouse ⚡.
💡 ClickHouse Tip of the Day 💡
For time-series data in ClickHouse, put the timestamp last in the ORDER BY clause.
This improves data locality and compression, ensuring better query performance for time-based analytics. ⏰
For time-series data in ClickHouse, put the timestamp last in the ORDER BY clause.
This improves data locality and compression, ensuring better query performance for time-based analytics. ⏰
December 16, 2024 at 3:30 PM
💡 ClickHouse Tip of the Day 💡
For time-series data in ClickHouse, put the timestamp last in the ORDER BY clause.
This improves data locality and compression, ensuring better query performance for time-based analytics. ⏰
For time-series data in ClickHouse, put the timestamp last in the ORDER BY clause.
This improves data locality and compression, ensuring better query performance for time-based analytics. ⏰
💡 ClickHouse Tip of the Day 💡
Using ReplacingMergeTree in ClickHouse is ideal for maintaining only the latest version of each record. It's excellent for real-time updates and deduplication.
Using ReplacingMergeTree in ClickHouse is ideal for maintaining only the latest version of each record. It's excellent for real-time updates and deduplication.
December 11, 2024 at 3:30 PM
💡 ClickHouse Tip of the Day 💡
Using ReplacingMergeTree in ClickHouse is ideal for maintaining only the latest version of each record. It's excellent for real-time updates and deduplication.
Using ReplacingMergeTree in ClickHouse is ideal for maintaining only the latest version of each record. It's excellent for real-time updates and deduplication.
Ending the MEGA Launch Week with a bang!
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
December 6, 2024 at 10:19 PM
Ending the MEGA Launch Week with a bang!
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
Ending the MEGA Launch Week with a bang!
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
December 6, 2024 at 10:19 PM
Ending the MEGA Launch Week with a bang!
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
Ending the MEGA Launch Week with a bang!
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
December 6, 2024 at 10:18 PM
Ending the MEGA Launch Week with a bang!
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
👉 Day 5 Launch: DynamoDB → Propel's ClickHouse
Ingest from DynamoDB to Propel's ClickHouse to power fast analytics.
Key features:
◆ Integrates with DynamoDB streams
◆ Get inserts, updates, and deletes in real time
◆ No need to pay for expensive ETL tools ❤️
🚢 MEGA Launch Week Day 4!
👉 Open-Source Data Grid React Component
A component for visualizing data in a table format
Key features:
◆ Built-in pagination, ordering, & filtering
◆ Auto column name formatting
◆ Built-in drawer for row or JSON values
◆ Themable look & feel
Demo and docs ↓
👉 Open-Source Data Grid React Component
A component for visualizing data in a table format
Key features:
◆ Built-in pagination, ordering, & filtering
◆ Auto column name formatting
◆ Built-in drawer for row or JSON values
◆ Themable look & feel
Demo and docs ↓
December 5, 2024 at 3:30 PM
🚢 MEGA Launch Week Day 4!
👉 Open-Source Data Grid React Component
A component for visualizing data in a table format
Key features:
◆ Built-in pagination, ordering, & filtering
◆ Auto column name formatting
◆ Built-in drawer for row or JSON values
◆ Themable look & feel
Demo and docs ↓
👉 Open-Source Data Grid React Component
A component for visualizing data in a table format
Key features:
◆ Built-in pagination, ordering, & filtering
◆ Auto column name formatting
◆ Built-in drawer for row or JSON values
◆ Themable look & feel
Demo and docs ↓
Less than 24 hours until Launch Week 2024...
December 2, 2024 at 5:41 AM
Less than 24 hours until Launch Week 2024...
💡 ClickHouse Tip of the Day 💡
Using ReplacingMergeTree in ClickHouse is ideal for maintaining only the latest version of each record. It's excellent for real-time updates and deduplication.
Using ReplacingMergeTree in ClickHouse is ideal for maintaining only the latest version of each record. It's excellent for real-time updates and deduplication.
November 28, 2024 at 3:30 PM
💡 ClickHouse Tip of the Day 💡
Using ReplacingMergeTree in ClickHouse is ideal for maintaining only the latest version of each record. It's excellent for real-time updates and deduplication.
Using ReplacingMergeTree in ClickHouse is ideal for maintaining only the latest version of each record. It's excellent for real-time updates and deduplication.
If you're wondering what the new @PropelDataCloud Serverless ClickHouse free tier gets you:
◆ ~ 50,000 queries per month
◆ 1GB of data written per month
◆ 10GB of storage
Enough to launch your first production analytics use case for free.
→ https://www.propeldata.com
◆ ~ 50,000 queries per month
◆ 1GB of data written per month
◆ 10GB of storage
Enough to launch your first production analytics use case for free.
→ https://www.propeldata.com
November 27, 2024 at 6:00 PM
If you're wondering what the new @PropelDataCloud Serverless ClickHouse free tier gets you:
◆ ~ 50,000 queries per month
◆ 1GB of data written per month
◆ 10GB of storage
Enough to launch your first production analytics use case for free.
→ https://www.propeldata.com
◆ ~ 50,000 queries per month
◆ 1GB of data written per month
◆ 10GB of storage
Enough to launch your first production analytics use case for free.
→ https://www.propeldata.com
💡 ClickHouse Tip of the Day 💡
When flattening DynamoDB JSON in ClickHouse:
Flatten the main event envelope first, then each table individually.
This enables you to have common transformations for all events and simplifies table-specific transformations.
When flattening DynamoDB JSON in ClickHouse:
Flatten the main event envelope first, then each table individually.
This enables you to have common transformations for all events and simplifies table-specific transformations.
November 26, 2024 at 3:30 PM
💡 ClickHouse Tip of the Day 💡
When flattening DynamoDB JSON in ClickHouse:
Flatten the main event envelope first, then each table individually.
This enables you to have common transformations for all events and simplifies table-specific transformations.
When flattening DynamoDB JSON in ClickHouse:
Flatten the main event envelope first, then each table individually.
This enables you to have common transformations for all events and simplifies table-specific transformations.