Skip to main content
Question

How to query a reverse direct relation using an SQL transformation?

  • January 9, 2025
  • 1 reply
  • 25 views
A
Active

Hi,

Can you please provide an example illustrating how to query a property of a view in a CDF data model that is a reverse direct relation, using an SQL transformation?

My concrete example looks something like this.:
 

type Book{

    title: String

    author_rel: Author

}

 

type Author{

    name: String 

    books_rel: [Book] @reverseDirectRelation(throughProperty: "author_rel")

}


However, it would also be nice to get examples for the case of a list direct relations or list of reverse direct relations.


Best regards,

Arnfinn Aamodt

AKSO DataOps

1 reply

H
Active

I am also very interested in this, as the Transformations is the tool of choice for my company (as it should be), and we have started to use reverse direct relations in several of our models.

Mithila Jayalath
1 person likes this
  • Mithila Jayalath
    Mithila Jayalath

Reply


Terms & ConditionsCookie Settings

Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings