Rob Martorano
04/24/2023, 11:45 PMload_table_from_dataframe
by default doesn't allow column addition. The 2 config options that bigquery seems to expose are:
• setting the job WriteDisposition to WRITE_TRUNCATE
(this replaces the whole table and is nice because it also allows incompatible changes like changing a column type, but doesn't fit in as well with the DBIOManager abstraction and would only work for non partitioned tables)
• passing ALLOW_FIELD_ADDITION
as a schemaUpdateOption
I'm not sure the best way to expose these options but one or both would very helpful (we currently have a handwritten bq io manager that we've been using which uses `WRITE_TRUNCATE`ours doesn't support partitions though so excited to migrate!)jamie
04/25/2023, 3:14 PMRob Martorano
04/25/2023, 3:19 PMDan Meyer
06/14/2023, 3:03 PM