List deployments in your account.
List recent deployments
selectname as project,state,url,creator ->> 'email' as creator,meta ->> 'githubCommitMessage' as commit_message,meta ->> 'githubCommitRef' as commit_reffromvercel_deploymentwherecreated_at > now() - interval '2 weeks'order bycreated_at desc;
List recent deployments that are in ERROR state
selectname as project,state,url,creator ->> 'email' as creator,meta ->> 'githubCommitMessage' as commit_messagefromvercel_deploymentwherecreated_at > now() - interval '2 weeks'and state = 'ERROR'order bycreated_at desc;
Deployments in the Vercel account.
|_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.|