Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

NOTE: When publishing to Avro, Parquet, or database tables, column names support alphanumeric characters and the underscore (_) character only. Other characters cause an error to occur.


Info

NOTE: Column names with spaces or special characters in a transformation must be wrapped by curly braces. Example:

Code Block
column1,{Column 2 with space},column3


...

When a transform is added to the recipe, an as: clause is automatically added to the transform step. You can modify your transform to change the value of the as: column.



For example, the following transform generates a new column with the first word from the Name column. The as: value renames this generated column as FirstName:

...

D s product
 enables to rename multiple columns using a single transformation. You can perform this batch renaming using one of the methods described in this section.

Info

NOTE: In macros, Rename Columns transformations do not work. This is a known issue.


Tip

Tip: To prevent potential issues with downstream systems, you should limit your column lengths to no more than 128 characters.

...