Hi @ChristianRRL ,

If I understand correctly you have an API to get historical data for a column.
If yes, you can use MERGE clause.
You will join the by key columns with the target table to backfill and when there is a match, then you will UPDATE SET target.column_to_backfill = source.column_from_api.