☁ Cloud Interop: Ability to read from remote Airbyte destinations, emulating the existing "cache" behavior

[aaronsteers]

Related to:

• ☁ Cloud Interop: Ability to deploy jobs to a hosted Airbyte instance (Cloud/OSS/Enterprise) #104
• ☁ Cloud Interop: Basic run_sync() interop with Airbyte Cloud/OSS/Enterprise #33

This feature would allow users to read from destination connections hosted on Airbyte Cloud/OSS/Enterprise.

This would be accomplished by mapping the config from an Airbyte-hosted destination into the PyAirbyte "Cache" constructs which use SQLAlchemy to read from SQL database.

Note:

• For very good security reasons, it is not possible to download config secrets from the Airbyte API. Users will still need to provide their credentials by another means, for instance with environment variables.