====== Tabli - Data Dependency ======


===== About =====
''data dep'' is an operations that list the [[docs:resource:dependency|dependency]] between [[docs:resource:resource|data resources]].



===== Syntax =====
<unit name="Syntax">
<code dos>
tabli data dep --help
</code>
<console>
Tabli data dependency
=====================

List the data dependencies (foreign key, view, ...)



Examples
--------

 1 - To list the dependencies of the tpcds connection:


    tabli data dependency *@tpcds


 2 - To list the foreign keys dependencies of the `sales` star schema asks the fact table `f_sales` in the the sqlite connection and its dependencies :


    tabli data dependency --with-dependencies f_sales@sqlite




Syntax
------


    tabli data dependency [options|flags] <data-selector...>


where:


  Arguments:

    <data-selector...>                                      One or more data or script selectors


  Selection Options:

    -wd,--with-dependencies                                 If set, the dependencies will be also selected


  Global Options:

    -cf,--conf <path>                                       The path to a configuration file

    -cv,--connection-vault <path>                           The path where the connection vault is located

    -h,--help                                               Print this help

    -l,--log-level <error|warning|tip|info|fine>            Set the log level

    -ns,--not-strict                                        A minor error will not stop the process.

    -odu,--output-data-uri <outputDataUri>                  defines the output data uri for the feedback data (default: console)

    -oo,--output-operation <dataOperation>                  defines the data operations (replace, truncate) on an existing output resource before transfer.

    -oop,--output-transfer-operation <transferOperation>    defines the output transfer operation (insert, update, merge, copy). Default to `copy` for a file system and `insert` for a database.

    -pp,--passphrase <passphrase>                           A passphrase (master password) to decrypt the encrypted values
</console>
</unit>
where:
  * ''TableUri'' is a [[docs:resource:table#uri|Table Uri]]