stream analytics "test connection is not supported for data source type Microsoft.DBForPostgreSQL/servers/databases"

Ryan Shepherd 1

My stream analytics input is an Event Hub, and my output is an Azure Database for PostgreSQL flexible server instance. The input test connection works, and the test query works. I selected the existing DB instance from the dropdowns when creating the output. When I test the output connection I get "test connection is not supported for data source type Microsoft.DBForPostgreSQL/servers/databases". I can start the job and it runs, but I get no output and nothing in the activity log when I send input. Does this have anything to do with the PostgreSQL output being a "preview" feature, and if so, what is the expected timeframe? I would love to be able to test end-to-end.

PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee

2021-12-03T11:14:18.463+00:00

Hello @Ryan Shepherd ,

Thank you for the question and using MS Q&A platform.

We are reaching out to the internal team to get more details on this issue. I will be update you once I hear back from the team.
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee

2021-12-08T10:59:36.567+00:00

Hello @Ryan Shepherd ,

We are still awaiting for the response from the internal team. I will be update you once I hear back from the team.
PRADEEPCHEEKATLA-MSFT 85,586 Reputation points Microsoft Employee

2021-12-13T05:17:34.327+00:00

Hello @Ryan Shepherd ,

We haven't got any response from the internal team. For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket.

Share via

stream analytics "test connection is not supported for data source type Microsoft.DBForPostgreSQL/servers/databases"