secrets

Description

Exposes metadata about secrets in the organization. Secret values are never exposed — only the name, type, and status are visible. Only secrets on which the current role has USAGE privileges are returned.

Note Secret values are never returned by this table. Only metadata (name, type, status) is accessible.

Syntax

SELECT * FROM deltastream.sys."secrets";

Columns

Column	Type	Nullable	Description
name	VARCHAR	No	Name of the secret.
type	VARCHAR	No	Type of the secret, e.g. generic.
status	VARCHAR	No	Current status of the secret. One of ready, error.
description	VARCHAR	Yes	Optional description of the secret.
owner	VARCHAR	No	The role that owns this resource.
created_by_role	VARCHAR	No	The role that created this resource.
created_by_role_deleted	BOOLEAN	No	Whether the creating role has since been deleted.
created_by	VARCHAR	No	The user that created this resource.
created_at	TIMESTAMP_LTZ	No	Timestamp when this resource was created.
updated_by_role	VARCHAR	Yes	The role that last updated this resource.
updated_by_role_deleted	BOOLEAN	Yes	Whether the last updating role has since been deleted.
updated_by	VARCHAR	Yes	The user that last updated this resource.
updated_at	TIMESTAMP_LTZ	No	Timestamp when this resource was last updated.
organization_id	VARCHAR	No	The unique identifier of the organization this resource belongs to.

Examples

$ dsql -e 'SELECT * FROM deltastream.sys."secrets";'
[]

See Also

• System Tables Overview

• LIST SECRETS

• CREATE SECRET