Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEATURE] Support multi-source Effectivity Satellites #131

Open
DVAlexHiggs opened this issue Jul 1, 2022 · 1 comment
Open

[FEATURE] Support multi-source Effectivity Satellites #131

DVAlexHiggs opened this issue Jul 1, 2022 · 1 comment
Assignees
Labels
feature This is is requesting a new feature

Comments

@DVAlexHiggs
Copy link
Member

DVAlexHiggs commented Jul 1, 2022

Is your feature request related to a problem? Please describe.
In the case where multiple sources feed a Link, we will also need to track multiple sources in an Effectivity Satellite, which is not currently supported by dbtvault.

Describe the solution you'd like
Allow multiple sources to be provided to the source_model parameter and handle the multi-sources in the eff_sat macro.

Describe alternatives you've considered
Having a single effectivity satellite per Link could work but this is awkward and not ideal.

Additional context
Highlighted by a user on Slack

AB#5374

@DVAlexHiggs DVAlexHiggs added the feature This is is requesting a new feature label Jul 1, 2022
@DVAlexHiggs DVAlexHiggs self-assigned this Jul 1, 2022
@philmaddocks
Copy link

philmaddocks commented Jan 2, 2024

Are there any updates as to when this feature will be available in AutomateDV? (I've asked about it in the Slack Channel also)

We've got scenarios where we have multiple sources populating a link for the same business relationship. This is been due to data being migrated to new source systems which then become the master of the relationship

Example:
Adviser data belonged in the core insurance platform but has since been migrated to Salesforce. This has meant the relationship between an adviser and relationship_manager has also moved to Salesforce. This is fine as the link can be loaded from multiple sources, but we aren't currently able to track effectivity across the link. We could create an eff sat per source which hangs off the link which will say in each source what is the effective relationship, but this isn't ideal.

@DVAlexHiggs DVAlexHiggs added feature This is is requesting a new feature and removed feature This is is requesting a new feature labels May 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature This is is requesting a new feature
Projects
None yet
Development

No branches or pull requests

2 participants