Skip to main content
Skip table of contents

MATERIALIZED_VIEW

The MATERIALIZED_VIEW entity type is for creating and managing materialized views in the target database.


See also:


Notes

Refer to target database specific documentation regarding its capabilities with materialized views.


Snowflake

  • STORAGE.SECURE_VIEW is supported.

  • Clustering is supported, see SORT_KEY.

  • Functions are required to be deterministic.

  • Aggregation and GROUP BY are allowed.

  • Window functions are not allowed.

See full reference in Snowflake documentation.


Redshift

See full reference in Amazon Redshift documentation.


Azure SQL Database

  • Materialized view is an indexed view in Azure SQL Database. It requires a unique clustered index to be defined, see SORT_KEY.

  • Attribute definition is required.

  • Functions are required to be deterministic.

  • Aggregation and GROUP BY are allowed.

  • Window functions are not allowed.

  • Secondary indexing is supported, see SECONDARY_INDEX.

See full reference in Microsoft documentation.


Azure Synapse SQL

  • Attribute definition is required.

  • Distribution is supported, see DISTRIBUTION_KEY.

  • Functions are required to be deterministic.

  • Either aggregation or GROUP BY (or both) are required.

  • Window functions are allowed, yet limited.

See full reference in Microsoft documentation.


Google BigQuery

  • Partitioning is supported, see DISTRIBUTION_KEY

  • Functions are required to be deterministic.

  • Aggregation and GROUP BY are allowed and recommended.

  • Window functions are not allowed.

  • Materialized view is automatically refreshed, the option for disabling the automatic refresh is not supported in Agile Data Engine.

See full reference in BigQuery documentation.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.