I need to ingest data into a ClickHouse database on an hourly basis. Currently, I have 30 days of historical data from the finance team. They want to visualize how this 30-day data, ingested hourly, would appear on the dashboard.
If I start ingesting the data now at the regular hourly interval, it will take 30 days to complete. However, as per our team's requirement, we need to ingest the entire dataset immediately, while maintaining the timestamps to reflect hourly intervals, so we don’t have to wait for 30 days.
Could someone please tell me how to do this?