Export a table or a query result to a file system
Tool. Runs: dorieh.platform.util.pg_export
Description
This tool builds all indices for the specified table. Log file displays real-time progress of building indices
Inputs
Name |
Type |
Default |
Description |
---|---|---|---|
table |
string? |
the name of the table |
|
sql |
string? |
SQL query |
|
partition |
string[]? |
List of columns to be used for partitioning |
|
output |
string |
the name of the newly created file or directory |
|
format |
string |
Format of the export, one of jsonl, parquet, csv, hdf5 |
|
database |
File |
Path to database connection file, usually database.ini |
|
connection_name |
string |
The name of the section in the database.ini file |
|
depends_on |
Any? |
a special field used to enforce dependencies and execution order |
Outputs
Name |
Type |
Description |
---|---|---|
data |
[‘File’, ‘Directory’] |
|
log |
File |
|
errors |
stderr |