pgwarehouse icon indicating copy to clipboard operation
pgwarehouse copied to clipboard

Easily sync your Postgres database to a Snowflake, ClickHouse, or DuckDB warehouse.

Results 6 pgwarehouse issues
Sort by recently updated
recently updated
newest added

Hi again. One of our tools flagged some small security issues related to older package versions. (Mainly certifi, cryptography, etc...) ![CleanShot 2024-05-13 at 09 53 23](https://github.com/scottpersinger/pgwarehouse/assets/3911112/d9d1757c-3ecd-4d87-9681-7f35f4b98a70) 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...