New v0.20.x series of target-snowflake supports Snowpipe Streaming to load data in append-only and overwrite modes. It enables significant warehouse usage (and thus cost!) reduction. github.com/MeltanoLabs/target-snowflake/…/v0.20.0