Extracted from these lines
[comment u/Inner_Discount_7504] That's a brutal amount of clicking for something that should be one config.
[comment u/Turbulent_Tank726] One ClickPipe per table" isn't a gotcha, that's just how ClickPipe works. If clicking through the UI once per table annoys you, script it.
[comment u/First_Requirement243] 40 clickpipes and 40 materialized views just to get stripe data into clickhouse. at that point just write the cron job yourself