dbcat

Usage:

$ dbcat [OPTIONS] COMMAND [ARGS]...

Options:

• --log-level TEXT: Logging Level [default: WARNING]
• --output-format [tabular|json]: [default: tabular]
• --catalog-path PATH: Path to store catalog state. Use if NOT using a database
• --catalog-host TEXT: hostname of Postgres database. Use if catalog is a database.
• --catalog-port INTEGER: port of Postgres database. Use if catalog is a database.
• --catalog-user TEXT: user of Postgres database. Use if catalog is a database.
• --catalog-password TEXT: password of Postgres database. Use if catalog is a database.
• --catalog-database TEXT: database of Postgres database. Use if catalog is a database.
• --catalog-secret TEXT: Secret to encrypt sensitive data like passwords in the catalog. [default: TOKERN_CATALOG_SECRET]
• --version
• --install-completion: Install completion for the current shell.
• --show-completion: Show completion for the current shell, to copy it or customize the installation.
• --help: Show this message and exit.

Commands:

• catalog

dbcat catalog

Usage:

$ dbcat catalog [OPTIONS] COMMAND [ARGS]...

Options:

• --help: Show this message and exit.

Commands:

• add-athena
• add-mysql
• add-postgresql
• add-redshift
• add-snowflake
• add-sqlite
• scan

dbcat catalog add-athena

Usage:

$ dbcat catalog add-athena [OPTIONS]

Options:

• --name TEXT: A memorable name for the database [required]
• --aws-access-key-id TEXT: AWS Access Key [required]
• --aws-secret-access-key TEXT: AWS Secret Key [required]
• --region-name TEXT: AWS Region Name [required]
• --s3-staging-dir TEXT: S3 Staging Dir [required]
• --aws-session-token TEXT: AWS Session Token
• --mfa TEXT: MFA
• --help: Show this message and exit.

dbcat catalog add-mysql

Usage:

$ dbcat catalog add-mysql [OPTIONS]

Options:

• --name TEXT: A memorable name for the database [required]
• --username TEXT: Username or role to connect database [required]
• --password TEXT: Password of username or role [required]
• --database TEXT: Database name [required]
• --uri TEXT: Hostname or URI of the database [required]
• --port INTEGER: Port number of the database
• --help: Show this message and exit.

dbcat catalog add-postgresql

Usage:

$ dbcat catalog add-postgresql [OPTIONS]

Options:

• --name TEXT: A memorable name for the database [required]
• --username TEXT: Username or role to connect database [required]
• --password TEXT: Password of username or role [required]
• --database TEXT: Database name [required]
• --uri TEXT: Hostname or URI of the database [required]
• --port INTEGER: Port number of the database
• --help: Show this message and exit.

dbcat catalog add-redshift

Usage:

$ dbcat catalog add-redshift [OPTIONS]

Options:

• --name TEXT: A memorable name for the database [required]
• --username TEXT: Username or role to connect database [required]
• --password TEXT: Password of username or role [required]
• --database TEXT: Database name [required]
• --uri TEXT: Hostname or URI of the database [required]
• --port INTEGER: Port number of the database
• --help: Show this message and exit.

dbcat catalog add-snowflake

Usage:

$ dbcat catalog add-snowflake [OPTIONS]

Options:

• --name TEXT: A memorable name for the database [required]
• --username TEXT: Username or role to connect database [required]
• --password TEXT: Password of username or role [required]
• --database TEXT: Database name [required]
• --account TEXT: Snowflake Account Name [required]
• --warehouse TEXT: Snowflake Warehouse Name [required]
• --role TEXT: Snowflake Role Name [required]
• --help: Show this message and exit.

dbcat catalog add-sqlite

Usage:

$ dbcat catalog add-sqlite [OPTIONS]

Options:

• --name TEXT: A memorable name for the database [required]
• --path PATH: File path to SQLite database [required]
• --help: Show this message and exit.

dbcat catalog scan

Usage:

$ dbcat catalog scan [OPTIONS]

Options:

• --source-name TEXT: List of names of database and data warehouses

• --include-schema TEXT: Scan only schemas matching schema; When this option is not specified, all non-system schemas in the target database will be dumped. Multiple schemas can be selected by writing multiple --include switches. Also, the schema parameter is interpreted as a regular expression, so multiple schemas can also be selected by writing wildcard characters in the pattern. When using wildcards, be careful to quote the pattern if needed to prevent the shell from expanding the wildcards;

• --exclude-schema TEXT: Do not scan any schemas matching the schema pattern. The pattern is interpreted according to the same rules as for --include. --exclude can be given more than once to exclude schemas matching any of several patterns.

When both --include and ---exclude are given, the behavior is to dump just the schemas that match at least one --include switch but no --exclude switches. If --exclude appears without --include, then schemas matching --exclude are excluded from what is otherwise a normal scan.")

• --include-table TEXT: Scan only tables matching table. Multiple tables can be selected by writing multiple switches. Also, the table parameter is interpreted as a regular expression, so multiple tables can also be selected by writing wildcard characters in the pattern. When using wildcards, be careful to quote the pattern if needed to prevent the shell from expanding the wildcards.

• --exclude-table TEXT: Do not scan any tables matching the table pattern. The pattern is interpreted according to the same rules as for --include. --exclude can be given more than once to exclude tables matching any of several patterns.

When both switches are given, the behavior is to dump just the tables that match at least one --include switch but no --exclude switches. If --exclude appears without --include, then tables matching --exclude are excluded from what is otherwise a normal scan.

• --help: Show this message and exit.