[Bug] copy_grants configuration not being sent to DDL for seed tables (Snowflake)

[mklebantg]

Is this a new bug in dbt-core?

• [X] I believe this is a new bug in dbt-core
• [X] I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

• existing privileges for seed table are erased when table is recreated
• COPY GRANTS not found in the DDL

Expected Behavior

• existing privileges should be restored when seed table is recreated from the dbt seed --full-refresh command
• COPY GRANTS should be shown in the query logs when dbt executed the DDL

Steps To Reproduce

1. In project.yml, add +copy_grants: true just below "seeds" through GitHub and merge into master branch
2. run job in dbt cloud a.) job pulls from GitHub master branch b.) includes dbt seed --full-refresh command

project.yml seeds section:

seeds:
  +copy_grants: true
  <project name>:
    +persist_docs:
      relation: true
      columns: true

Relevant log output

No response

Environment

- dbt: cloud version 1.6
- DWH: Snowflake

Which database adapter are you using with dbt?

snowflake

Additional Context

No response

[dbeatty10]

Possibly related: https://github.com/dbt-labs/dbt-snowflake/issues/1030

[mklebantg]

Thanks, @dbeatty10. It looks like the workaround mentioned in #1030 might work.