Skip to content

Create View

Generates a permanent, named view, containing the SQL generated by all the input tables up to the Create View component.

The Create View component enables you to output a view definition to your cloud data warehouse. In some circumstances, this action may be preferable to writing the data to a physical table.

If a view of the same name already exists, it will be replaced when this component runs.

If a table of the same name already exists, this component will fail its run; the Create View component cannot replace an existing table, only an existing view.

Views created by this component will not be dropped when the Transformation pipeline is revalidated. However, the views will be recreated at runtime (when the Transformation pipeline is executed).


Properties

Name = string

A human-readable name for the component.


Database = drop-down

The Snowflake database that the newly created view will belong to. The special value, [Environment Default], will use the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.


Schema = drop-down

The Snowflake schema that the newly created view will belong to. The special value, [Environment Default], will use the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.


View Name = string

The name of the view to be created.


Secure View = boolean

When Yes, the view definition and details are only visible to authorized users, i.e. users who are granted the role that owns the view. Default is No. Snowflake advises that views should be defined as secure when they are specifically designated for data privacy. For more information about secure views, please read the Snowflake documentation.


View Type = drop-down

Select the view type:

  • Materialized: A materialized view is a pre-computed data set derived from a query specification and stored for later use. Since the data is pre-computed, querying a materialized view is faster than executing the original query. Materialized views are advised when:

    • Query results contain a small number of rows and/or columns relative to the base table.
    • Query results contain results that require significant processing.
  • Standard: (default setting) Create standard views when:

    • The results of the view change often.
    • The results are not used often (relative to the rate at which the results change).
    • The query is not resource intensive, so it is not costly to re-run it.

Name = string

A human-readable name for the component.


Catalog = drop-down

Select a Databricks Unity Catalog. The special value, [Environment Default], will use the catalog specified in the Data Productivity Cloud environment setup. Selecting a catalog will determine which databases are available in the next parameter.


Schema (Database) = drop-down

The Databricks schema. The special value, [Environment Default], will use the schema defined in the environment. Read Create and manage schemas to learn more.


View Name = string

The name of the view to be created.


Table Properties = column editor

  • Key: A metadata property within the table. These are expressed as key=value pairs.
  • Value: The value of the corresponding row's key.

Comment = string

A descriptive comment for the view.

Name = string

A human-readable name for the component.


Schema = drop-down

Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, read Schemas.


View Name = string

The name of the view to be created.


Late Binding = boolean

Select Yes to create a late-binding view. Late-binding views do not check underlying database objects, such as tables and other views, until the view is queried. As a result, users can alter or drop the underlying objects without dropping and recreating the view. A query to a late-binding view will fail if the user drops underlying objects, or if the query references columns in the underlying object that aren't present.

The default setting is No.


View Type = drop-down

Select Standard or Materialized.

A materialized view is a pre-computed data set derived from a query specification and stored for later use. Since the data is pre-computed, querying a materialized view is faster than executing the original query. Materialized views are advised when:

  • Query results contain a small number of rows and/or columns relative to the base table.
  • Query results contain results that require significant processing.

For more information, read CREATE MATERIALIZED VIEW.

The default setting is Standard. Create a standard view when:

  • The results of the view change often.
  • The results are not used often (relative to the rate at which the results change).
  • The query is not resource intensive, so it is not costly to re-run it.

For more information, read CREATE VIEW.


Snowflake Databricks Amazon Redshift (preview)