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

Redshift web: Drop pv_upsert_limit in page_views cleanup step #63

Open
bill-warner opened this issue Mar 24, 2021 · 1 comment
Open

Comments

@bill-warner
Copy link
Contributor

The table {{.scratch_schema}}.pv_upsert_limit{{.entropy}} should be dropped as part of the step 99-page-views-cleanup.sql. Needs to be added.

@bill-warner bill-warner changed the title All web models: Drop pv_upsert_limit in page_views cleanup step Redshift web: Drop pv_upsert_limit in page_views cleanup step Mar 24, 2021
@colmsnowplow
Copy link
Collaborator

Whenever we look at this, if we have the time to do it, we could go a step further and just roll the entire table update into a stored procedure like we do for Snowflake and BQ.

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

2 participants