ClickHouse: An open-source column-oriented database management system
People who&#x27;ve used Clickhouse or other OLAP databases in production &amp; at scale, how do you &quot;interconnect&quot; it with relational data?<p>I&#x27;m currently experimenting with Clickhouse, because my dataflow is increasing in size (40M rows right now, doubling every month or so) and my current setup (MongoDB) is at its limits. I would like to migrate the 40M rows to CH, but I also need the metadata for the rows to be in something more robust like Postgres or Mongo. Would you have a microservice that does the queries between the OLAP and relational DBs and does the join manually, exposing that as some low-level API? Or is using the various FDW options (remote tables in Clickhouse, Postgres clickhouse_fdw, etc.) realistic in production?<p>Sorry for the ramble, it&#x27;s late here. But I can clarify if necessary.