Get DataTable Metadata
The Get DataTable Metadata component retrieves structural information about the columns of a DataTable during workflow execution. It inspects column names, data types, constraints, and underlying schemas without reading or modifying table row data—making it essential for dynamic validation, schema mapping, and automated query building.
a. Schema Inspection: Extracts metadata across all defined columns in the target table.
b. Zero Row Overhead: Inspects table configuration directly without loading data records.
c. Dynamic Mapping: Provides JSON and tabular outputs to drive dynamic downstream component parameters.
Parameters
| Parameter | Description | Behavior |
|---|---|---|
| DataTable* | Select the target DataTable from which column metadata will be retrieved. | Queries the workflow's available DataTables via dropdown to extract schema attributes. |
| Parameter | Description |
|---|---|
| Timeout (seconds) | Maximum wait time for the download request to complete before the operation times out. Default: 30 seconds. |
| Retry count | The number of automated download attempts if the initial request fails. |
| Delay between retries (s) | Wait time between consecutive retry attempts. Default: 1 second. |
| Delay before execution (s) | Time to wait before the component starts processing. Default: 0 seconds. |
| Delay after execution (s) | Time to wait after the component finishes processing. Default: 0 seconds. |
| Continue on Error |
Determines the behavior when an unrecoverable error occurs:
Stop Workflow – Halts workflow execution. Continue – Skips this step and continues without passing the error downstream. Continue Using Error Output – Continues execution and routes error details through the error output handle. |
Output
| Output | Description |
|---|---|
| Column Metadata | Provides column details in JSON format, including column names, data types, constraints, and structural attributes. |
| DataFrame | Returns the column schema in a structured tabular format, listing each column alongside its explicit data type (e.g., string, integer, datetime). |
