[Feature-request] [BigQuery Destination] Allow Custom Partitioning with Full Refresh

[Jeroen Maagdenberg (jmaagdenbergSB)]

Context

I am currently running a daily Full Refresh sync on a large dataset spanning several years. Because the destination table is not partitioned by the business logic date (event_date), but rather by the default _airbyte_extracted_at (which is redundant in a Full Refresh scenario), downstream compute costs are excessively high.

Proposed Change

Allow users to specify a custom partition column (e.g., event_date) within the destination connector configuration, rather than defaulting to the Airbyte metadata columns. (at least for the Full Refresh).