PROJECTIONS

Note

This is a Preview feature.

This view contains information about projections.

Column Name	Description
`PROJECTION_SCHEMA`	The database that the projection belongs to.
`PROJECTION_NAME`	The name of the projection.
`BASE_TABLE_NAME`	The name of the base table from which the projection was created.
`CREATE_TIME`	Timestamp when the projection was created.
`CREATE_USER`	The user that created the projection.
`STATUS`	The status of the projection. Sync - the projection is currently valid for its schema. Invalid - the projection is invalid (due to dropping or changes to the table, etc.)

Was this article helpful?