Table: planetscale_deploy_request
List deploy requests in your account.
Examples
List all deploy requests for all databases
select *from planetscale_deploy_request
List deploy requests for a specific database
select *from planetscale_deploy_requestwhere database_name = 'test'
List open deploy requests for all databases
select *from planetscale_deploy_requestwhere state = 'open'
List deploy requests with no changes
select *from planetscale_deploy_requestwhere deployment ->> 'state' = 'no_changes'
.inspect planetscale_deploy_request
Deploy Requests in the PlanetScale account.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
approved | boolean | True if the deploy request is approved. |
branch | text | Deploy request branch. |
closed_at | timestamp with time zone | When the deploy request was closed. |
created_at | timestamp with time zone | When the deploy request was created. |
database_name | text | Name of the database. |
deployment | jsonb | Details of the deployment. |
id | text | Unique ID for the deplloy request. |
into_branch | text | Deploy request into branch. |
notes | text | Notes for the deploy request. |
number | bigint | Number for this deploy request. |
organization_name | text | Name of the organization. |
state | text | State of the deploy request. |
updated_at | timestamp with time zone | When the deploy request was updated. |