Table: digitalocean_app - Query DigitalOcean Apps using SQL

DigitalOcean App Platform is a Platform as a Service (PaaS) offering that allows developers to publish code directly to DigitalOcean servers without worrying about the underlying infrastructure. The service automatically analyzes the code, creates containers, and runs them on Kubernetes clusters. It supports several programming languages and frameworks and offers built-in database and caching for high scalability.

Table Usage Guide

The digitalocean_app table provides insights into Apps deployed on the DigitalOcean App Platform. As a developer or DevOps engineer, explore app-specific details through this table, including the app's ID, name, live URL, active deployment and region. Utilize it to monitor and manage the apps deployed on DigitalOcean, and to ensure the smooth operation and performance of your applications.

Examples

Basic info

Explore the basic information about your DigitalOcean applications, such as their unique identifiers and creation dates, to gain a better understanding of your resources. This can be particularly useful for auditing purposes or when planning resource management strategies.

select
  id,
  name,
  urn,
  created_at
from
  digitalocean_app;

select
  id,
  name,
  urn,
  created_at
from
  digitalocean_app;

Schema for digitalocean_app

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
active_deployment	jsonb		The app's currently active deployment.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
created_at	timestamp with time zone		Time when the app was created.
id	text	=	The id of the app.
in_progress_deployment	jsonb		In progress deployment of the app.
last_deployment_created_at	timestamp with time zone		Time when the app last deployed.
live_domain	text		The live domain of the app.
live_url	text		The live URL of the app.
live_url_base	text		The live URL base of the app.
name	text		The name of the app
owner_uuid	text		OwnerUUID of the app.
region	jsonb		The DigitalOcean data center region hosting the app.
spec	jsonb		A DigitalOcean App spec describing the app.
tier_slug	text		Tier slug of the app
title	text		Title of the resource.
updated_at	timestamp with time zone		Time when the app was updated.
urn	text		The uniform resource name (URN) for the app.