App Public Views

Before querying views

• Grant and use the ENTRYLAYER_ADMIN application role.
• Replace ENTRYLAYER with your installed app name if it is different.
• Views expose app metadata for admin inspection; they do not expose source rows or submission payloads unless explicitly stated.

These views are the read-only companion to the SQL API procedures. Use them for inspection, discovery, and support workflows when a table-shaped result is easier than a procedure response.

View index

View	Purpose
APP_PUBLIC.API_REFERENCE	Catalog of documented SQL API commands, signatures, examples, and required role.
APP_PUBLIC.PROJECTS	Active project metadata for admin inspection.
APP_PUBLIC.FORM_VERSIONS	Published and draft form version metadata.
APP_PUBLIC.PROJECT_ACCESS	Active EntryLayer project access grants.
APP_PUBLIC.PROJECT_ACCESS_LOG	Project-scoped access/audit events without submission payloads.
APP_PUBLIC.PROJECT_CHANGELOG	Project configuration changes such as form design and access metadata changes.
APP_PUBLIC.WORKFLOW_STATES	Workflow state definitions by project.
APP_PUBLIC.RELATIONSHIPS	Parent/child project relationship metadata.
APP_PUBLIC.FOLDERS	Project folder metadata.
APP_PUBLIC.SOURCE_CONFIGS	Source configuration metadata, including source object and sync status fields.

APP_PUBLIC.API_REFERENCE

Catalog of documented SQL API commands, signatures, examples, and required role.

Required role: ENTRYLAYER_ADMIN

Zero-access note: This view is granted only to admins and returns EntryLayer app metadata, not source row samples or provider-owned telemetry.

Example:

SELECT *
FROM ENTRYLAYER.APP_PUBLIC.API_REFERENCE
LIMIT 50;

Columns:

Column	Description
command_name	Documented command or function name.
schema_name	Public schema that owns the SQL object.
signature	SQL signature.
description	Human-readable description.
example	Example SQL statement.
required_role	Application role required to use the object.

APP_PUBLIC.PROJECTS

Admin project listing. This view is unfiltered because the app uses a single-org model and is granted only to entrylayer_admin. If multi-org support is added, add a WHERE clause filtering by the caller’s org.

Required role: ENTRYLAYER_ADMIN

Zero-access note: This view is granted only to admins and returns EntryLayer app metadata, not source row samples or provider-owned telemetry.

Example:

SELECT *
FROM ENTRYLAYER.APP_PUBLIC.PROJECTS
LIMIT 50;

Columns:

Column	Description
project_id	EntryLayer project identifier in proj_<id> form.
name	Display name.
source_object	Fully qualified Snowflake source object name when configured.
source_type	Source object type, such as table, view, or semantic_view.
status	Current status value for this object.
folder_id	Folder identifier assigned to the project, when present.
created_at	Timestamp when the row was created.
updated_at	Timestamp when the row was last updated.
owner_account_id	EntryLayer account id for the project creator/owner.

APP_PUBLIC.FORM_VERSIONS

Published and draft form version metadata.

Required role: ENTRYLAYER_ADMIN

Zero-access note: This view is granted only to admins and returns EntryLayer app metadata, not source row samples or provider-owned telemetry.

Example:

SELECT *
FROM ENTRYLAYER.APP_PUBLIC.FORM_VERSIONS
LIMIT 50;

Columns:

Column	Description
version_id	Form version identifier.
project_id	EntryLayer project identifier in proj_<id> form.
version_number	Sequential version number for the project.
status	Current status value for this object.
archived	Whether the object is archived.
parent_version_id	Previous version used as the parent, when available.
published_at	Timestamp when the version became user-facing.
created_at	Timestamp when the row was created.
updated_at	Timestamp when the row was last updated.

APP_PUBLIC.PROJECT_ACCESS

Active EntryLayer project access grants.

Required role: ENTRYLAYER_ADMIN

Zero-access note: This view is granted only to admins and returns EntryLayer app metadata, not source row samples or provider-owned telemetry.

Example:

SELECT *
FROM ENTRYLAYER.APP_PUBLIC.PROJECT_ACCESS
LIMIT 50;

Columns:

Column	Description
grant_id	Project access grant identifier.
project_id	EntryLayer project identifier in proj_<id> form.
subject_type	Grant subject type, such as role.
subject_key	Normalized access subject identifier.
role_name	Snowflake role name for role-based grants.
account_id	EntryLayer account id for direct account grants.
can_read	Whether the grant allows reading own project submissions.
can_submit	Whether the grant allows creating submissions.
can_edit	Whether the grant allows editing own submissions.
can_delete	Whether the grant allows deleting own submissions.
can_manage	Whether the grant allows managing project access and settings.
created_at	Timestamp when the row was created.
updated_at	Timestamp when the row was last updated.

APP_PUBLIC.PROJECT_ACCESS_LOG

Project-scoped access/audit events without submission payloads.

