Column Naming Requirements
These requirements should be followed for column names in your datasets used in the Alteryx Analytics Cloud.
Note
Sometimes, names that violate these requirements may be accepted by an individual application. However, these column names may be rejected by the underlying platform or running environment where the job is executed. For best results, you should follow these naming conventions.
Column names are case-insensitive and cannot begin with whitespace.
Column names can't start with a number.
Column names cannot contain escaped characters, such as
\n.
Note
When publishing to Avro, Parquet, or database tables, column names only support alphanumeric characters and the underscore (_) character. Column names cannot begin with a numeral. Other characters cause an error to occur.
Note
Column names with spaces or special characters in a transformation must be wrapped by curly braces. Example:
column1,{Column 2 with space},column3Tip
To prevent potential issues with downstream systems, you should limit your column lengths to no more than 128 characters.