Bruce Qu
Bruce Qu
Current layers being pulled: '0_0': ward, '0_2': centreline, '2_2': bike, '2_3': traffic_camera, '2_9': traffic_signal, '2_11': permit_parking, '2_35': prai_transit_shelter, '2_37': tmms_service_request, '2_38': bylaw_pt, '2_39': bylaw_line, '20_1': ev_charging_station, '22_1': day_care, '22_2': middle_child,...
After reviewing all the layers, I have noticed that **'26_16': neigh_demo** and **'2_37': tmms_service_request** can no longer be found on REST API. Several other layers have their `layer_id` changed, which...
[CodeFactor](https://www.codefactor.io/repository/github/cityoftoronto/bdit_data-sources/pull/506) says that I need to have 'verify' to be true when requesting information from rest API. `r = requests.get(url, verify = True)` But when I tried to set 'verify'...
There seems to be five types of errors reported in Morbius Airflow logs. 1. UndefinedTable: missing FROM-clause entry for table "gis_core" 2. InvalidColumnReference: there is no unique or exclusion constraint...
**Type 1** Suspected reason: When executing `select {schema}.audit_table({schema}.{tablename})`, SQL thinks the schema name (e.g. gis_core) is a table name - The query is trying to add the table to audit...