airbyte icon indicating copy to clipboard operation
airbyte copied to clipboard

Improvement: Snowflake Cortex - Implement table replace logic when handling full refresh

Open bindipankhudi opened this issue 9 months ago • 0 comments

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."

bindipankhudi avatar May 15 '24 16:05 bindipankhudi