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?

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.