Table: planetscale_certificate
List certificates in your account.
Note:
database_name
must be specified in thewhere
clause for all queries.
Examples
List all certificates for a database
select *from planetscale_certificatewhere database_name = 'test'
List all certificates for all branches
select c.*from planetscale_database as d join planetscale_certificate as c on d.name = c.database_name
.inspect planetscale_certificate
Database Branches in the PlanetScale account.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
branch_name | text | Name of the database branch. |
certificate | text | Certificate string. |
created_at | timestamp with time zone | When the certificate was created. |
database_name | text | Name of the database. |
deleted_at | timestamp with time zone | When the certificate was deleted. |
id | text | ID of the certificate. |
name | text | Name of the certificate. |
organization_name | text | Name of the organization. |
role | text | Role for the certificate. |