There is an increase in fail-safe backup storage when using Fivetran to copy data to the Snowflake warehouse.
The solution is to use transient tables:
Registering Fivetran with a transient database will ensure that all Fivetran-created tables are transient by default. This will help in reducing the additional costs and storage space associated with Fail-safe. However, transient tables cannot be recovered in case of operational or system failures.
Please follow the steps below:
- Pause the Fivetran database connector.
- Clone the target table into a transient table. This will result in an identical, transient table. Make sure that the schema names, table names, column names, and column data types are the same.
- Swap the tables.
- Resume the Fivetran database connector.
- Confirmed the sync is working fine.
- Drop the swapped-out, permanent table.
See Snowflake's Fail-safe Documentation for more information.
Read more about data load costs here.
Snowflake defaults to Fail-safe. Fail-safe is a backup/storage mechanism from Snowflake that ensures historical data is protected in the event of a system failure or other catastrophic event.