pgwarehouse
pgwarehouse copied to clipboard
Easily sync your Postgres database to a Snowflake, ClickHouse, or DuckDB warehouse.
Hi again. One of our tools flagged some small security issues related to older package versions. (Mainly certifi, cryptography, etc...)  I've updated some packages...
I am using postgres only as low-cost data warehouse Can I sync between postgres to postgres using this ? I want to use incremental sync method using last_modified method
When I pip install pgwarehouse in Python 12, it fails to install because it requires DuckDB < .8 ERROR: Could not build wheels for duckdb, which is required to install...
Hi there! A newer version of certifi is available. I've also bumped the version to 0.1.6 hoping you could potentially release a new version on Pypi once this is merged...
Mainly required for foreign keys for duckdb https://duckdb.org/docs/sql/constraints.html#foreign-keys
In the `SnowflakeBackend`, the query used inside the `merge_table()` function includes the `ESCAPE_UNENCLOSED_FIELD=NONE` parameter. However, the query used in the `load_table()` function does not include this parameter, leading to errors...