Skip to content

    • Datasets

    Datasets

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

    Member
    in Datasets

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • 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:

      image.png

      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.

    • 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

    • 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:

      image.png

      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.

    • 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

    • Member

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories