Error starting Datastream from Postgres to Big query - PostgreSQL backfill permissions - Failed

[suryakolachana]

Hello Datastream Team,

We are trying to use DataStream to replicate data from GCP Cloud SQL PostgreSQL to GCP BigQuery. I've set up the Datastream with the PostgreSQL database as the source profile. All the IPs from the DataStream were added to the Authorized Networks in the GCP Cloud SQL PostgreSQL Instance. We were able to successfully connect. The  Stream, source, and destination connections were created in the same region - us-east4. I validated that:

1) Connectivity tests pass.

2) All except one on the Validation test at the end of the Stream creation wizard were passed.

3) I have enabled Enable logical replication on the database.
4) I have created a publication and a replication slot created a datastream user and granted all the sufficient privileges as per the documentation to the schema and tables.

Here is the error message I get: 

Failed to start dev

PostgreSQL backfill permissions: Failed

One or more tables in the stream's include list weren't found or Datastream couldn't read from them. Make sure that the tables exist and that Datastream has the necessary permissions.

public. test

Can someone help me troubleshoot the issue?

Thank you.

[nceniza]

Did you followed this article for preparing data for postgresql: 

https://cloud.google.com/datastream/docs/configure-your-source-postgresql-database#csqlforpostgresql

It looks like it is missing a permission on the table that is included in the stream. I would suggest filing a support case for this concern for better investigation of your project, data and resources: https://cloud.google.com/contact

[RyanSchulte]

Did you ever find a solution for this?  I am experiencing the same.