JustFixNYC / nycdb-k8s-loader

Loading and updating of NYC-DB data via containerized batch processing.
6 stars 2 forks source link

put oca tables in own schema #117

Closed austensen closed 2 years ago

austensen commented 2 years ago

This PR makes another attempt to fix the schema issues for the wow dataset. Previously I tried to add wow to the search path when working in the temp schema, but that doesn't work because there are locks on the tables and we don't want it to drop the real wow schema tables when making the temp ones of the same name. Instead, we now create the new oca tables in their own oca schema, following the same pattern with temp schema as for wow, and then we add the oca schema to the search path when in the temp schema building wow tables.