[CT-2073] Full compatibility with incremental materialization refactor in v1.3

[jtcohen6]

Given capacity constraints at the time, we made minimal changes in dbt-bigquery for compatibility with the refactor in v1.3:

• [CT-889] Minimal changes to support dbt Core incremental materialization refactor #232
• Changes for incremental strategy refactor compatibility #223

We should add "full" support, akin to what we did in Snowflake:

• [CT-840] Enable Snowflake adapter to work with incremental materialization refactor dbt-snowflake#195
• Support dbt-core incremental refactor dbt-snowflake#196

That way:

• users can opt for the explicit append strategy
• users can define their own custom strategies (names + macros)

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[github-actions]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.

[singler]

+1 on the interest of custom incremental strategies.

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[github-actions]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.