Snowflake - set data retention period for tables

  • Is this your first time deploying Airbyte?: Yes
  • OS Version / Instance: Ubuntu
  • Memory / Disk: 32GB or so
  • Deployment: Docker on EC2
  • Airbyte Version: 0.39.4
  • Source name/version: -
  • Destination name/version: Snowflake destination connector 0.4.28
  • Step: Unknown
  • Description: We are sending data to a Snowflake destination. It seems the tables are created in a way that overwrites the default DATA_RETENTION_TIME_IN_DAYS on our account and it’s in conflict with some company policies. We might be able to add a min value on the Snowflake side, but I’m wondering if there’s a way to set this in Airbyte to avoid it creating tables with a DATA_RETENTION_TIME_IN_DAYS less than what we want.

Hi @kyle-mackenzie-indee,
I don’t think our snowflake connector explicitly set a value for DATA_RETENTION_TIME_IN_DAYS.
Could you share the overwritten value and if this happens on final tables after normalization or on raw tables too?