Loading data to “Partitioned Tables” with Write_Truncate using BQ API

Question

Can one load data with write_truncate to a specific partition? My use case would be a batch load process that overrides a specific partition, while keeping the rest of the table intact. This reference mentions only command line tool: https://cloud.google.com/bigquery/docs/creating-partitioned-tables#restating_data_in_a_partition

Answer 1

Yes. Each partition behaves as if it is separate table so you can have particular partition as destination table with overwrite. Works from UI and API. The rest of the table is not changing.
Even long term storage pricing is applicable for partition tables