Table: fastly_backend - Query Fastly Backends using SQL

A Fastly Backend represents an origin server to which Fastly will connect to fetch content. Backends are defined in the configuration for a Fastly service and are associated with a specific service and version. They provide the critical link between Fastly and the origin server, defining how Fastly connects to the origin to fetch the content it will cache and deliver.

Table Usage Guide

The fastly_backend table provides insights into the configuration and status of backends within Fastly's edge cloud platform. As an infrastructure engineer, explore backend-specific details through this table, including the service it is associated with, its version, and its connection details. Utilize it to uncover information about backends, such as the connection timeouts, max connections, and the healthcheck parameters.

Examples

Basic info

Explore the configuration of your backend servers on Fastly to understand their security settings, load balancing status, and creation dates. This can help you assess your current setup and identify areas for potential improvement or troubleshooting.

select
  name,
  address,
  port,
  use_ssl,
  auto_loadbalance,
  created_at,
  service_id,
  service_version
from
  fastly_backend;

select
  name,
  address,
  port,
  use_ssl,
  auto_loadbalance,
  created_at,
  service_id,
  service_version
from
  fastly_backend;

List all backends that are not deleted

Discover the segments that contain all active backends in your Fastly service. This information is useful for maintaining an overview of your current operational infrastructure and understanding the configuration of each backend.

select
  name,
  address,
  port,
  use_ssl,
  auto_loadbalance,
  created_at,
  service_id,
  service_version
from
  fastly_backend
where
  deleted_at is null;

select
  name,
  address,
  port,
  use_ssl,
  auto_loadbalance,
  created_at,
  service_id,
  service_version
from
  fastly_backend
where
  deleted_at is null;

List all backends that are using SSL

Discover the segments that are utilizing SSL for secure communication, which can be crucial for maintaining data privacy and enhancing security measures. This can be particularly useful in identifying and managing secure backends in your network infrastructure.

select
  name,
  address,
  port,
  use_ssl,
  auto_loadbalance,
  created_at,
  service_id,
  service_version
from
  fastly_backend
where
  use_ssl;

select
  name,
  address,
  port,
  use_ssl,
  auto_loadbalance,
  created_at,
  service_id,
  service_version
from
  fastly_backend
where
  use_ssl = 1;

List all backends where auto load balance is enabled

Discover the segments that are auto load balanced in your backends. This is useful for identifying areas where load distribution is automated, allowing for efficient resource management.

select
  name,
  address,
  port,
  use_ssl,
  auto_loadbalance,
  created_at,
  service_id,
  service_version
from
  fastly_backend
where
  auto_loadbalance;

select
  name,
  address,
  port,
  use_ssl,
  auto_loadbalance,
  created_at,
  service_id,
  service_version
from
  fastly_backend
where
  auto_loadbalance = 1;

List backends for a particular service

Uncover the details of specific backends associated with a particular service in Fastly. This is useful for understanding the configuration and settings of the backends, including whether they use SSL, auto load balance, their address, and port, providing insights into the service's operation and performance.

select
  b.name,
  address,
  port,
  use_ssl,
  auto_loadbalance,
  b.created_at,
  service_id,
  service_version
from
  fastly_backend as b,
  fastly_service as s
where
  b.service_id = s.id
  and s.name = 'check-service';

select
  b.name,
  address,
  port,
  use_ssl,
  auto_loadbalance,
  b.created_at,
  service_id,
  service_version
from
  fastly_backend as b,
  fastly_service as s
where
  b.service_id = s.id
  and s.name = 'check-service';

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_backend