Skip to content
This repository has been archived by the owner on Sep 23, 2024. It is now read-only.

Make data_retention_time_in_days configurable #331

Open
deanmorin opened this issue Nov 23, 2022 · 1 comment
Open

Make data_retention_time_in_days configurable #331

deanmorin opened this issue Nov 23, 2022 · 1 comment
Labels
enhancement New feature or request

Comments

@deanmorin
Copy link

Is your feature request related to a problem? Please describe.
We have the DATA_RETENTION_TIME_IN_DAYS snowflake parameter set to 90 at the account level. However, when this target creates a table it's hardcoded to 1 day. This was discovered when we tried to use time travel to investigate a data issue and found we couldn't look back far enough.

Describe the solution you'd like
It would be great for data_retention_time_in_days to be configurable. Ideally one of the options would be default where it wouldn't try to set it at all when creating the table, and it would just use the account/database/schema default.

Describe alternatives you've considered
N/A

Additional context
N/A

@deanmorin deanmorin added the enhancement New feature or request label Nov 23, 2022
deanmorin added a commit to deanmorin/pipelinewise-target-snowflake that referenced this issue Nov 23, 2022
@scottgoering
Copy link
Contributor

@deanmorin - any chance you want to submit your commit for PR? We just ran into the same issue and would love to see it merged in. Thanks!

deanmorin added a commit to deanmorin/pipelinewise-target-snowflake that referenced this issue Jun 21, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants