airbyte
airbyte copied to clipboard
Improvement: Snowflake Cortex - Implement table replace logic when handling full refresh
Related to changes made in https://github.com/airbytehq/airbyte/pull/38206
From AJ - "When in 'replace' mode, we would ideally load to a stage table and then swap the table name with the existing table after the load is complete. The SQLProcessor class should do this automatically when in 'replace' mode, but it may require a refactor to actually implement this with confidence."