Build SQL Transforms

SQL Transforms are perfect for set-based operations, aggregations, filtering, and joins. They leverage the power of SQL to process relational data efficiently within your Data Plane. SQL transforms are ideal when you need to perform standard data transformations using familiar SQL syntax.

Before you begin

• Ensure you have an Ascend Project and Workspace
• Have Read Components or other data sources ready as inputs
• Basic SQL knowledge

Table of Contents (ToC)

• Simple SQL Transform
• Incremental SQL Transform
• Smart SQL Transform
• Macros