Breadcrumbs

Workflows Helper - Browse CSV

Overview

How to use the Browse CSV Helper

1. Provide inputs:

–filepath (optional, defaults to current directory) –filename (required, must be .csv) -rows (required, number of rows to preview from the table)

2. Run example:

python browsecsv.py --filepath ./data --file_name customers.csv --rows 2

3. Run example:

Name | Age | City | Occupation34235678594264256748e ------+-----------+----------+-------------------------------- Alice | 334567890 | New York | Engineer
Bob | 25 | London | Designer

Variables

Name

Reference

Type

Required

Default

Options

Description

Workflows Folder Name

SOURCE_FILE_PATH

Alphanumeric

-

-

Name of the local folder on Workflows the target file is expected to be. If left blank, will look in the home directory.

Workflows File Name

FILE

Alphanumeric

-

-

Name of file to preview. Should be `.csv` extension.

Number of Rows

NUM_ROWS

Integer

5

-

Number of rows to display to the logs from the workflows file.

YAML

Below is the YAML template

YAML

source:
  template: Workflows Helper - Browse CSV
  inputs:
    SOURCE_FILE_PATH:
    FILE:
    NUM_ROWS: '5'
  type: TEMPLATE
guardrails:
  retry_count: 1
  retry_wait: 0h0m0s
  runtime_cutoff: 1h0m0s
  exclude_exit_code_ranges:
    - 101
    - 102
    - 103
    - 104
    - 105
    - 106
    - 199