Skip to content

[Bug] (BigQuery) docs generate: "table_owner" does not match the name of any column in this table #1135

@arthurcw

Description

@arthurcw

Is this a new bug?

  • I believe this is a new bug
  • I have searched the existing issues, and I could not find an existing issue for this bug

Which packages are affected?

  • dbt-adapters
  • dbt-tests-adapter
  • dbt-athena
  • dbt-athena-community
  • dbt-bigquery
  • dbt-postgres
  • dbt-redshift
  • dbt-snowflake
  • dbt-spark

Current Behavior

When running dbt docs generate, the following warning appears repeatedly before completion:

agate/type_tester.py:92: RuntimeWarning: "table_owner" does not match the name of any column in this table.
  warnings.warn('"%s" does not match the name of any column in this table.' % name, RuntimeWarning)

Expected Behavior

No RuntimeWarning messages

Steps To Reproduce

  1. dbt-core 1.9.4, dbt-bigquery 1.9.1
  2. profiles with bigquery as connection type
  3. Run dbt docs
  4. The warning message appears repeatedly after Building catalog message

Relevant log output

#31 4.523 21:09:52  Running with dbt=1.9.4
#31 8.064 21:09:55  Registered adapter: bigquery=1.9.1
#31 8.311 21:09:55  Unable to do partial parsing because saved manifest not found. Starting full parse.
#31 46.64 21:10:34  Found x models, y snapshots, z data tests, a seeds, b operations, i sources, m exposures, n macros
#31 46.95 21:10:34  
#31 46.95 21:10:34  Concurrency: 8 threads (target='dev')
#31 46.95 21:10:34  
#31 246.3 21:13:53  Building catalog
#31 262.1 /lib/python3.11/site-packages/agate/type_tester.py:92: RuntimeWarning: "table_owner" does not match the name of any column in this table.
#31 262.1   warnings.warn('"%s" does not match the name of any column in this table.' % name, RuntimeWarning)
...repeated many times
#31 341.7 21:15:29  Catalog written to /dbt/targets/catalog.json

Environment

- OS: macOS or Linux-5.15.0
- Python: 3.11.12
- dbt-core: 1.9.4
- dbt-bigquery: 1.9.1

Additional Context

This bug / warning seems to have been introduced after PR #1057 is merged, specifically due to the addition of table_owner to the text_only_columns list. It looks like the BigQuery version of the catalog macro (https://github.com/dbt-labs/dbt-adapters/blob/f38ece924ce79b2bd049bfaa73eeda817f84e989/dbt-bigquery/src/dbt/include/bigquery/macros/catalog/catalog.sql) does not have the table_owner field. Therefore, agate issues the warning in the _catalog_filter_table() method.

The warning goes away if table_owner is removed from the list.

Metadata

Metadata

Assignees

No one assigned

    Labels

    feature:docsIssues related to dbt docs commandpkg:dbt-bigqueryIssue affects dbt-bigquerytype:bugSomething isn't working as documented

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions