Materialize: dbt-materialize: dbt generate docs throws a non-fatal error

Created on 2 Mar 2021  路  3Comments  路  Source: MaterializeInc/materialize

A user reports that while doing dbt generate docs that they got a

Encountered an error while generating catalog: Database Error
  WHERE clause error: function "upper" does not exist
dbt encountered 1 failure while writing the catalog

They were still able to generate and browser the docs, but we should fix this.

cc @JLDLaughlin

C-bug

Most helpful comment

Sounds very likely! Closing!

All 3 comments

This is the line:

https://github.com/MaterializeInc/materialize/blob/3dda2520e2897f4136d07dc1af87dded068dcb84/misc/dbt-materialize/dbt/include/materialize/macros/catalog.sql#L52

My guess is that the user has an older version of Materialize installed, prior to the addition of the upper string function last month (https://github.com/MaterializeInc/materialize/pull/5192).

I agree with @jtcohen6 !

Sounds very likely! Closing!

Was this page helpful?
0 / 5 - 0 ratings

Related issues

rrjanbiah picture rrjanbiah  路  3Comments

maqroll picture maqroll  路  6Comments

mjibson picture mjibson  路  3Comments

andrioni picture andrioni  路  4Comments

nyancol picture nyancol  路  7Comments