Alteryx Designer Cloud Core key terms

A workflow tool that brings external data into Designer Cloud by connecting to a file, database, or cloud source and defining how records and fields are read.

A workflow tool that writes processed records to a destination such as a file, database table, or cloud warehouse, with options for file format and overwrite behavior.

A configured link between Designer Cloud and a specific external system, holding authentication and location details so workflows can read or write data without re-entering credentials.

The structure used to store data on disk or in object storage, such as CSV, JSON, Parquet, or Excel, which affects how fields and types are interpreted on read.

The character or sequence that separates individual fields within a flat text file, such as a comma or tab, which must be identified correctly for columns to parse.

The defined set of fields, data types, and ordering that describes a dataset, used to validate incoming records and keep downstream tools consistent.

The classification of a field's values, such as string, integer, decimal, date, or boolean, which determines valid operations and how values are stored.

The process of changing a field from one data type to another, for example converting text digits into numeric values so arithmetic can be performed.

The automated inspection of a dataset to reveal field types, value distributions, missing values, and anomalies before building transformations.

The degree to which data is complete, accurate, consistent, and fit for its intended use, often assessed through profiling and cleansing steps.

The set of preparation steps that correct or standardize values, such as trimming whitespace, fixing casing, replacing blanks, and removing duplicate records.

The rules applied to missing or empty values, including whether to keep, replace, or exclude them, so calculations and joins behave predictably.

A transformation tool that splits records into true and false streams based on a condition expression, allowing unwanted rows to be routed away.

A tool used to choose which fields pass downstream, rename them, change their data types, and reorder columns in the output.

A transformation tool that combines records from two inputs based on matching key fields, producing matched records plus unmatched records from each side.

The matching rule for combining datasets, such as inner, left, right, or full outer, which determines which unmatched records are retained.

A transformation tool that stacks records from multiple inputs into a single stream, aligning fields by position or by name.

A transformation that adds fields from one input alongside every record of another input without matching keys, effectively widening each row.

An aggregation tool that groups records and computes metrics such as count, sum, average, minimum, or maximum for each group.

A setting that partitions records into buckets sharing identical key values so aggregate calculations are computed per bucket rather than across the whole dataset.

The process of reducing many records into summary values, such as totals or averages, using grouping keys and chosen statistical operations.

A formula written in the platform's expression language that references fields and functions to compute new values or evaluate conditions within tools.

A tool that creates or updates fields by evaluating expressions, allowing calculated columns and conditional logic to be added to the data stream.

An ordered set of connected tools and data streams that together perform a repeatable data preparation and analysis process from input to output.

The settings applied to an individual workflow tool, including field selections, expressions, and options that control its behavior during a run.

A record of past workflow executions showing when runs occurred, whether they succeeded, and diagnostic messages useful for auditing and debugging.

Diagnostic text produced when a tool or run fails, identifying the affected tool and describing the cause so the problem can be corrected.

The practice of isolating and fixing workflow failures by inspecting messages, previewing intermediate results, and testing tools individually.

Techniques for making workflows run faster and use fewer resources, such as filtering early, limiting fields, and pushing work to the source system.

A performance technique where filtering, selection, or aggregation is executed by the source database instead of the workflow engine, reducing data transferred.

Stored authentication details, such as a username and secret or token, that authorize a workflow to access a connected data source securely.

A granted right that determines what a user or group may view, edit, run, or share within the cloud platform, such as workspace or dataset access.

A named set of permissions assigned to users, such as viewer, editor, or administrator, that controls their capabilities across the platform.

A collaborative container in the cloud platform where workflows, datasets, and connections are organized and shared among a defined group of users.

The platform capability that runs a saved workflow automatically at set times or intervals, removing the need for manual execution.

The documented path showing where data originated, how it was transformed across workflows, and where it ultimately flows, supporting audit and trust.

Reading a representative subset of records rather than the full dataset, useful for fast exploration, profiling, and iterative workflow development.

A transformation tool that orders records by one or more fields ascending or descending, often required before position-based operations.