steampipecloud_audit_logsteampipecloud_connectionsteampipecloud_organizationsteampipecloud_organization_membersteampipecloud_organization_workspace_membersteampipecloud_processsteampipecloud_tokensteampipecloud_usersteampipecloud_user_emailsteampipecloud_user_preferencessteampipecloud_workspacesteampipecloud_workspace_aggregatorsteampipecloud_workspace_connectionsteampipecloud_workspace_db_logsteampipecloud_workspace_modsteampipecloud_workspace_mod_variablesteampipecloud_workspace_pipelinesteampipecloud_workspace_processsteampipecloud_workspace_snapshot
Table: steampipecloud_user_email
The user email table allows users to manage their email.
The steampipecloud_user_email table returns a list of emails added by users to their profile.
Examples
Basic info
select id, email, status, created_atfrom steampipecloud_user_email;Schema for steampipecloud_user_email
| Name | Type | Operators | Description |
|---|---|---|---|
| _ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
| created_at | timestamp with time zone | The time when the user email was created. | |
| text | The email ID. | ||
| id | text | The unique identifier for the user email. | |
| status | text | The current status of the email. Can be one of pending/verified | |
| version_id | bigint | The version ID of the user email. |