Description
What's the use case?
I'm using dbt and Power BI assets. dbt asset keys are defined in the following format:
- domainA/subdomain1/dbt_model2
- domainB/subdomain3/dbt_model4
domain and subdomain in AssetKeys help to structure Dagster project for better maintainability.
PowerBI assets are retrieved from PowerBI workspace via load_powerbi_asset_specs.
I'd like to achieve end to end lineage starting from sources defined in dbt assets till reports in PowerBI. The challenge is how to define upstream dependencies for PowerBI assets so AssetKeys includes domain/subdomain prefix.
As dbt_model name is unique, it is possible to fetch full AssetKey from dbt project and map it to PowerBI table. Is there a more elegant way to implement dbt-PowerBI dependency mapping?
Ideas of implementation
No response
Additional information
No response
Message from the maintainers
Impacted by this issue? Give it a 👍! We factor engagement into prioritization.