Should be pretty straight forward. Only additional change is adding the group id logic to also filter down the permits before joining them with jobs. Let me know if there are any questions. Thanks!
@SashaWeinstein
EDIT:
forgot to mention how best to review this. I think rerunning the whole build might make sense and dataloading at least for the dob_jobapplications and dob_permitissuance before that. I then checked whether for the A2 jobs whether their permit_year and permit_qrtr are properly populated in the final output.
Pull in the permits for A2
Should be pretty straight forward. Only additional change is adding the group id logic to also filter down the permits before joining them with jobs. Let me know if there are any questions. Thanks!
@SashaWeinstein
EDIT: forgot to mention how best to review this. I think rerunning the whole build might make sense and dataloading at least for the
dob_jobapplications
anddob_permitissuance
before that. I then checked whether for the A2 jobs whether theirpermit_year
andpermit_qrtr
are properly populated in the final output.