How to list the data dependencies

About

Data resources have dependencies and the tabli data dep command lets you list them.

The below output shows you the foreign key dependencies but you may also see view dependency where the tables in the view query makes them dependencies of the view.

Example

Example with the Tpcds connection.

tabli data dep *@tpcds

where:

Output:

Id   Data Resource            Dependency
--   ----------------------   ----------------------------
 1   call_center              [email protected]
 2   catalog_page             [email protected]
 3   catalog_returns          [email protected]
 4   catalog_returns          [email protected]
 5   catalog_returns          [email protected]
 6   catalog_returns          [email protected]
 7   catalog_returns          [email protected]
 8   catalog_returns          [email protected]
 9   catalog_returns          [email protected]
10   catalog_returns          [email protected]
11   catalog_returns          [email protected]
12   catalog_returns          [email protected]
13   catalog_returns          [email protected]
14   catalog_returns          [email protected]
15   catalog_returns          [email protected]
16   catalog_sales            [email protected]
17   catalog_sales            [email protected]
18   catalog_sales            [email protected]
19   catalog_sales            call_center@tpcds
20   catalog_sales            [email protected]
21   catalog_sales            [email protected]
22   catalog_sales            [email protected]
23   catalog_sales            [email protected]
24   catalog_sales            [email protected]
25   catalog_sales            [email protected]
26   catalog_sales            [email protected]
27   catalog_sales            [email protected]
28   customer                 [email protected]
29   customer                 [email protected]
30   customer                 [email protected]
31   customer                 [email protected]
32   household_demographics   [email protected]
33   inventory                [email protected]
34   inventory                [email protected]
35   inventory                [email protected]
36   promotion                [email protected]
37   promotion                [email protected]
38   store                    [email protected]
39   store_returns            [email protected]
40   store_returns            [email protected]
41   store_returns            [email protected]
42   store_returns            [email protected]
43   store_returns            [email protected]
44   store_returns            [email protected]
45   store_returns            [email protected]
46   store_returns            [email protected]
47   store_returns            [email protected]
48   store_returns            [email protected]
49   store_sales              [email protected]
50   store_sales              [email protected]
51   store_sales              [email protected]
52   store_sales              [email protected]
53   store_sales              [email protected]
54   store_sales              [email protected]
55   store_sales              [email protected]
56   store_sales              [email protected]
57   store_sales              [email protected]
58   web_page                 [email protected]
59   web_page                 [email protected]
60   web_returns              [email protected]
61   web_returns              [email protected]
62   web_returns              [email protected]
63   web_returns              [email protected]
64   web_returns              [email protected]
65   web_returns              [email protected]
66   web_returns              [email protected]
67   web_returns              [email protected]
68   web_returns              [email protected]
69   web_returns              [email protected]
70   web_sales                [email protected]
71   web_sales                [email protected]
72   web_sales                [email protected]
73   web_sales                [email protected]
74   web_sales                [email protected]
75   web_sales                [email protected]
76   web_sales                [email protected]
77   web_sales                [email protected]
78   web_sales                [email protected]
79   web_sales                [email protected]
80   web_sales                [email protected]
81   web_sales                [email protected]
82   web_site                 [email protected]

Task Runner