# Disabling information schema queries

**URL:** <https://discourse.getdbt.com/t/disabling-information-schema-queries/17324>\
**Category:** Help\
**Tags:** dbt-core\
**Created:** [December 11, 2024, 10:10pm UTC](https://discourse.getdbt.com/t/disabling-information-schema-queries/17324 "2024-12-11T22:10:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dyllan.hankins](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/dyllan.hankins/32/5014_2.png) [@dyllan.hankins](https://discourse.getdbt.com/u/dyllan.hankins)\
**Post date:** [December 11, 2024, 10:10pm UTC](https://discourse.getdbt.com/t/disabling-information-schema-queries/17324/1 "2024-12-11T22:10:23Z")

</div>

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](https://github.com/dbt-labs/dbt-core/issues/1877)) 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)

```auto
/* {"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'

```

---

<div class="post-metadata">

**Author:** ![joellabes](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/joellabes/32/3980_2.png) [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Post date:** [December 12, 2024, 12:17am UTC](https://discourse.getdbt.com/t/disabling-information-schema-queries/17324/2 "2024-12-12T00:17:02Z")

</div>

You might be able to try some of the [cache control flags](https://docs.getdbt.com/reference/global-configs/cache).

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!