Disabling information schema queries

Help
1

I am using dbt to create models in Dremio. Every time I run any models, even when selecting just a single model it takes 5 minutes before any models actually run due to the information schema queries taking about a minute each for the schemas in the project.

I found this post (Replace information_schema queries with faster alternatives on Snowflake · Issue #1877 · dbt-labs/dbt-core · GitHub) but didn’t find a way to disable these information schema queries. The OP said there is no way but I’m hoping that changed since 2019.

I just want to be able to turn them off while I am developing models, having to wait 5 full minutes every time I run is slowing my progress significantly.

An example of the information schema queries running (obfuscated)

/* {"app": "dbt", "dbt_version": "1.5.3", "profile_name": "----", "target_name": "dev", "connection_name": "--------"} */


      select (case when position('.' in table_schema) > 0
              then substring(table_schema, 1, position('.' in table_schema) - 1)
              else table_schema
          end) as table_catalog
          ,table_name
          ,(case when position('.' in table_schema) > 0
              then substring(table_schema, position('.' in table_schema) + 1)
              else 'no_schema'
          end) as table_schema
          ,lower(table_type) as table_type
      from information_schema."tables"
        where ilike(table_schema, '--------')
      and table_type <> 'system_table'
2

You might be able to try some of the cache control flags.

If you use dbt --no-populate-cache run then dbt won’t pre-cache any information. If you use dbt --cache-selected-only run --select some_model then it will only pre-cache nodes which are part of your selection.

I’m not 100% sure that those introspective queries are populating the cache, but I expect they will be part of it!