Tabli - 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:
- tabli data dep is the tabli data dep command
- *@tpcds is a data selector that selects all data resource (because of the glob *) in the Tpcds connection.
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 [email protected]
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]