[fix] br_ms_cnes.estabelecimento

[laura-l-amaral]

• log do erro

Flow 'Materialize <Parameter: dataset_id>.<Parameter: table_id>': Task 'run_dbt_model': Exception encountered during task execution!
Traceback (most recent call last):
  File "/opt/venv/lib/python3.10/site-packages/prefect/engine/task_runner.py", line 876, in get_task_run_state
    value = prefect.utilities.executors.run_task_with_timeout(
  File "/opt/venv/lib/python3.10/site-packages/prefect/utilities/executors.py", line 454, in run_task_with_timeout
    return task.run(*args, **kwargs)  # type: ignore
  File "/home/runner/work/pipelines/pipelines/pipelines/utils/execute_dbt_model/tasks.py", line 111, in run_dbt_model
  File "/opt/venv/lib/python3.10/site-packages/dbt_client/dbt_client.py", line 270, in cli
    return self._run_sync(
  File "/opt/venv/lib/python3.10/site-packages/dbt_client/dbt_client.py", line 223, in _run_sync
    raise Exception(
Exception: Error running sync command: Database Error in model br_ms_cnes__estabelecimento (models/br_ms_cnes/br_ms_cnes__estabelecimento.sql)
  Failed to parse input string "nan"
  compiled Code at target/run/basedosdados/models/br_ms_cnes/br_ms_cnes__estabelecimento.sql

• link da run

• motivo: ocorre quando uma função ou tipo do bigquery que não aceita strings possui um valor 'nan'. Nesse caso, alguns valores de data e colunas de tipo int64 estavam preenchidos com nan o que quebrava a materialização.

• soluçao: Basta inserir o safe_cast para converter tais valores para nulo.