-
Notifications
You must be signed in to change notification settings - Fork 54
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Executing 'dbt docs generate' when the 'where' clause has different combinations of schemas > produces a permission error #407
Comments
Could you provide the exact |
Hello @damian3031 16:17:13 Running with dbt=1.7.13 Let me know if you need anything else. |
Circling back here. @jesusarroyoo, this does not seem like a dbt specific issue. Could you please open an issue in https://github.com/trinodb/trino/issues? |
Expected behavior
When we execute
dbt docs generate
on sources that are located in different schemas - we should be able to access them from the different schemas with no permission issue.Actual behavior
Filing this on behalf of the dbt team - for a customer who is reporting of the error.
To add more context, customer has their datalake in AWS and they use a Trino server to connect to the S3 buckets with the hive connector(glue) for reading and the glacier connector (also glue) for writing.
Executing
dbt docs generate
on sources located in different schemas, produces an error that seems to suggest that we are not allowed to access the tables.However, when we run
dbt docs generate
separately based on the sources from the same schema - everything works as expected.Steps To Reproduce
in dbt Cloud IDE
dbt docs generate
on sources that are all in 1 schema -> there should be no errordbt docs generate
on sources that are in more than 1 schema -> the error will show updbt docs generate
just on that individual source that was added in second step -> there should be no errorLooking into the logs, we can see the difference is in the
where
clause of the SQL statement that is being sent to Trino.Example:
First scenario - I run it leaving only references to
dbt_foo
:The query runs without a problem.
Second scenario - if we include just one mention to a different schema (
dbt_bar
,table_5
) the error appears:Error message
Last scenario - I query the added mention specifically to
dbt_bar
the query runs OK:If it was indeed a permission error, querying to
dbt_bar
would produce the same error.We tested querying both schemas with a
union
:This worked as expected.
Log output/Screenshots
No response
Operating System
Ubuntu 22.04.3 LTS
dbt version
1.7
Trino Server version
441
Python version
Python 3.10.12
Are you willing to submit PR?
The text was updated successfully, but these errors were encountered: