Input · Files

YXDB Reader

Reads an Alteryx .yxdb file, keeping its field types and its spatial objects as geometry.

Also known as: Alteryx database, YXDB

How it works

The drone converts the .yxdb to Parquet once, in a process of its own, and reads every preview and run from that copy. The copy is made again when the file changes. Both layouts Alteryx writes are read: the original engine's and the AMP engine's. Field types come from the file, so nothing is sniffed. Spatial objects become geometry in longitude and latitude, ready for the map and the spatial nodes such as Buffer. The Python export does not include this node: convert the file to Parquet with Write Parquet and read that instead.

Inputs and outputs

Settings

Nothing to set in the Attributes panel: see How it works for where this node is set up.

Example

An Alteryx workflow left you customers.yxdb. Drag it onto the canvas and a YXDB Reader appears, with every field typed as Alteryx stored it.

More in Files

• CSV Reader — Reads a CSV or other delimited text file, such as a TSV. Column types are detected for you, and you can override them or read every column as text.
• Fixed-width Reader — Reads a text file whose columns sit at fixed character positions, such as a mainframe export or a legacy feed, slicing each line at the positions you set on a ruler over the file's first lines. Header row, start line, encoding and row limit work as in the CSV Reader.
• JSON Reader — Reads a .json, .jsonl or .ndjson file as a table. A JSON array of objects and one-object-per-line files are both detected automatically.
• Parquet Reader — Reads a Parquet file and keeps the column types stored in it.
• Excel Reader — Reads one worksheet of an Excel workbook, the first sheet unless you pick another.
• Geo Reader — Reads a map file with its geometry: GeoJSON, Shapefile (also zipped), GeoPackage, GML, KML/KMZ, GPX, FlatGeobuf or MapInfo TAB. For a file with several layers, you pick which layer to read.
• XML Reader — Reads an XML file into a table. It finds the repeating record element for you, so each record becomes a row.
• SQLite Reader — Reads one table from a local SQLite database file (.sqlite, .sqlite3 or .db). You pick the table from the file's list of tables.
• Locra Table Reader — Reads a .ddtable file saved by Write Locra Table, in this project or another one. The column formats come back too, so everything prints as it did.