NYCPlanning / deprecated-labs-zap-api

Deprecated version of the ZAP API, see https://github.com/NYCPlanning/labs-zap-api
Other
5 stars 3 forks source link

Update prod PSQL database to capture new dcp_publicstatus values #225

Closed hannahkates closed 5 years ago

hannahkates commented 5 years ago

The ETLs that have been running from Prod CRM into our Prod PSQL data somehow (???) haven't been capturing these new dcp_publicstatus values. Super weird, makes me not trust that our ETLs are working correctly.

I think we may need to drop the tables and recreate them through the skyvia interface. If we do that, we'll also need to recreate the materialized view.

We should wait and deal with this once we're 100% happy with how everything is working staging and ready to promote to production.