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_atfrom fastly_service_domain;
select name, service_id, service_version, comment, created_at, updated_atfrom 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_atfrom fastly_service_domainwhere created_at >= now() - interval '30 days';
select name, service_id, service_version, comment, created_at, updated_atfrom fastly_service_domainwhere 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_atfrom fastly_service_domainwhere deleted_at is null;
select name, service_id, service_version, created_atfrom fastly_service_domainwhere 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_atfrom fastly_service_domain as d, fastly_service as swhere d.service_id = s.id and s.name = 'service-check';
select d.name as domain_name, service_id, service_version, d.created_atfrom fastly_service_domain as d, fastly_service as swhere d.service_id = s.id and s.name = 'service-check';
Schema for fastly_service_domain
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
comment | text | A freeform descriptive note. | |
created_at | timestamp with time zone | Timestamp (UTC) of when the domain was created. | |
deleted_at | timestamp with time zone | Timestamp (UTC) of when the domain was deleted. | |
name | text | = | The name of the domain or domains associated with this service. |
service_id | text | Alphanumeric string identifying the service. | |
service_version | bigint | Integer identifying a service version. | |
title | text | Title of the resource. | |
updated_at | timestamp with time zone | Timestamp (UTC) of when the domain was updated. |
Export
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