Datastream: how to initiate backfill from new table?

[sasquatch]

I have a new table in my source PostgreSQL database.  I updated the PostgreSQL publication to include the new table.  Now I want to initiate a backfill for the new table in Datastream, but it does not appear in the list of objects.

If I edit the source configuration, the new table does appear under "Select objects to include", so Datastream obviously knows about it.

[NorieRam]

Hi @sasquatch,

Welcome to Google Cloud Community!

If the new table is not appearing in the "Select objects to include" section in Datastream, you can diagnose this issues by trying the following:

• Ensure that the new table is correctly included in the PostgreSQL publication. Verify that there are no issues with the publication itself.
• Go to the source configuration, and double-check that you’ve saved any changes related to the publication. After editing, save the configuration and see if the table appears.
• Review the Datastream documentation for any specific requirements, validations or limitations regarding backfilling new tables.
• Check if your database has over 5,000 objects. If so, the UI might be limited and you'll have to work around that or reach out to Google Cloud Support.

I hope the above information is helpful.

[sasquatch]

Thanks for the reply.  None of those suggestions made a difference, but I eventually got it to work, though I'm not sure exactly how -- the only thing I did was to play around with tables to include and exclude in the source configuration, and run my Terraform script to reset the source configuration to its original state.  Eventually this seemed to cause Datastream to notice the new tables (and also to reload several of the old tables).