turbot/vercel

GitHub
steampipe plugin install vercelsteampipe plugin install vercel

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_ref
from
vercel_deployment
where
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_message
from
vercel_deployment
where
created_at > now() - interval '2 weeks'
and state = 'ERROR'
order by
created_at desc;

.inspect vercel_deployment

Deployments in the Vercel account.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
building_attimestamp with time zoneTime when deployment started to build.
created_attimestamp with time zoneTime when the deployment was created.
creatorjsonbCreator of the deployment.
metajsonbGitHub metadata associated with the deployment.
nametextName of the deployment.
readytimestamp with time zoneTime when deployment is ready to view.
statetextOne of: BUILDING, ERROR, INITIALIZING, QUEUED, READY, CANCELED.
urltextURL of the deployment.