Hi team, I am new to Meltano and evaluating it for...
# getting-started
p
Hi team, I am new to Meltano and evaluating it for a use case where I would like to have data belonging to multiple tenants (say all using Stripe) synced to a common destination (e.g. Postgres). Is this possible? My understanding is that for each tenant, I will have to create a new project and setup the specific credentials for the tenant in the respective yaml file. However, if I specify the destination as a common database, how will I differentiate the data from tenant 1 to tenant 2? Is there a way to add a column in the destination tables with a tenant ID or something?
t
Hey Piyush! Using a Stream Map could be an option for you. For each client you can add a new column that indicates the tenant id https://sdk.meltano.com/en/latest/stream_maps.html Also, depending on the use case what we’re building with https://arch.dev/ could possibly be a fit. Let me know if you want to chat more about that.
👍 1
Actually, I see you’ve already emailed 😄
Will reply there!
p
Thanks @Taylor Murphy (Arch). Yes would like to explore Arch