How to combine federated dataSet to another dataset?

Quyen
Quyen ⚪️
in Beastmode & Analytics
Capture.PNG

I tried to combine 2 datasets using ETL but then realized that Federated dataset does not support ETL. So is there any other method to combine 2 datasets on this case?

Thank you,

Answers

  • Aditya_Jain
    Aditya_Jain 🟠

    @Quyen

    Try creating a View on top of the federated query and join the excel / file upload there in the view.

    A federated query can not be brought to Magic ETL but for a snowflake, we can have a view ( I think it's still BETA) but it should work.


    Thanks

    'Happy to Help'

Categories