[Feature] Micro-batch should allow copy_partitions

[jschintz-nytimes]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-bigquery functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Merging in BQ is great - but not always the most performant

Allow for the existing feature "copy_partitions" to be available in the microbatch incremental strategy

Describe alternatives you've considered

Write a custom strategy

Who will this benefit?

Anyone using microbatch

Are you interested in contributing this feature?

Maybe!

Anything else?

No response

[borjavb]

If I'm not mistaken I think copy_partitions is already working with microbatch.

microbatch under the hood relies on insert_overwrite and the copy_partitions config is being set through all the new microbatch logic.

dbt-bigquery/dbt/include/bigquery/macros/materializations/incremental_strategy/microbatch.sql

Lines 20 to 28 in 8c2d9bb

	{% macro bq_generate_microbatch_build_sql(
	tmp_relation, target_relation, sql, unique_key, partition_by, partitions, dest_columns, tmp_relation_exists, copy_partitions
	) %}
	{% set build_sql = bq_insert_overwrite_sql(
	tmp_relation, target_relation, sql, unique_key, partition_by, partitions, dest_columns, tmp_relation_exists, copy_partitions
	) %}
	{{ return(build_sql) }}
	{% endmacro %}