SHOW PROJECTIONS

Note

This is a Preview feature.

Shows projections created on the current database or specified table.

Syntax

SHOW PROJECTIONS [ON TABLE <table_name>];

Arguments

table_name

The name of the table the projection is created on.

Remarks

  • The SHOW PROJECTIONS command only lists projections created on the currently selected database.

  • SHOW PROJECTIONS ON TABLE <table_name> command shows all projections created on a specific table.

  • The SHOW CREATE PROJECTION command shows the CREATE PROJECTION statement that was used to create the table.

  • The information_schema.PROJECTIONS view provides more details about all projections created in a cluster .

Examples

The output of the SHOW PROJECTIONS command shows all projections created on the currently selected database.

SHOW PROJECTIONS;
+----------+--------------------------------------+
| Table    | Projections                          |
+----------+--------------------------------------+
| lineitem | lineitem_sort_shipdate               |
| lineitem | lineitem_shard_sort_shipdate         |
| orders   | orders_shard_orderkey_sort_orderdate |
+----------+--------------------------------------+

The output of SHOW PROJECTIONS ON TABLE <table_name> shows all projections created on a specific table.

SHOW PROJECTIONS ON TABLE lineitem;
+-------------------------------+
| Projections_in_lineitem       |
+-------------------------------+
| lineitem_sort_shipdate        |
| lineitem_shard_sort_shipdate  |
+-------------------------------+

Last modified: April 1, 2024

Was this article helpful?