Graph sql query complete DB List

1

It will be very help full tif some one help me with sql query to get all parent and child relationship.

Example : source has view1
view1 has view 2
view 2 has view 3
so on …

currently graph gives only 1 relationship.But I need sql query to get complete DB list of views with parent and child relationship.

2

@shrutesh

As answered via email you can use the Graph API

https://docs.dremio.com/rest-api/catalog/get-catalog-id-graph.html