Last updated: July 02, 2024
dqo table command-line command
The reference of the table command in DQOps. Modify or list tables
dqo table import
Import tables from a specified database
Description
Import the tables from the specified database into the application. It allows the user to import the tables from the database into the application for performing various database operations.
Command-line synopsis
$ dqo [dqo options...] table import [-h] [-fw] [-hl] [-c=<connection>] [-of=<outputFormat>]
[-s=<schema>] [-t=<table>]
DQOps shell synopsis
dqo> table import [-h] [-fw] [-hl] [-c=<connection>] [-of=<outputFormat>]
[-s=<schema>] [-t=<table>]
Command options
All parameters supported by the command are listed below.
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection name | ||
-fw--file-write |
Write command response to a file | ||
--headless-hl |
Starts DQOps in a headless mode. When DQOps runs in a headless mode and the application cannot start because the DQOps Cloud API key is missing or the DQOps user home folder is not configured, DQOps will stop silently instead of asking the user to approve the setup of the DQOps user home folder structure and/or log into DQOps Cloud. | ||
-h--help |
Show the help for the command and parameters | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
|
-s--schema |
Schema name | ||
-t--table |
Table name, without the schema name. |
dqo table edit
Edit table that matches a given condition
Description
Edit the table or tables that match the filter conditions specified in the options. It allows the user to modify the details of an existing table in the application.
Command-line synopsis
$ dqo [dqo options...] table edit [-h] [-fw] [-hl] [-c=<connection>] [-of=<outputFormat>] [-t=<table>]
DQOps shell synopsis
Command options
All parameters supported by the command are listed below.
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection Name | ||
-fw--file-write |
Write command response to a file | ||
-t--table--full-table-name |
Full table name (schema.table), supports wildcard patterns 'sch.tab' | ||
--headless-hl |
Starts DQOps in a headless mode. When DQOps runs in a headless mode and the application cannot start because the DQOps Cloud API key is missing or the DQOps user home folder is not configured, DQOps will stop silently instead of asking the user to approve the setup of the DQOps user home folder structure and/or log into DQOps Cloud. | ||
-h--help |
Show the help for the command and parameters | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
dqo table add
Add table with specified name
Description
Add a new table with the specified name to the database. It allows the user to create a new table in the application for performing various operations.
Command-line synopsis
$ dqo [dqo options...] table add [-h] [-fw] [-hl] [-c=<connectionName>] [-of=<outputFormat>]
[-t=<fullTableName>]
DQOps shell synopsis
Command options
All parameters supported by the command are listed below.
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection Name | ||
-fw--file-write |
Write command response to a file | ||
--headless-hl |
Starts DQOps in a headless mode. When DQOps runs in a headless mode and the application cannot start because the DQOps Cloud API key is missing or the DQOps user home folder is not configured, DQOps will stop silently instead of asking the user to approve the setup of the DQOps user home folder structure and/or log into DQOps Cloud. | ||
-h--help |
Show the help for the command and parameters | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
|
-t--table |
Table name |
dqo table remove
Remove tables that match a given condition
Description
Remove one or more tables that match a given condition. It allows user to use various filters, such as table names to narrow down the set of tables to remove.
Command-line synopsis
$ dqo [dqo options...] table remove [-h] [-fw] [-hl] [-c=<connectionName>] [-of=<outputFormat>]
[-t=<fullTableName>]
DQOps shell synopsis
Command options
All parameters supported by the command are listed below.
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection Name | ||
-fw--file-write |
Write command response to a file | ||
-t--table--full-table-name |
Full table name filter in the form "schema.table", but also supporting patterns: public., .customers, landing.customer. | ||
--headless-hl |
Starts DQOps in a headless mode. When DQOps runs in a headless mode and the application cannot start because the DQOps Cloud API key is missing or the DQOps user home folder is not configured, DQOps will stop silently instead of asking the user to approve the setup of the DQOps user home folder structure and/or log into DQOps Cloud. | ||
-h--help |
Show the help for the command and parameters | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
dqo table update
Update tables that match a given condition
Description
Update the structure of one or more tables that match a given condition. It allows user to use various filters, such as table names to narrow down the set of tables to update.
Command-line synopsis
$ dqo [dqo options...] table update [-h] [-fw] [-hl] [-c=<connectionName>] [-n=<newTableName>]
[-of=<outputFormat>] [-t=<fullTableName>]
DQOps shell synopsis
dqo> table update [-h] [-fw] [-hl] [-c=<connectionName>] [-n=<newTableName>]
[-of=<outputFormat>] [-t=<fullTableName>]
Command options
All parameters supported by the command are listed below.
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection Name | ||
-fw--file-write |
Write command response to a file | ||
-t--table--full-table-name |
Full table name in the form "schema.table". | ||
--headless-hl |
Starts DQOps in a headless mode. When DQOps runs in a headless mode and the application cannot start because the DQOps Cloud API key is missing or the DQOps user home folder is not configured, DQOps will stop silently instead of asking the user to approve the setup of the DQOps user home folder structure and/or log into DQOps Cloud. | ||
-h--help |
Show the help for the command and parameters | ||
-n--newTable |
New table name | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |
dqo table list
List tables filtered by the given conditions
Description
List all the tables that match a given condition. It allows the user to use various filters, such as table name or schema names to list filtered tables.
Command-line synopsis
$ dqo [dqo options...] table list [-h] [-fw] [-hl] [-c=<connectionName>] [-of=<outputFormat>]
[-t=<tableName>] [-d=<dimensions>]... [-l=<labels>]...
DQOps shell synopsis
dqo> table list [-h] [-fw] [-hl] [-c=<connectionName>] [-of=<outputFormat>]
[-t=<tableName>] [-d=<dimensions>]... [-l=<labels>]...
Command options
All parameters supported by the command are listed below.
| Command argument | Description | Required | Accepted values |
|---|---|---|---|
-c--connection |
Connection name | ||
-d--dimension |
Dimension filter | ||
-fw--file-write |
Write command response to a file | ||
-t--table--full-table-name |
Full table name filter in the form "schema.table", but also supporting patterns: public., .customers, landing.customer. | ||
--headless-hl |
Starts DQOps in a headless mode. When DQOps runs in a headless mode and the application cannot start because the DQOps Cloud API key is missing or the DQOps user home folder is not configured, DQOps will stop silently instead of asking the user to approve the setup of the DQOps user home folder structure and/or log into DQOps Cloud. | ||
-h--help |
Show the help for the command and parameters | ||
-l--label |
Label filter | ||
-of--output-format |
Output format for tabular responses | TABLE CSV JSON |