Tabli - Data List Command

Undraw Windows

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 resource)

Syntax

The important notions for this command are:

tabli data list --help
Tabli data list
===============

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



Examples
--------

 1 - List all the current files


    tabli data list *


 2 - List all the tables of the current schema of the `oracle` data store


    tabli data list *@oracle


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


    tabli data list D*@sqlite




Syntax
------


    tabli 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>                          Set the data resource attributes to show (`path`, `name`,`count`, `size`, `type`, `connection`, ...)


  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




Related HowTo
Undraw Windows
How to copy the data definition of all tables from a star/snowflake schema

This howto will show you how to copy the data definition of all SQL tables from a star/snowflake schema.
Undraw Windows
How to list SQL Tables

This howto will show you how to list SQL Tables
Undraw Windows
How to load a JSON documents in a database

This howto will show you how to load json document (files) into your relational database.
Undraw Windows
HowTo - How to load XML files into a database with Tabulify

This database howto will show you how to load Xml file and document into a database.
Undraw Windows
Learning Tabulify - Step 4 - How to select Data Resources

To select a data resources such as a file or a database table, Tabulify uses the concept of: and dependency (Do we select also the dependent data resources) This page goes through this concepts...
Undraw Windows
Learning Tabulify - Step 6 - How to transfer Data Resources

In Tabulify, when you want to manipulate data, it's called a transfer. You want to move data, you transfer You want to copy data, you transfer You want to insert data, you transfer You want to...

Task Runner