Pgwarehouse: Easily sync your Postgres db to a Snowflake or ClickHouse warehouse
1–5 of 5 posts
Re: Pgwarehouse: Easily sync your Postgres db to a Snowflake or ClickHouse warehouse
#2Built this recently to help a friend setup a Snowflake warehouse from their Postgres database. Also tested it with ClickHouse which is cool for running locally. Uses simple COPY which is fast and doesn't require binlog access, but doesn't support real-time replication as a result.
Re: Pgwarehouse: Easily sync your Postgres db to a Snowflake or ClickHouse warehouse
#3Built this recently to help a friend setup a Snowflake warehouse from their Postgres database. Also tested it with ClickHouse which is cool for running locally. Uses simple COPY which is fast and doesn't require binlog access, but doesn't support real-time replication as a result.
Super interesting, I look forward to playing with it.
FWIW, the Community Integrations section of https://clickhouse.com/docs/en/integrations is open for PRs if you want to add it ;)
Re: Pgwarehouse: Easily sync your Postgres db to a Snowflake or ClickHouse warehouse
#4Built this recently to help a friend setup a Snowflake warehouse from their Postgres database. Also tested it with ClickHouse which is cool for running locally. Uses simple COPY which is fast and doesn't require binlog access, but doesn't support real-time replication as a result.
Super interesting, I look forward to playing with it. FWIW, the Community Integrations section of https://clickhouse.com/docs/en/integrations is open for PRs if you want to add it ;)
cool - will do!
Re: Pgwarehouse: Easily sync your Postgres db to a Snowflake or ClickHouse warehouse
#5Interesting tool!
I am curious about this feature: https://github.com/scottpersinger/pgwarehouse#last-modified in Clickhouse. Have you tested it on big tables and how well does it perform?