A root command that allows the user to access all the features and functionalities of the application from the command-line interface (CLI) level. It is the first command to be used before accessing any other commands of the application.
Clear the terminal screen or console, removing all the previous commands and outputs of the commands that were executed on the console. It allows the user to start with a clean slate for the next set of commands or outputs.
Lists all the created connections for the logged-in user that match the conditions specified in the options. It allows the user to filter connections based on various parameters.
Creates a new connection to the database with the specified details such as connection name, database type, hostname, username, and password. It allows the user to connect to the database from the application to perform various operations on the database.
Removes the connection or connections that match the conditions specified in the options. It allows the user to remove any unwanted connections that are no longer needed.
Update the connection or connections that match the conditions specified in the options with new details. It allows the user to modify existing connections in the application.
Show the details of the specified table in the database for the specified connection. It allows the user to view the details of a specific table in the database.
Edit the connection or connections that match the filter conditions specified in the options. It allows the user to modify the details of an existing connection in the application.
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.
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.
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.
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.
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.
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.
Run data quality checks on your dataset that match a given condition. The command output is a table with the results that provides insight into the data quality.
Disable one or more columns in a table based on a specified condition. Disabling a column will prevent it from being queried or updated until it is enabled again.
Displays the default time zone that is currently set in your settings. This time zone will be used to display all date and time values in the application.
This operation should be called only from the shell mode. When the DQO is started as 'dqo scheduler start' from the operating system, it will stop immediately.
Deletes stored data that matches specified conditions. Be careful when using this command, as it permanently deletes the selected data and cannot be undone.
Verify integrity of parquet files used to store data and removes corrupted files. Be careful when using this command, as it permanently deletes the selected data and cannot be undone.
This command is useful when you want to continuously monitor the quality of your data in real-time. The job scheduler runs in the background, allowing you to perform other tasks while the DQO is running.
This command can be used to update the rule. It is important to use caution when using this command, as it can impact the execution of data quality checks.