turbot/planetscale

GitHub
steampipe plugin install planetscalesteampipe plugin install planetscale

Table: planetscale_certificate

List certificates in your account.

Note:

  • database_name must be specified in the where clause for all queries.

Examples

List all certificates for a database

select
*
from
planetscale_certificate
where
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.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
branch_nametextName of the database branch.
certificatetextCertificate string.
created_attimestamp with time zoneWhen the certificate was created.
database_nametextName of the database.
deleted_attimestamp with time zoneWhen the certificate was deleted.
idtextID of the certificate.
nametextName of the certificate.
organization_nametextName of the organization.
roletextRole for the certificate.