[BUG] dbt-coves fails to detect columns in schema about dbt-coves HOT 8 CLOSED

Which database are you using?

can you post the table DDL?

from dbt-coves.

Hi @noel— using redshift. I've been unable to determine what's different about these tables. The columns are a mix of VARCHAR, INT, GEOMETRY, and DATE columns.

I've used dbt-coves successfully with similar tables, so I'm not entirely sure where to start here ☹️

from dbt-coves.

Do you have other tables that work with a Geometry data type?

from dbt-coves.

@noel Yes, I can confirm I've used dbt-coves for those. The issue only seems to occur on a single schema.

from dbt-coves.

@noel Fixed! I think I needed to explicitly grant update permissions to the Redshift user creating the models. This wasn't an issue for other schemas, since this redshift user owned the other tables.

It might be helpful to document explicitly what GRANTs the dbt-coves database user needs

from dbt-coves.

@mattppal we are using the dbt adapter, nothing special in terms of permissions. I wonder if dbt would complain with the permissions you had initially e.g. like if you do dbt docs generate that also needs to get info on the column data types. etc

from dbt-coves.

@noel Just ran into the issue again and pinpointed the fix— it's running GRANT ALTER ON TABLE xyz to the appropriate user 👍

from dbt-coves.

Closing as not a dbt-coves issue.

from dbt-coves.