databases

Description

Exposes metadata about databases in the organization. Only databases on which the current role has USAGE privileges are returned.

Syntax

SELECT ... FROM deltastream.sys."databases";

Columns

Column	Type	Nullable	Description
name	VARCHAR	No	Name of the database.
default_schema	VARCHAR	Yes	The default schema for the database.
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	No	The role that last updated this resource.
updated_by_role_deleted	BOOLEAN	No	Whether the last updating role has since been deleted.
updated_by	VARCHAR	No	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

SELECT * FROM deltastream.sys."databases";

[{"name":"mydb","default_schema":"public","owner":"sysadmin","created_by_role":"orgadmin","created_by_role_deleted":false,"created_by":"[e-mail]","created_at":"2025-05-23T20:49:02.361Z","updated_by_role":"orgadmin","updated_by_role_deleted":false,"updated_by":"[e-mail]","updated_at":"2025-05-23T20:49:02.361Z","organization_id":"00000000-0000-0000-0000-000000000001"},{"name":"db2","default_schema":"public","owner":"sysadmin","created_by_role":"sysadmin","created_by_role_deleted":false,"created_by":"[e-mail]","created_at":"2025-06-20T10:39:31.647Z","updated_by_role":"sysadmin","updated_by_role_deleted":false,"updated_by":"[e-mail]","updated_at":"2025-11-17T22:01:28.265Z","organization_id":"00000000-0000-0000-0000-000000000001"}]

See Also

• System Tables Overview

• LIST DATABASES

• CREATE DATABASE