[Bug] Grants statement results in does not exist error

[jschintz-nytimes]

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-spark

Current Behavior

When applying grants

• if a user chooses to apply a custom grant config within a single model - the table is not ready to apply the grant to yet.
• BQ has some latency for create/replace tables, causing the grant feature to not work correctly

Expected Behavior

Grants should always execute for models built by dbt.
Maybe dbt should poll the materialized model?

Steps To Reproduce

1. In dbt-bigquery
2. Add a grant config to a singular model
3. Run

Relevant log output

23:46:36    Database Error in model digi_price_increase_log (models/marts/stuff/logs.sql)
  Access Denied: Table dbt-things:stuff.logs: Permission bigquery.tables.setIamPolicy denied on table nyt-dbt-things:stuff.logs (or it may not exist).

Environment

- OS:
- Python:
- dbt-adapters:
- <adapter>:

Additional Context

No response