Hello everyone! 🙋‍♂️ I'm a developer and currently developing a data pipeline that uses Airbyte as the main source. In our platform, we have a multi-tenant scenario, where people belong to different workspaces (like in airbyte), and have a

workspace_uuid

associated to them. When we create a new connection using, for example, Hubspot as source and PostgreSQL as destination, we would like the stream to return airbyte's

workspace_uuid

, in order to know, later on in Postgres, where these values come from (all workspaces have a different

api_key

to connect to Hubspot and therefore their data is different). Could anyone help me find the best solution to the multi-tenant problem? I can't insert airbyte's

workspace_uuid

in the output stream because Hubspot's connector is already built, and I am not comfortable with creating one table for each workspace in Postgres. I don't know if there are any other solutions. Thanks in advance and sorry for the long post! 😄

Hola @David Rodríguez Pozo . Please, let me add myself to this thread, I'm in the same scenario than you, so I think this can be usefull. Thank You

Today it isn't possible to do this. There is an issue "close" to what you're requesting: https://github.com/airbytehq/airbyte/issues/4025. Do you mind create another issue requesting this feature? As a workaround you can use the table_prefix to label your connection and differentiate them. You can use dbt to unite all tables in the final easily though

Sure Marcos! I will create the issue. Thanks for replying.

This is so similar to our use-case, thank you for create the issue. Where could I find the source-code for the CREATE TABLE and INSERT statements at the downloaded git project folders? It's available there? I've looked for it at postgres-destination folder java files but did'nt find it of course