rds-load-csv¶
Help command
> csm-data api rds-load-csv --help
Usage: csm-data api rds-load-csv [OPTIONS]
Load data from a runner's RDS database into a CSV file.
Executes a SQL query against the runner's RDS database and saves the results
to a CSV file. By default, it will list all tables in the public schema if no
specific query is provided.
╭─ OPTIONS ────────────────────────────────────────────────────────────────────╮
│ * --target-folder PATH The folder where the csv will be written │
│ ENV: CSM_DATASET_ABSOLUTE_PATH │
│ [required] │
│ * --organization-id o-XXXXXXXX An organization id for the Cosmo Tech │
│ API │
│ ENV: CSM_ORGANIZATION_ID │
│ [required] │
│ * --workspace-id w-XXXXXXXX A workspace id for the Cosmo Tech API │
│ ENV: CSM_WORKSPACE_ID │
│ [required] │
│ * --runner-id r-XXXXXXXX A runner id for the Cosmo Tech API │
│ ENV: CSM_RUNNER_ID │
│ [required] │
│ * --run-id run-XXXXXX A run id for the Cosmo Tech API │
│ ENV: CSM_RUN_ID │
│ [required] │
│ * --file-name NAME A file name to write the query results │
│ DEFAULT: results │
│ [required] │
│ --query SQL_QUERY SQL query to execute (defaults to │
│ listing all tables in public schema) │
│ DEFAULT: SELECT table_name FROM │
│ information_schema.tables WHERE │
│ table_schema='public' │
│ --web-help Open the web documentation │
│ --help Show this message and exit. │
╰──────────────────────────────────────────────────────────────────────────────╯