I can't speak for Snowflake, but on Clickhouse it's quite literally [1]: insert into new_table select * from postgresql('postgres:5432', 'db', 'table', 'us

I can't speak for Snowflake, but on Clickhouse it's quite literally [1]: insert into new_table select * from postgresql('postgres:5432', 'db', 'table', 'user', 'pass'); I assume it's similarly easy on Snowflake, Databricks, SingleStore, and the rest. [1] https://clickhouse.com/docs/en/sql-reference/table-functions/postgresql https://clickhouse.com/docs/en/sql-reference/table-functions...