data-models icon indicating copy to clipboard operation
data-models copied to clipboard

Redshift web: Drop pv_upsert_limit in page_views cleanup step

Open bill-warner opened this issue 4 years ago • 1 comments

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 avatar Mar 24 '21 12:03 bill-warner

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.

colmsnowplow avatar Mar 24 '21 14:03 colmsnowplow