Create Table or View Node

The Create Table or View node allows you to save the results in a table in the schema to which you are connected. For example, use a Create Table or View node to save the results of an Apply node to a table.

A Create Table or View node persists the data that flow into the node as a view or table in the database. If you create a table, the actual data is persisted; if you create a view, the SQL definition (full lineage) is persisted. Output from this node is the data provided by the view or table.

Creating a table can result in performance improvements. If you perform one or more complex transformations, such as joins and aggregations, saving the result of the transformations as a table results in faster subsequent operations. For example, you can perform an aggregation and an join, create a table that contains the results of the transformation, and then use the table as input for model build.

Therefore, you will create a table from the join node. The Classification models are built against this table.

The following topics describe Create Table or View nodes: