¶ Description
Read .yxdb Alteryx file
¶ Parameters
Parameters:
- Input file
- Extract "Int16" types as "Key"
- Extract "Int32" types as "Key"
- Extract "Int64" types as "Key"
- Process blob types
- Char encoding
¶ About
The ReadAlteryx action imports data from Alteryx .yxdb files (Alteryx Database format) into your ETL pipeline.
This is particularly useful for integrating datasets created with Alteryx workflows into your ETL processes for further analysis, transformation, or exporting.
¶ Key Features:
- Read
.yxdbAlteryx data files. - Extract integer columns (
Int16,Int32,Int64) as key columns for further processing. - Handle BLOB (binary) fields if required.
- Select character encoding for text data.
¶ Example Use Case
You have a .yxdb file containing product inventory data. You need to import this file into your ETL pipeline for analysis and further data processing.
¶ Example:
¶ Pipeline Configuration Steps
- Add the ReadAlteryx action to your pipeline.
- Select the .yxdb file using the Input file field.
- Optionally enable key extraction for Int16, Int32, and/or Int64 columns if they are used for joins or indexing.
- Enable Process blob types if binary data columns need to be imported.
- Choose the appropriate Char encoding for text fields (utf-8 or Latin1).
- Connect this action to the next step in the pipeline.
Notes
UTF-8 is the default and recommended encoding for most cases.
Enabling key extraction simplifies downstream joins, lookups, and deduplication tasks.
Processing BLOB fields may require additional memory and may slow down processing depending on the size of binary data.
