Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Reduce Redshift tables created by this code #19

Open
sandramchung opened this issue Nov 19, 2019 · 1 comment
Open

Reduce Redshift tables created by this code #19

sandramchung opened this issue Nov 19, 2019 · 1 comment

Comments

@sandramchung
Copy link

This code currently creates a new table in our Redshift cluster for every survey, which is a problem since the cluster is limited to 9900 tables and we hit that limit and have to delete lots of tables every few months. There are currently more than 1300 tables in our cluster created by this code. Please modify this code to save all survey results to a single table keyed by survey ID and/or periodically drop old survey results tables.

@sandramchung
Copy link
Author

Per discussion, this should pull survey results from only surveys that have gotten results in the last 2 months, and drop the rest.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant