Native Queries Relationships

[osdiab]

Hi, I see that Native Queries and Logical Models were released - nice!

I was wondering, while I see in the docs that relationships with tables appear to be supported, it seems that that isn't surfaced in the console UI (I try to add relations and it tells me that I need to make more native queries to bind the relations to, but I want to make a relation with a table). Is this the case?

Also, regarding permissioning logical models, it seems that the options for permissions are much reduced compared to normal tables, for example I want to do an _exists check on a totally different table based on a column value, but that doesn't show up as an option in the Hasura Console logical models UI. Is that planned to be expanded?

Thanks! Looking forward to use native queries but seems like there's still some missing pieces.

[amitava82]

Can any anyone please answer this? Is it possible to create relationship with a table within schema? I tried editing metadata yaml file manually but no luck.

[raulelba]

I hope someone could point us in some direction here. But as far I can tell while the docs already showcase how the table relationships are defined, there doesn't seem to be a way to create them form the schema. And editing the metadata doesn't seem to do it either.

At the top of these docs it says:

SUPPORTED FEATURES
Currently, Hasura aggregations are not supported, but you can write the aggregation yourself as part of the query.

Relationships will be supported in a future release.

So perhaps this is still a work in progress feature. In which case it should be more obvious in the docs.