Why is there 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 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.
Read more about data load costs here
Snowflake defaults to Fail-safe. Fail-safe is a backup/storage mechanism from Snowflake which ensures historical data is protected in the event of a system failure or other catastrophic event.