Table: fastly_service_domain - Query Fastly Service Domains using SQL

Fastly is a cloud computing service provider that offers an edge cloud platform, which is designed to help developers extend their core cloud infrastructure to the edge of the network, closer to users. Fastly's edge cloud platform enhances web and mobile delivery by accelerating dynamic assets and caching static assets. It also provides security services, video & streaming, and cloud networking services.

Table Usage Guide

The fastly_service_domain table provides insights into the domain names associated with Fastly services. As a DevOps engineer, explore domain-specific details through this table, including service IDs, version numbers, and associated metadata. Utilize it to uncover information about domains, such as those associated with specific services, the versions of those services, and the effective management of content delivery networks.

Examples

Basic info

Explore the essential details of your Fastly service domains, such as the name, version, and timestamps for creation and updates. This information can help you manage and track changes to your services over time.

select
  name,
  service_id,
  service_version,
  comment,
  created_at,
  updated_at
from
  fastly_service_domain;

select
  name,
  service_id,
  service_version,
  comment,
  created_at,
  updated_at
from
  fastly_service_domain;

List domains created in the last 30 days

Explore the recent additions to your web service by identifying domains that have been added in the past month. This can be useful for tracking growth, monitoring new domains, and maintaining an up-to-date overview of your service landscape.

select
  name,
  service_id,
  service_version,
  comment,
  created_at,
  updated_at
from
  fastly_service_domain
where
  created_at >= now() - interval '30 days';

select
  name,
  service_id,
  service_version,
  comment,
  created_at,
  updated_at
from
  fastly_service_domain
where
  created_at >= datetime('now', '-30 days');

List domains that are not deleted

Discover the segments that are actively in use in your Fastly services by identifying domains that have not been deleted. This can help maintain an efficient and streamlined service by focusing resources on active domains.

select
  name,
  service_id,
  service_version,
  created_at
from
  fastly_service_domain
where
  deleted_at is null;

select
  name,
  service_id,
  service_version,
  created_at
from
  fastly_service_domain
where
  deleted_at is null;

List domains of a particular service

Gain insights into the different domains associated with a specific service, enabling you to monitor service performance and version details over time. This can be particularly useful in managing and troubleshooting service-related issues.

select
  d.name as domain_name,
  service_id,
  service_version,
  d.created_at
from
  fastly_service_domain as d,
  fastly_service as s
where
  d.service_id = s.id
  and s.name = 'service-check';

select
  d.name as domain_name,
  service_id,
  service_version,
  d.created_at
from
  fastly_service_domain as d,
  fastly_service as s
where
  d.service_id = s.id
  and s.name = 'service-check';

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- fastly

You can pass the configuration to the command with the --config argument:

steampipe_export_fastly --config '<your_config>' fastly_service_domain