How do you join a federated dataset with a cloud amplifier dataset from Snowflake?

Best Answers

  • thoffman
    thoffman Member
    Answer ✓

    Hey HLIN,

    According do Domo documentation, Federated Datasets do not support Magic ETL. I've also just confirmed in my own instance that we are not able to use federated datasets as inputs in SQL transforms either:

    https://domo-support.domo.com/s/article/360042932974?language=en_US

    As for actually getting your data together, you would need to shift your focus to joining them outside of Domo or convert the federated dataset to a cloud amplifier dataset.

  • alagare
    alagare Domo Employee
    Answer ✓

    After a DataSet is created in Domo from a Federated connection, it is referred to as a Federated DataSet. These DataSets do not support Magic ETL, including Data Science actions. Alternatively, you can create Views with the on-premise DataSet.

    If you want to join a Federated DataSet, you should either join them outside of Domo or convert the Federated DataSet to a Cloud Amplifier DataSet in your Snowflake database before pulling it into Domo.

    https://domo-support.domo.com/s/article/360042932974?language=en_US#supported_databases

    Can Domo's ETL and SQL tools be used to transform Federated DataSets?

    No, this is currently not supported. I recommend submitting an enhancement request through the Ideas Exchange platform. This helps our product development team prioritize new feature requests.

    https://community-forums.domo.com/main/categories/ideas

Answers

  • thoffman
    thoffman Member
    Answer ✓

    Hey HLIN,

    According do Domo documentation, Federated Datasets do not support Magic ETL. I've also just confirmed in my own instance that we are not able to use federated datasets as inputs in SQL transforms either:

    https://domo-support.domo.com/s/article/360042932974?language=en_US

    As for actually getting your data together, you would need to shift your focus to joining them outside of Domo or convert the federated dataset to a cloud amplifier dataset.

  • alagare
    alagare Domo Employee
    Answer ✓

    After a DataSet is created in Domo from a Federated connection, it is referred to as a Federated DataSet. These DataSets do not support Magic ETL, including Data Science actions. Alternatively, you can create Views with the on-premise DataSet.

    If you want to join a Federated DataSet, you should either join them outside of Domo or convert the Federated DataSet to a Cloud Amplifier DataSet in your Snowflake database before pulling it into Domo.

    https://domo-support.domo.com/s/article/360042932974?language=en_US#supported_databases

    Can Domo's ETL and SQL tools be used to transform Federated DataSets?

    No, this is currently not supported. I recommend submitting an enhancement request through the Ideas Exchange platform. This helps our product development team prioritize new feature requests.

    https://community-forums.domo.com/main/categories/ideas

  • HLIN
    HLIN Member

    Thank you both for your answers. I ended up creating an ETL outside of Domo.