Howdy, We have been running dbt version 1.7.7 , a...
# community-support
c
Howdy, We have been running dbt version 1.7.7 , adapter redshift = 1.7.2 , elementary version 0.13.2 for ~4 months. This week I started getting the errors: 144057 Elementary: Could not extract columns for table - NONE.DBT_MODELS__TMP_20240521144056467508144056477162 (might be a permissions issue) 144212 Elementary: Could not extract columns for table - NONE.DBT_TESTS__TMP_20240521144210832769144210834537 (might be a permissions issue) 145004 Elementary: Could not extract columns for table - NONE.DBT_COLUMNS__TMP_20240521145002845473145002847223 (might be a permissions issue)
💯 1
a
@Clark Flowers Hello! Have you managed with it?
c
Someone was testing out ALTER SYSTEM SET metadata_security=true in redshift. The removed the ability to select metadata even if the user has select on the objects. Changed it back to null or false and all was good.
a
So in your case it was really permission issue, as said in error message😀 Thank you)
c
Yes. It was hidden by the newer style of permissions. The user had select, insert, update, delete on the table, but did not have permissions to see metadata on said tables.
👍 1