Hi there. I'm using the target-snowflake with load_method: overwrite, I was thinking that it would make only a truncate table, but it drops and recreate the table. Have a way to set it to use the truncate?

The

DROP

DDL lives upstream in https://github.com/meltano/sdk/blob/36c620cf9e89c359c8caa4ec773c7f3b4eb9394c/singer_sdk/connectors/sql.py#L783. I'd review a PR to refactor

SQLConnector.prepare_table

so that the

if self.config["load_method"] == TargetLoadMethods.OVERWRITE

branch uses a method that specific implementations (like target-snowflake) can override to use different DDL, e.g.

TRUNCATE

.