Add AllowedHosts for all Database Sources

[evantahler]

As part of the network isolation epic, all connectors will need to provide which hosts the connector container will be granted access to.

For databases, this information is dynamic and read from the connector's config. It probably looks a lot like:

airbyte/airbyte-config/init/src/main/resources/seed/source_definitions.yaml

Lines 1370 to 1373 in e6441bf

	allowedHosts:
	hosts:
	- "${host}"
	- "${tunnel_method.tunnel_host}"

This information is to be added to the actor_definitions. A re-publish of the connector is not required.

[DevPJ9]

Hello @evantahler I would like to work on this.

[bleonard]

I seem to remember manybe we had an OC issue with allowed hosts a while back. Am I crazy @evantahler ? Just want to make sure not to mess it up.

[evantahler]

There was a platform-level OC issue (#21923) which was due to the weirdness that is a reset-connection. Adding these values for a connector, even if they are wrong, shouldn't break anything in production.

The path to ensuring your allowedHosts entries are properly interpolating config information is to look at the logs when the containers boot. Look for a log line that interpolates the allowedHosts properly. This is the failure case:

airbyte-worker | 2023-01-26 19:42:58 ERROR i.a.w.u.ConfigReplacer(getAllowedHosts):60 - The allowedHost value, '${host}', is expecting an interpolation value from the connector's configuration, but none is present

More information @ #21950

[prateekmukhedkar]

Work done: PR reviewed for non-GA source connectors.
Work remaining:

1. Close out AlloyDB PR Adding allowedHost for Postgres AlloyDB #23596
2. Publish all new connectors

[prateekmukhedkar]

Plan to publish all database connectors early next week.

[prateekmukhedkar]

Done for all DB Sources except MongoDB, Redshift and Azure Table DB Source because of previously failing integration tests. Moving this to blocked/hold lane until we fix these tests and get them in a publishable state. Issue created for tracking publish https://github.com/airbytehq/airbyte-internal-issues/issues/2714