Required role: ENTRYLAYER_ADMIN

Zero-access note: This view is granted only to admins and returns EntryLayer app metadata, not source row samples or provider-owned telemetry.

Example:

SELECT *
FROM ENTRYLAYER.APP_PUBLIC.PROJECT_ACCESS_LOG
LIMIT 50;

Columns:

Column	Description
log_id	Access log identifier.
project_id	EntryLayer project identifier in proj_<id> form.
submission_id	Submission id when the event is tied to a submission.
account_id	EntryLayer account id for the actor.
action	Access event action.
details	Structured event metadata; no submission payloads.
created_at	Timestamp when the row was created.

APP_PUBLIC.PROJECT_CHANGELOG

Project configuration changes such as form design and access metadata changes.

Required role: ENTRYLAYER_ADMIN

Zero-access note: This view is granted only to admins and returns EntryLayer app metadata, not source row samples or provider-owned telemetry.

Example:

SELECT *
FROM ENTRYLAYER.APP_PUBLIC.PROJECT_CHANGELOG
LIMIT 50;

Columns:

Column	Description
change_id	Project changelog identifier.
project_id	EntryLayer project identifier in proj_<id> form.
action	Configuration change action.
entity_type	Changed object type.
entity_name	Changed object display name or identifier.
old_value	Previous metadata value.
new_value	New metadata value.
changed_by	EntryLayer account id for the actor.
created_at	Timestamp when the row was created.

APP_PUBLIC.WORKFLOW_STATES

Workflow state definitions by project.

Required role: ENTRYLAYER_ADMIN

Zero-access note: This view is granted only to admins and returns EntryLayer app metadata, not source row samples or provider-owned telemetry.

Example:

SELECT *
FROM ENTRYLAYER.APP_PUBLIC.WORKFLOW_STATES
LIMIT 50;

Columns:

Column	Description
state_id	Workflow state identifier.
project_id	EntryLayer project identifier in proj_<id> form.
label	User-facing state label.
category	Workflow category such as editable, in_review, approved, or rejected.
order_in_category	Sort order within the category.
color	State color token used by the UI.
is_exit_point	Whether this state can behave as a terminal/exit state.
exit_target_state_ids	State ids reachable as exit targets.
back_edge_target_state_ids	State ids reachable by send-back transitions.
archived	Whether the object is archived.
created_at	Timestamp when the row was created.
updated_at	Timestamp when the row was last updated.

APP_PUBLIC.RELATIONSHIPS

Parent/child project relationship metadata.

Required role: ENTRYLAYER_ADMIN

Zero-access note: This view is granted only to admins and returns EntryLayer app metadata, not source row samples or provider-owned telemetry.

Example:

SELECT *
FROM ENTRYLAYER.APP_PUBLIC.RELATIONSHIPS
LIMIT 50;

Columns:

Column	Description
relationship_id	Relationship identifier.
parent_project_id	Parent project id.
child_project_id	Child project id.
parent_field_id	Parent field id used for matching.
child_field_id	Child field id used for matching.
label	Relationship label shown in the UI.
sort_order	Display order for relationships.
archived	Whether the object is archived.
created_at	Timestamp when the row was created.
updated_at	Timestamp when the row was last updated.

APP_PUBLIC.FOLDERS

Project folder metadata.

Required role: ENTRYLAYER_ADMIN

Zero-access note: This view is granted only to admins and returns EntryLayer app metadata, not source row samples or provider-owned telemetry.

Example:

SELECT *
FROM ENTRYLAYER.APP_PUBLIC.FOLDERS
LIMIT 50;

Columns:

Column	Description
folder_id	Folder identifier assigned to the project, when present.
org_id	Metadata column exposed for admin inspection.
name	Display name.
created_at	Timestamp when the row was created.
updated_at	Timestamp when the row was last updated.

APP_PUBLIC.SOURCE_CONFIGS

Source configuration metadata, including source object and sync status fields.

Required role: ENTRYLAYER_ADMIN

Zero-access note: This view is granted only to admins and returns EntryLayer app metadata, not source row samples or provider-owned telemetry.

Example:

SELECT *
FROM ENTRYLAYER.APP_PUBLIC.SOURCE_CONFIGS
LIMIT 50;

Columns:

Column	Description
sync_config_id	Source configuration identifier.
project_id	EntryLayer project identifier in proj_<id> form.
connection_id	Internal Snowflake connection/source connection id.
direction	Sync direction, usually import for source-backed projects.
source_object	Fully qualified Snowflake source object name when configured.
source_type	Source object type, such as table, view, or semantic_view.
enabled	Whether the source configuration is enabled.
last_sync_at	Timestamp for the most recent source sync attempt.
last_sync_status	Status of the most recent source sync attempt.
last_sync_message	Message from the most recent source sync attempt.
created_at	Timestamp when the row was created.
updated_at	Timestamp when the row was last updated.

Related docs

• SQL Procedures
• SQL API Contracts
• Permission Model