If I have a table which has been fully refreshed a...
# best-practices
i
If I have a table which has been fully refreshed and I need to add a column, do I need to truncate and refill the table, or will passing a --full-refresh flag upsert/merge that column into the table automatically based on the PK?
1
e
It depends on the target, but yeah most of them should automatically add the new column, and doing the full-refresh should backfill that column.
i
Awesome - thank you!
e
np!