Read Connector

After creating an Amazon S3 connection, set up a Read Connector in your dataflow.

Create a new Read Connector

To get started, select Read Connector from the Ingest tab.

775

FIgure 1.

Step 1: Select your connection.

Find your newly created connection and select USE.

1162

Figure 2.

Step 2: Select the data to ingest.

If you know the path of the data you want to ingest, select "SKIP and configure manually."

1246

Step 3: Provide the required Connector information.

FieldRequiredDescription
BUCKETRequiredName of the S3 bucket.
OBJECT PATTERN MATCHINGRequiredThe pattern strategy used to identify eligible files:
- Glob: Glob applies a simple pattern matching algorithm.
- Match: Matches the pattern precisely character-for-character.
- Prefix: Matches the pattern with the specified prefix.
- Regex: Regex applies a pattern matching algorithm.
OBJECT PATTERNRequiredThe specific pattern parameters used to identify eligible files.

Example: find all the files with Prefix Flights_.
PARSERRequiredWe support several data formats. See Amazon S3 Read Connector Parsers](https://developer.ascend.io/docs/amazon-s3-read-parser) for more information about CSV, Excel, JSON, and Python parsers:
- Avro
- CSV
- Excel
- JSON
- ORC
- Parquet
- Python
- Text
PATH DELIMITEROptionalExample: A newline(\n) de-limited file
OBJECT AGGREGATION STRATEGYRequiredCurrently available strategies are:
- Adaptive
- Leaf Directory
- Prefix Regex Match

Schema

Once you click on the GENERATE SCHEMA button, the parser will create a schema and a data preview will be populated as in the Figure 5 below.

Add Custom Schema: After schema is generated, you can add custom columns. To insert a column, select Add schema column. To edit the custom schema, right click anywhere in the row and select either Insert row above, Insert Row below, or Remove row.

1268

Figure 3.

Refresh Schedule

The refresh schedule specifies how often Ascend checks the data location to see if there's new data. Ascend will automatically kick off the corresponding read jobs once new or updated data is discovered.

718

Component Pausing

Update the status of the read connector by selecting either Running to mark it active or Paused to stop the connector from running.

785

Figure 4.

Advanced Settings

Processing Priority: When resources are constrained, this value will be used to determine which components to schedule first. Higher priority numbers are scheduled before lower ones. Increasing the priority on a component also causes all its upstream components to be prioritized higher. Negative priorities can be used to postpone work until excess capacity becomes available. Please note that once a job is running, it completes processing and isn't impacted by a higher priority item coming into the queue.

Custom Spark Params: You can determine the resources such as driver size, number of executors, and the executor size. If you leave this set to Dynamic (default), Ascend will inspect the input files and automatically estimate the appropriate cluster size.

651

Final Step: Select create.

After providing the required Connector information and adjusting any additional settings, select create from the top right-hand corner.

915