Merging to .db sqlite3 databases, one table isn't coming over

I’m having trouble understanding why a dataset isn’t concatenating with another. I have 2 work flows from the same database Teradata.

1. pulls the same query but for 2019-2024 (3GB dataset) to appease the DB admins.

2. pulls >=2025 (just a date reference change)

3. Both sequences are written to a .db file using sqlite connector and db writer.

4. Then using concatenate to merge them using Union and writing as a final Master.db file

Keeping their databases separate up front as this is local to my laptop and if I mess something up I can for a lack of understanding knime and sql, work backwards to where I might have messed up.

so Historical.db (StaticIP table name) + Monthly.db (MonthlyIP table name) = Master.db

only difference is the table names, which I’m not sure how they are assigned otherwise I’d make them the same… hoping someone can help my understanding of what I’m missing or doing wrong.