Table of Contents

About

data list is a command of the data module that lists the data resources and their attributes in a tabular format.

The data list is a super command that extends the shell ls command to support not only the listing of files but also of tables (and by extension all other data resources)

Syntax

The important notions for this command are: 

tabul data list --help

Tabul data list
===============

Print a list of data resources (files, tables, ...)



Examples
--------

 1 - List all the current files


    tabul data list *


 2 - List all the tables of the current schema of the `sqlite` connection


    tabul data list *@sqlite


 3 - List all the tables that begins with `D` of the `sqlite` connection


    tabul data list D*@sqlite




Syntax
------


    tabul data list [options|flags] <data-selector...>


where:


  Arguments:

    <data-selector...>                                      One or more name data resource selectors (ie pattern[@connection])


  Data Definition Options:

    -a,--attribute <attributeName>                          Add one or more data resource attribute


  Selection Options:

    --strict-selection                                      If set the selection will return an error if no data resources have been selected

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


  Global Options:

    -ah,--app-home <path>                                   The app home directory (default to the .tabul.yml file directory)

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

    -ee,--exec-env <name>                                   The execution environment (prod or dev)

    -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 vault values (Env: TABUL_PASSPHRASE)

    --pipe-mode                                             Use pipe mode if you want to pipe the output in a shell. Pipe mode will not print the headers (ie column name) and will not make the control character visible

    -v,--version                                            Print version information