Hi team, I need to have multiple connections with ...
# contributing-to-airbyte
t
Hi team, I need to have multiple connections with the same source. ex: multiple accounts in Shopify but one database, when using like this there is no way to identify which source data in the database, I'm trying to add an additional parameter with MySQL insert query. I but haven't found a way to get source details in the destination application. any helps ??
u
Hi, couple of solutions here: 1) use same database but different destination variants of destination connectors pointing to the different schemas (2 source, 2 destination connectors looking at same database, pointing to different db schemas) 2) use the prefix for your table in the connections between Source and Destination (2 sources, 1 destination connector)
u
1 cannot go with this solution
u
do you know how this application works ?? how can i pass source details to connector ???
u
Why you cannot go with 1?
t
my application is a customer portal. every customer has to configure their Shopify app. when customers add their credentials, automatically connect those apps to our airbyte. I develop like this. in this situation we have created multiple databases for each customer. that's not possible
u
for example, I have one application that uses only one database schema. I want to insert data from various Shopify clients into that database. also, I want to keep some references to where that data came from. for that, I want to get the source name in the destination with other records
u
@Davin Chia (Airbyte) do we have the opportunity to satisfy this requirements?
u
Currently we have the possibility to pass the additional “prefix” for the table per each connection, have you try to leverage this?
u
thank you. let me try this and let you know
u
yeap I’d use prefixes
u
Yes, if you combine: • using prefixes (or custom namespace if you prefer) to dispatch your source data per account in the destination (shopify_account1, shopify_account2, etc) • using a custom SQL operations at the end of the sync to union all dispatched tables back into a single shopify table but with an added column denoting which account it is coming from https://docs.airbyte.io/understanding-airbyte/connections#destination-stream-name
t
Thanks guys)