Skip to content

Error running dbt docs generate with Federated Query database #306

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

Closed
Enriqson opened this issue May 16, 2023 · 1 comment · Fixed by #324
Closed

Error running dbt docs generate with Federated Query database #306

Enriqson opened this issue May 16, 2023 · 1 comment · Fixed by #324
Labels
type:bug Something isn't working
Milestone

Comments

@Enriqson
Copy link

I'm trying to run dbt docs generate with Federated Query data using the Redshift Connector and it returns the following error:

[0m15:45:16.272788 [debug] [ThreadPool]: Acquiring new athena connection 'awsdatacatalog.information_schema'
[0m15:45:16.273878 [debug] [ThreadPool]: Acquiring new athena connection 'redshiftCatalog_dev.information_schema'
[0m15:45:16.274842 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m15:45:16.275793 [debug] [ThreadPool]: Opening a new connection, currently in state init
[0m15:45:17.416799 [debug] [ThreadPool]: On redshiftCatalog_dev.information_schema: Close
[0m15:45:17.419386 [warn ] [MainThread]: Encountered an error while generating catalog: 'catalog-id'
[0m15:45:20.555092 [debug] [ThreadPool]: On awsdatacatalog.information_schema: Close
[0m15:45:20.707223 [error] [MainThread]: dbt encountered 1 failure while writing the catalog
[0m15:45:20.709353 [info ] [MainThread]: Catalog written to /app/target/catalog.json

I'm aware of #247 but believe this is an issue with using non-glue data catalogs.

The catalog file and html are generated and aparently look fine, but the error is returned nonetheless.

@Jrmyy Jrmyy added the type:bug Something isn't working label May 25, 2023
@Jrmyy
Copy link
Contributor

Jrmyy commented May 25, 2023

👋🏻 Hello
I will have to check I am not sure Federated Query databases are supported for the moment. I know that shared glue catalogs are supported. We will have to check.

@Jrmyy Jrmyy added this to the v1.5.1 milestone Jun 14, 2023
@Jrmyy Jrmyy modified the milestones: v1.5.1, v1.5.2 Jun 21, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type:bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants