Tabli - Data Drop command

Undraw Windows

About

The data drop action of the data module permits to drop one or more data resources.

How-to's

Syntax

tabli data drop --help
Tabli data drop
===============

Drop data resource(s)



Examples
--------

 1 - To drop the tables D_TIME and F_SALES in the Oracle connection:
tabli data drop D_TIME@oracle F_SALES@oracle


 2 - To drop only the table D_TIME with force (ie deleting the foreign keys constraint):
tabli data drop --force D_TIME@sqlite


 3 - To drop all dimension tables that begins with (D_):
tabli data drop D_*@sql-server


 4 - To drop all tables from the current schema:
tabli data drop *@database




Syntax
------


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


where:


  Arguments:

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


  Options:

    --force                                                 if set, the foreign keys referencing the tables to drop will be dropped


  Selection Options:

    -wd,--with-dependencies                                 if set, the foreign table referencing the tables will be dropped


  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 load your database with the TPCDS benchmark

This howto will show you how to load a relational database schema in order to create a benchmark with the data query command

Task Runner