Table: vercel_deployment
List deployments in your account.
Examples
List recent deployments
select name as project, state, url, creator ->> 'email' as creator, meta ->> 'githubCommitMessage' as commit_message, meta ->> 'githubCommitRef' as commit_reffrom vercel_deploymentwhere created_at > now() - interval '2 weeks'order by created_at desc;
List recent deployments that are in ERROR state
select name as project, state, url, creator ->> 'email' as creator, meta ->> 'githubCommitMessage' as commit_messagefrom vercel_deploymentwhere created_at > now() - interval '2 weeks' and state = 'ERROR'order by created_at desc;
.inspect vercel_deployment
Deployments in the Vercel account.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
building_at | timestamp with time zone | Time when deployment started to build. |
created_at | timestamp with time zone | Time when the deployment was created. |
creator | jsonb | Creator of the deployment. |
meta | jsonb | GitHub metadata associated with the deployment. |
name | text | Name of the deployment. |
ready | timestamp with time zone | Time when deployment is ready to view. |
state | text | One of: BUILDING, ERROR, INITIALIZING, QUEUED, READY, CANCELED. |
url | text | URL of the deployment. |