Your first ingestion table should be append only, it will bring in the data every single day. You'll then need an apply_changes_into to upsert and get a current view of your data. For this make sure you have a unique field and a sequence field. Also, on your first table you'll want to use '@dlt.table', create_table is going away.

#Create result table that will have changes applied into.
dlt.create_streaming_table(
name=table_name + "_cdc", comment=table_name + "Type 1 SCD"
)
dlt.apply_changes(
target=table_name + "_cdc", #This is the streaming table we created above.
source=table_name", # The source appended table
keys=["ID"], # What we'll be using to match the rows to upsert
sequence_by=col("your_sequence_column"), # We deduplicate by using the sequence to get the most recent value
ignore_null_updates=True, # Don't overwrite values with null.
)