dbt docs generate error: Database 'NONE' does not exist or not authorized.

Help
, ,
1

The problem I’m having

When i run dbt docs generate i am getting the error: Database ‘NONE’ does not exist or not authorized.

What I’ve already tried

I can run dbt docs generate by model/folder and see the ones it fails on. But when i run each model in the affected folder, they all pass. Looking through the dbt.log file does not give enough info for me to track it down.

Some example code or error messages

Encountered an error while generating catalog: Database Error
  002003 (02000): SQL compilation error:
  Database 'NONE' does not exist or not authorized.

How is dbt gathering a source database of “None”? There are no references in the project to a database we recently deleted, but it seems like there must be some artifact somewhere that we missed/can’t see.

[ThreadPool]: Using snowflake connection "None.information_schema"

[ThreadPool]: On None.information_schema: /* {"app": "dbt", "dbt_version": "1.7.8", "profile_name": "prod", "target_name": "prod", "connection_name": "None.information_schema"} */
with tables as (
            select
        table_catalog as "table_database",
        table_schema as "table_schema",
        table_name as "table_name",
        coalesce(table_type, 'DYNAMIC TABLE') as "table_type",
        comment as "table_comment",

        -- note: this is the _role_ that owns the table
        table_owner as "table_owner",

        'Clustering Key' as "stats:clustering_key:label",
        clustering_key as "stats:clustering_key:value",
        'The key used to cluster this table' as "stats:clustering_key:description",
        (clustering_key is not null) as "stats:clustering_key:include",

        'Row Count' as "stats:row_count:label",
        row_count as "stats:row_count:value",
        'An approximate count of rows in this table' as "stats:row_count:description",
        (row_count is not null) as "stats:row_count:include",

        'Approximate Size' as "stats:bytes:label",
        bytes as "stats:bytes:value",
        'Approximate size of the table as reported by Snowflake' as "stats:bytes:description",
        (bytes is not null) as "stats:bytes:include",

        'Last Modified' as "stats:last_modified:label",
        to_varchar(convert_timezone('UTC', last_altered), 'yyyy-mm-dd HH24:MI'||'UTC') as "stats:last_modified:value",
        'The timestamp for last update/change' as "stats:last_modified:description",
        (last_altered is not null and table_type='BASE TABLE') as "stats:last_modified:include"
    from None.INFORMATION_SCHEMA.tables
            where (upper("table_schema") = upper('none'))
        ),
        columns as (
            select
        table_catalog as "table_database",
        table_schema as "table_schema",
        table_name as "table_name",

        column_name as "column_name",
        ordinal_position as "column_index",
        data_type as "column_type",
        comment as "column_comment"
    from None.INFORMATION_SCHEMA.columns
            where (upper("table_schema") = upper('none'))
        )
        select *
    from tables
    join columns using ("table_database", "table_schema", "table_name")
    order by "column_index"