Make `list_relations_without_caching` pagination configurable

mikealfare commented 2 weeks ago

resolves #1234

Problem

Some users have over 100K objects in a single schema. We need to paginate results from show objects since that call is limited to 10K objects by Snowflake. We hard coded this result to 10 pages. However this doesn't allow users to have more than 100K objects in their schema. In this scenario, users are hit with an error that blocks dbt from running anything.

Solution

Allow users to configure the pagination using project flags. They can configure both the number of results per page as well as the number of pages. This defaults to the current setting of 10000 results per page and 10 pages if the flags are not passed in. Example:

# dbt-project.yml
flags:
  list_relations_per_page: 10000
  list_relations_page_limit: 100

Checklist

[x] I have read the contributing guide and understand what's expected of me
[x] I have run this code in development and it appears to resolve the stated issue
[x] This PR includes tests, or tests are not required/relevant for this PR
[x] This PR has no interface changes (e.g. macros, cli, logs, json artifacts, config files, adapter interface, etc) or this PR has already received feedback and approval from Product or DX

github-actions[bot] commented 2 weeks ago

Thank you for your pull request! We could not find a changelog entry for this change. For details on how to document a change, see the dbt-snowflake contributing guide.

mikealfare commented 3 days ago

I think this got accidentally closed with the docs PR.

dbt-labs / dbt-snowflake