Hello, I am Currently syncing multiple postgres sources to a single bigquery destination. I want to add some kind of sourceID to the table to distinguish the data. I am open for all advices and tips.

Adding Database Name along with each record should do the trick in my opinion

You mean adding sourceID to the name for the database or table?

Yeah Source ID as DB name.