Table: fastly_data_center - Query Fastly Data Centers using SQL
Fastly is a cloud computing service provider that offers an edge cloud platform, which moves data and applications closer to users to improve their digital experiences. Fastly's edge cloud platform enables customers to create great digital experiences quickly, securely, and reliably by processing, serving, and securing its customers' applications as close to their end-users as possible. Fastly Data Centers are the physical locations where these edge servers are placed, and they play a crucial role in delivering fast, secure, and scalable online experiences.
Table Usage Guide
The fastly_data_center
table provides insights into Fastly's data center locations and their operational status. As a network engineer or site reliability engineer, this table can be used to understand the geographical distribution of Fastly data centers, their operational status, and other relevant details. This information can be crucial in planning for network expansion, managing network traffic, and ensuring optimal performance of your digital experiences.
Examples
Basic info
Discover the segments that utilize specific data centers by pinpointing their names, codes, and geographical locations. This is useful for understanding the distribution and reach of your data infrastructure across different regions.
select name, code, location_group, longitude, latitude, shieldfrom fastly_data_center;
select name, code, location_group, longitude, latitude, shieldfrom fastly_data_center;
Show data center detail for a particular code
Explore the specific details of a data center based on its unique code. This can help in understanding its geographical location and security settings, which can be useful for resource allocation and risk assessment.
select name, code, location_group, longitude, latitude, shieldfrom fastly_data_centerwhere code = 'BNE';
select name, code, location_group, longitude, latitude, shieldfrom fastly_data_centerwhere code = 'BNE';
List data centers in Europe
Explore which data centers are located in Europe, allowing you to understand their geographical distribution and plan your data management strategy accordingly.
select name, code, location_group, longitude, latitude, shieldfrom fastly_data_centerwhere location_group = 'Europe';
select name, code, location_group, longitude, latitude, shieldfrom fastly_data_centerwhere location_group = 'Europe';
Show data center count by location group
Analyze the distribution of data centers across various location groups. This offers a clear perspective on where resources are concentrated, helping to strategize future infrastructure expansion or optimization.
select location_group, count(*)from fastly_data_centergroup by location_grouporder by count desc;
select location_group, count(*)from fastly_data_centergroup by location_grouporder by count(*) desc;
Schema for fastly_data_center
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
code | text | Data center location code, e.g. BNE. | |
latitude | double precision | Location latitude. | |
location_group | text | Location group, e.g. Europe. | |
longitude | double precision | Location longitude. | |
name | text | Name of the data center. | |
service_id | text | =, !=, ~~, ~~*, !~~, !~~* | Alphanumeric string identifying the service. |
shield | text | Data center shield. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
title | text | Title of the resource. |
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_data_center