About
This How-to will show you how to use the tabli data list command to list SQL Table.
Steps
Prerequisites
You should have Tabulify installed on your computer. Learning Tabulify - Step 1 - Installation
Listing all tables
Listing all the tables from the Tpcds connection with a data uri selector and the star * glob wildcard character
tabli data list *@tpcds
PATH
------------------------
call_center
catalog_page
catalog_returns
catalog_sales
customer
customer_address
customer_demographics
date_dim
dbgen_version
household_demographics
income_band
inventory
item
promotion
reason
s_call_center
s_catalog_order
s_catalog_order_lineitem
s_catalog_page
s_catalog_returns
s_customer
s_customer_address
s_inventory
s_item
s_promotion
s_purchase
s_purchase_lineitem
s_store
s_store_returns
s_warehouse
s_web_order
s_web_order_lineitem
s_web_page
s_web_returns
s_web_site
s_zip_to_gmt
ship_mode
store
store_returns
store_sales
time_dim
warehouse
web_page
web_returns
web_sales
web_site
Listing one table with its dependencies
Listing the table store_sales from the Tpcds connection and its dependencies
tabli data list --with-dependencies store_sales@tpcds
PATH
----------------------
customer
customer_address
customer_demographics
date_dim
household_demographics
income_band
item
promotion
store
store_sales
time_dim
Filtering the output with a glob pattern
Listing all returns
Listing all the tables that have return in their name with a data uri selector and its glob pattern
tabli data list *return*@tpcds
PATH
-----------------
catalog_returns
s_catalog_returns
s_store_returns
s_web_returns
store_returns
web_returns
Listing all returns and sales tables
With tpcds, the glob expression {*returns,*sales} will returns all returns and sales tables.
tabli data list {*returns,*sales}@tpcds
PATH
-----------------
catalog_returns
catalog_sales
s_catalog_returns
s_store_returns
s_web_returns
store_returns
store_sales
web_returns
web_sales