Bug: dim pathways issue

[vevetron]

Describe the bug
DIM pathways sql failed on a dag run. Not sure if this would be a recurring issue yet.

Single error on a transform_warehouse dbt run on 2024-10-24:
https://b2062ffca77d44a28b4e05f8f5bf4996-dot-us-west2.composer.googleusercontent.com/dags/transform_warehouse/grid?dag_run_id=scheduled__2024-10-24T14%3A00%3A00%2B00%3A00&task_id=dbt_run_and_upload_artifacts

[2024-10-25, 14:47:16 UTC] {pod_manager.py:435} INFO - [base] �[0m14:47:16  �[31mCompleted with 1 error and 0 warnings:�[0m
[2024-10-25, 14:47:16 UTC] {pod_manager.py:435} INFO - [base] �[0m14:47:16
[2024-10-25, 14:47:16 UTC] {pod_manager.py:435} INFO - [base] �[0m14:47:16  �[33mDatabase Error in model dim_pathways (models/mart/gtfs/dim_pathways.sql)�[0m
[2024-10-25, 14:47:16 UTC] {pod_manager.py:435} INFO - [base] �[0m14:47:16    Invalid NUMERIC value: 65.00730846754857 Field: length; Value: 65.00730846754857
[2024-10-25, 14:47:16 UTC] {pod_manager.py:435} INFO - [base] �[0m14:47:16    compiled Code at target/run/calitp_warehouse/models/mart/gtfs/dim_pathways.sql
[2024-10-25, 14:47:16 UTC] {pod_manager.py:435} INFO - [base] �[0m14:47:16

Please enter a clear and concise description of the bug.

To Reproduce
Please enter step by step instructions to reproduce the behavior. For example: Query column A for organization Y on date Z.

Expected behavior
NO ERRORS DUH.

[erikamov]

dim_pathways was fixed, changing the length column to FLOAT on external_gtfs_schedule.pathways.
It was not updating since October last year (2024).
transform_warehouse still fail today because the table is an incremental table and needs a full refresh.
Charlie helped me running manually a full refresh and the table was updated successfully.