The data drop action of the data module permits to drop one or more data resources.
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