Skip to content

[BUG or Code 18?] #143

@jeanmichelbouchard

Description

@jeanmichelbouchard

Describe the bug

Hi, I am trying to generate a diagram for a specific set of views using --select to list them. I am not able to have dbterd to pick the view from the catalog. It always returns with an empty diagram and the "INFO - Collected 0 table(s) and 0 relationship(s)" message.

Things I tested and returned empty diagram

  • Use only the view name : dbterd run --select V_F_VEHICULE_PERSONNEL_TRANSACTION_PRIME
  • Try in lower case even though its in upper case in dbt : dbterd run --select v_f_vehicule_personnel_transaction_prime
  • Try with the "model" prefix : dbterd run --select model.V_F_VEHICULE_PERSONNEL_TRANSACTION_PRIME
  • Try adding the project name : dbterd run --select model.dbt_VDE.V_F_VEHICULE_PERSONNEL_TRANSACTION_PRIME
  • Try with the schema name also : dbterd run --select model.dbt_VDE.AFFAIRE.V_F_VEHICULE_PERSONNEL_TRANSACTION_PRIME
  • Other variants : dbterd run --select model.AFFAIRE.V_F_VEHICULE_PERSONNEL_TRANSACTION_PRIME
  • dbterd run --select AFFAIRE.V_F_VEHICULE_PERSONNEL_TRANSACTION_PRIME

Things I tested and gave me results

  • No selectors : dbterd run
    INFO - Collected 1009 table(s) and 0 relationship(s)

  • Using the schema : dbterd run --select schema:AFFAIRE
    Result : INFO - Collected 755 table(s) and 0 relationship(s)
    In the model there is my view and the name matchs one of my tries above:
    Table "model.dbt_VDE.V_F_VEHICULE_PERSONNEL_TRANSACTION_PRIME" {

  • Use of wildcards : dbterd run --select wildcard:V_F_VEHICULE_PERSONNEL_TRANSACTION_PRIME
    Result: INFO - Collected 4 table(s) and 0 relationship(s) (test_relationship.py:62)
    In the model there is my view and the name matchs one of my tries above:
    Table "model.dbt_VDE.V_F_VEHICULE_PERSONNEL_TRANSACTION_PRIME" {

Desktop (please complete the following information):

  • OS: Windows 11

  • dbterd --version
    2026-05-17 09:36:04,735 - dbterd - INFO - Run with dbterd==1.25.0 (main.py:59)
    2026-05-17 09:36:04,736 - dbterd - INFO - Using algorithm [test_relationship] (executor.py:79)
    2026-05-17 09:36:04,736 - dbterd - INFO - Using dbt artifact dir at: D:\git\dbt\dbt_VDE/target (executor.py:125)
    2026-05-17 09:36:04,942 - dbterd - INFO - Auto-detected manifest version: 12 (executor.py:218)
    2026-05-17 09:36:04,943 - dbterd - INFO - Patching manifest v12 for compatibility... (file.py:191)
    2026-05-17 09:36:05,857 - dbterd - INFO - Auto-detected catalog version: 1 (executor.py:241)
    2026-05-17 09:36:05,858 - dbterd - INFO - Patching catalog v1 for compatibility... (file.py:223)
    2026-05-17 09:36:07,662 - dbterd - INFO - Collected 1009 table(s) and 0 relationship(s) (test_relationship.py:62)
    2026-05-17 09:36:07,697 - dbterd - INFO - Output saved to D:\git\dbt\dbt_VDE\target/output.dbml (executor.py:261)

  • dbt version
    Core:

    • installed: 1.9.0
    • latest: 1.11.10 - Update available!

    Your version of dbt-core is out of date!
    You can find instructions for upgrading here:
    https://docs.getdbt.com/docs/installation

Plugins:

  • snowflake: 1.9.0 - Update available!

Thank you for your help

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions