Company
Date Published
Author
Dale McDiarmid & Tom Schreiber
Word count
4627
Language
English
Hacker News points
None

Summary

This blog post continues the series "Getting Data Into ClickHouse" and explores ways to get data into ClickHouse, focusing on using Amazon S3 storage as both a source of data and as a queryable data repository in its own right. The authors provide examples of querying forex data from S3 using ClickHouse for ad-hoc queries where users don't need to access the dataset frequently, and inserting the data into a table to utilize ClickHouse's full capabilities for real-time analytics. They also demonstrate how to visualize forex trading insights using Grafana, including candlestick charts and Bollinger Bands. The post highlights the benefits of using S3 as a source of data for ad-hoc queries and insertion into ClickHouse for real-time analytics, and provides examples of how to optimize query performance and schema configuration for improved results.