Special functions

cluster()

Learn how to use the cluster() function to change the reference of the query to a remote cluster or Eventhouse.

Cross-cluster and cross-database queries

This article describes cross-database and cross-cluster queries.

database()

Learn how to use the database() function to change the reference of the query to a specific database.

external_table()

Learn how to use the external_table() function to reference an external table by name.

materialize()

Learn how to use the materialize() function to capture the value of a tabular expression for reuse.

materialized_view()

Learn how to use the materialized_view() function to reference the materialized part of a materialized view.

Query results cache

Learn how to use the query results cache functionality to get cached results.

stored_query_result()

Learn how to use the stored_query_result() function to reference a stored query result.

table()

Learn how to use the table() function to reference a table.

toscalar()

Learn how to use the toscalar() function to return a scalar constant value of the evaluated expression.