topic Re: DBT JOBS FAILING in Data Engineering

DBT JOBS FAILING

rsamant07 — Fri, 26 Jan 2024 15:01:40 GMT

HI ,

we have dbt workflow jobs and its been failing randomly from last few days with below error. is there any known issue for this , any help on the root cause will be helpful.

Encountered an error: Runtime Error Database Error __init__() got an unexpected keyword argument 'allowed_methods'

Re: DBT JOBS FAILING

shan_chandra — Fri, 26 Jan 2024 17:11:52 GMT

@rsamant07 - you could try either one of the below

1) Please check the "dbt_databricks_version" and upgrade to 1.5.7 (if it is below 1.5.7) or

2) Downgrade the "databricks_sql_connector_version" from 3.0.0 to a lower value.

Please try and let us know.

Re: DBT JOBS FAILING

rsamant07 — Thu, 01 Feb 2024 09:11:55 GMT

setting dbt-databricks==1.7.3 solved this issue but now we randomly get the below error . it gets fixed after restrating the cluster sometimes. but is there any permanent solution for this ?

from dbt.events import types_pb2 File "/databricks/python3/lib/python3.8/site-packages/dbt/events/types_pb2.py", line 5, in <module> from google.protobuf.internal import builder as _builder File "/databricks/python3/lib/python3.8/site-packages/google/protobuf/internal/builder.py", line 18, in <module> from google.protobuf.internal import python_message File "/databricks/python3/lib/python3.8/site-packages/google/protobuf/internal/python_message.py", line 36, in <module> from google.protobuf import descriptor as descriptor_mod File "/databricks/python3/lib/python3.8/site-packages/google/protobuf/descriptor.py", line 17, in <module> from google.protobuf.internal import api_implementation File "/databricks/python3/lib/python3.8/site-packages/google/protobuf/internal/api_implementation.py", line 81, in <module> from google.protobuf.pyext import _message TypeError: bases must be types