Forem: StackQL Studios

AWS Service Support by Region at a Glance

Jeffrey Aven — Fri, 22 Mar 2024 02:06:34 +0000

The AWS docs provide a list of services for each region as seen here, unfortunately this requires you to select a region in a drop down to see the services available for that region.

Using stackql and the AWS Cloud Control API (using the awscc provider) , I was able to generate a consolidated list by testing a resource from each service for each region, here it is:

Service	us-east-1 (N. Virginia)	us-east-2 (Ohio)	us-west-1 (N. California)	us-west-2 (Oregon)	ap-south-1 (Mumbai)	ap-northeast-3 (Osaka)	ap-northeast-2 (Seoul)	ap-southeast-1 (Singapore)	ap-southeast-2 (Sydney)	ap-northeast-1 (Tokyo)	ca-central-1 (Canada)	eu-central-1 (Frankfurt)	eu-west-1 (Ireland)	eu-west-2 (London)	eu-west-3 (Paris)	eu-north-1 (Stockholm)	sa-east-1 (São Paulo)
accessanalyzer	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
acmpca	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
amplify	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
apigateway	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
apigatewayv2	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
appconfig	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
appflow	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	❌	✅
applicationinsights	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
apprunner	✅	✅	❌	✅	✅	❌	❌	✅	✅	✅	❌	✅	✅	✅	✅	❌	❌
appstream	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	❌	✅
appsync	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
aps	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅
arczonalshift	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
athena	✅	✅	❌	✅	❌	❌	❌	✅	✅	✅	❌	❌	✅	❌	❌	✅	❌
autoscaling	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
backup	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
backupgateway	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
batch	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
budgets	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	❌	✅
cassandra	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
ce	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
chatbot	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
cleanrooms	✅	✅	❌	✅	❌	❌	✅	✅	✅	✅	❌	✅	✅	✅	❌	✅	❌
cloudformation	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
cloudfront	✅	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌
cloudtrail	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
cloudwatch	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
codeartifact	✅	✅	❌	✅	✅	❌	❌	✅	✅	✅	❌	✅	✅	✅	✅	✅	❌
codebuild	✅	✅	❌	✅	✅	❌	❌	✅	✅	✅	❌	✅	✅	❌	❌	❌	✅
codedeploy	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
codeguruprofiler	✅	✅	❌	✅	❌	❌	❌	✅	✅	✅	❌	✅	✅	✅	❌	✅	❌
codegurureviewer	✅	✅	❌	✅	❌	❌	❌	✅	✅	✅	❌	✅	✅	✅	❌	✅	❌
codepipeline	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
codestarconnections	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
codestarnotifications	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
cognito	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
comprehend	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	❌	❌
config	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
connect	✅	❌	❌	✅	❌	❌	✅	✅	✅	✅	✅	✅	❌	✅	❌	❌	❌
databrew	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
datapipeline	✅	❌	❌	✅	❌	❌	❌	❌	✅	✅	❌	❌	✅	❌	❌	❌	❌
datasync	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
detective	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
devopsguru	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
directoryservice	✅	❌	❌	✅	❌	❌	❌	✅	✅	✅	❌	❌	✅	❌	❌	❌	❌
dms	✅	✅	❌	✅	❌	❌	❌	✅	✅	✅	❌	✅	✅	❌	❌	✅	❌
dynamodb	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
ec2	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
ecr	✅	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌
ecs	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
efs	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
eks	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
elasticache	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
elasticbeanstalk	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
elasticloadbalancingv2	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
emr	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
emrcontainers	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	❌	❌
emrserverless	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
events	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
eventschemas	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
fis	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
forecast	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	❌	✅	✅	❌	❌	❌	❌
frauddetector	✅	✅	❌	✅	❌	❌	❌	✅	✅	❌	❌	❌	✅	❌	❌	❌	❌
fsx	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
gamelift	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	❌	✅
globalaccelerator	✅	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌
grafana	✅	✅	❌	✅	❌	❌	✅	✅	✅	✅	❌	✅	✅	✅	❌	❌	❌
greengrassv2	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	❌	❌
groundstation	✅	✅	❌	✅	❌	❌	✅	✅	✅	❌	❌	✅	✅	❌	❌	✅	✅
guardduty	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
healthlake	✅	✅	❌	✅	✅	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌
iam	✅	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌
imagebuilder	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
inspector	✅	✅	✅	✅	✅	❌	✅	❌	✅	✅	❌	✅	✅	✅	❌	✅	❌
inspectorv2	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
internetmonitor	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
iot	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	❌
iotanalytics	✅	✅	❌	✅	✅	❌	❌	❌	✅	✅	❌	✅	✅	❌	❌	❌	❌
iotevents	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	❌	❌
iotfleethub	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	✅	❌
iotfleetwise	✅	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	✅	❌	❌	❌	❌	❌
iotsitewise	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	❌	❌	❌	❌
iotwireless	✅	❌	❌	✅	❌	❌	❌	❌	✅	✅	❌	✅	✅	❌	❌	❌	✅
ivs	✅	❌	❌	✅	✅	❌	✅	❌	❌	✅	❌	✅	✅	❌	❌	❌	❌
ivschat	✅	❌	❌	✅	✅	❌	✅	❌	❌	✅	❌	✅	✅	❌	❌	❌	❌
kafkaconnect	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
kendra	✅	✅	❌	✅	✅	❌	❌	✅	✅	✅	✅	❌	✅	✅	❌	❌	❌
kinesis	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
kinesisanalyticsv2	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
kinesisfirehose	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
kms	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
lakeformation	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
lambda	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
lex	✅	❌	❌	✅	❌	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	❌	❌
lightsail	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	❌
logs	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
lookoutequipment	✅	❌	❌	❌	❌	❌	✅	❌	❌	❌	❌	❌	✅	❌	❌	❌	❌
lookoutmetrics	✅	✅	❌	✅	❌	❌	❌	✅	✅	✅	❌	✅	✅	❌	❌	✅	❌
lookoutvision	✅	✅	❌	✅	❌	❌	✅	❌	❌	✅	❌	✅	✅	❌	❌	❌	❌
m2	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
macie	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
mediaconnect	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
medialive	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
mediapackage	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅
mediapackagev2	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
memorydb	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	✅	✅
msk	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
mwaa	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
neptune	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
networkfirewall	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
networkmanager	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
nimblestudio	✅	✅	❌	✅	❌	❌	❌	✅	✅	✅	✅	✅	✅	✅	❌	✅	❌
oam	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
omics	✅	❌	❌	✅	❌	❌	❌	✅	❌	❌	❌	✅	✅	✅	❌	❌	❌
opensearchserverless	✅	✅	❌	✅	❌	❌	❌	✅	✅	✅	❌	✅	✅	❌	❌	❌	❌
opsworkscm	✅	✅	✅	✅	❌	❌	❌	✅	✅	✅	❌	✅	✅	❌	❌	❌	❌
organizations	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
osis	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	✅	✅
pcaconnectorad	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
personalize	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	❌	❌	❌	❌
pinpoint	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	❌	❌
pipes	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
proton	✅	✅	❌	✅	❌	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	❌	❌
ram	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
rds	✅	✅	❌	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	✅	✅
redshift	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
refactorspaces	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
rekognition	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	❌	❌	❌
resiliencehub	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
resourceexplorer2	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
resourcegroups	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
robomaker	✅	✅	❌	✅	❌	❌	❌	✅	❌	✅	❌	✅	✅	❌	❌	❌	❌
route53	✅	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌
route53recoverycontrol	✅	❌	❌	✅	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌
route53recoveryreadiness	✅	❌	❌	✅	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌
route53resolver	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
rum	✅	✅	❌	✅	❌	❌	❌	✅	✅	✅	❌	✅	✅	✅	❌	✅	❌
s3	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
s3objectlambda	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
sagemaker	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
scheduler	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
secretsmanager	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
securityhub	❌	❌	❌	❌	❌	❌	❌	❌	✅	❌	❌	❌	❌	❌	❌	❌	❌
servicecatalog	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
servicecatalogappregistry	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
ses	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
signer	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
sns	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
sqs	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
ssm	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
ssmcontacts	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
ssmincidents	✅	✅	✅	✅	✅	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
stepfunctions	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
synthetics	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
timestream	✅	✅	❌	✅	❌	❌	❌	❌	✅	✅	❌	✅	✅	❌	❌	❌	❌
transfer	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
verifiedpermissions	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐	🌐
vpclattice	✅	✅	❌	✅	❌	❌	❌	✅	✅	✅	✅	✅	✅	✅	❌	✅	❌
wafv2	✅	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌	❌
workspacesweb	✅	❌	❌	✅	✅	❌	❌	✅	❌	✅	✅	✅	✅	✅	❌	❌	❌

Here is the output as a python object:

supported_regions = {
 'accessanalyzer': ['global'],
 'acmpca': ['global'],
 'amplify': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
             'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
             'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
             'eu-west-2', 'eu-west-3', 'eu-north-1', 'sa-east-1'],
 'apigateway': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
                'eu-north-1', 'sa-east-1'],
 'apigatewayv2': ['global'],
 'appconfig': ['global'],
 'appflow': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
             'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
             'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
             'eu-west-2', 'eu-west-3', 'sa-east-1'],
 'applicationinsights': ['global'],
 'apprunner': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
               'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
               'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3'],
 'appstream': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
               'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
               'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
               'eu-west-2', 'sa-east-1'],
 'appsync': ['global'],
 'aps': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1', 'ap-northeast-2',
         'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1', 'eu-central-1',
         'eu-west-1', 'eu-west-2', 'eu-west-3', 'eu-north-1', 'sa-east-1'],
 'arczonalshift': ['global'],
 'athena': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-1',
            'ap-southeast-2', 'ap-northeast-1', 'eu-west-1', 'eu-north-1'],
 'autoscaling': ['global'],
 'backup': ['global'],
 'backupgateway': ['global'],
 'batch': ['global'],
 'budgets': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
             'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
             'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
             'eu-west-2', 'eu-west-3', 'sa-east-1'],
 'cassandra': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
               'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
               'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
               'eu-west-2', 'eu-west-3', 'eu-north-1', 'sa-east-1'],
 'ce': ['global'],
 'chatbot': ['global'],
 'cleanrooms': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-northeast-2',
                'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
                'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-north-1'],
 'cloudformation': ['global'],
 'cloudfront': ['us-east-1'],
 'cloudtrail': ['global'],
 'cloudwatch': ['global'],
 'codeartifact': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
                  'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
                  'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
                  'eu-north-1'],
 'codebuild': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
               'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
               'eu-central-1', 'eu-west-1', 'sa-east-1'],
 'codedeploy': ['global'],
 'codeguruprofiler': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-1',
                      'ap-southeast-2', 'ap-northeast-1', 'eu-central-1',
                      'eu-west-1', 'eu-west-2', 'eu-north-1'],
 'codegurureviewer': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-1',
                      'ap-southeast-2', 'ap-northeast-1', 'eu-central-1',
                      'eu-west-1', 'eu-west-2', 'eu-north-1'],
 'codepipeline': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                  'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                  'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                  'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
                  'eu-north-1', 'sa-east-1'],
 'codestarconnections': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                         'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                         'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                         'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
                         'eu-north-1', 'sa-east-1'],
 'codestarnotifications': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                           'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                           'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                           'eu-central-1', 'eu-west-1', 'eu-west-2',
                           'eu-west-3', 'eu-north-1', 'sa-east-1'],
 'cognito': ['global'],
 'comprehend': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
                'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
                'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
                'eu-west-2'],
 'config': ['global'],
 'connect': ['us-east-1', 'us-west-2', 'ap-northeast-2', 'ap-southeast-1',
             'ap-southeast-2', 'ap-northeast-1', 'ca-central-1', 'eu-central-1',
             'eu-west-2'],
 'databrew': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
              'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
              'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
              'eu-west-2', 'eu-west-3', 'eu-north-1', 'sa-east-1'],
 'datapipeline': ['us-east-1', 'us-west-2', 'ap-southeast-2', 'ap-northeast-1',
                  'eu-west-1'],
 'datasync': ['global'],
 'detective': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
               'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
               'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
               'eu-west-2', 'eu-west-3', 'eu-north-1', 'sa-east-1'],
 'devopsguru': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
                'eu-north-1', 'sa-east-1'],
 'directoryservice': ['us-east-1', 'us-west-2', 'ap-southeast-1',
                      'ap-southeast-2', 'ap-northeast-1', 'eu-west-1'],
 'dms': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-1',
         'ap-southeast-2', 'ap-northeast-1', 'eu-central-1', 'eu-west-1',
         'eu-north-1'],
 'dynamodb': ['global'],
 'ec2': ['global'],
 'ecr': ['us-east-1'],
 'ecs': ['global'],
 'efs': ['global'],
 'eks': ['global'],
 'elasticache': ['global'],
 'elasticbeanstalk': ['global'],
 'elasticloadbalancingv2': ['global'],
 'emr': ['global'],
 'emrcontainers': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                   'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                   'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                   'eu-central-1', 'eu-west-1', 'eu-west-2'],
 'emrserverless': ['global'],
 'events': ['global'],
 'eventschemas': ['global'],
 'fis': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
         'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
         'ca-central-1', 'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
         'eu-north-1', 'sa-east-1'],
 'forecast': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
              'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
              'ap-northeast-1', 'eu-central-1', 'eu-west-1'],
 'frauddetector': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-1',
                   'ap-southeast-2', 'eu-west-1'],
 'fsx': ['global'],
 'gamelift': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
              'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
              'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
              'eu-west-2', 'sa-east-1'],
 'globalaccelerator': ['us-east-1'],
 'grafana': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-northeast-2',
             'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
             'eu-central-1', 'eu-west-1', 'eu-west-2'],
 'greengrassv2': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
                  'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
                  'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
                  'eu-west-2'],
 'groundstation': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-northeast-2',
                   'ap-southeast-1', 'ap-southeast-2', 'eu-central-1',
                   'eu-west-1', 'eu-north-1', 'sa-east-1'],
 'guardduty': ['global'],
 'healthlake': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1'],
 'iam': ['us-east-1'],
 'imagebuilder': ['global'],
 'inspector': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
               'ap-northeast-2', 'ap-southeast-2', 'ap-northeast-1',
               'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-north-1'],
 'inspectorv2': ['global'],
 'internetmonitor': ['global'],
 'iot': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
         'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
         'ca-central-1', 'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
         'eu-north-1'],
 'iotanalytics': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
                  'ap-southeast-2', 'ap-northeast-1', 'eu-central-1',
                  'eu-west-1'],
 'iotevents': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
               'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
               'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
               'eu-west-2'],
 'iotfleethub': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
                 'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
                 'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
                 'eu-west-2', 'eu-north-1'],
 'iotfleetwise': ['us-east-1', 'eu-central-1'],
 'iotsitewise': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
                 'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
                 'ap-northeast-1', 'ca-central-1', 'eu-central-1',
                 'eu-west-1'],
 'iotwireless': ['us-east-1', 'us-west-2', 'ap-southeast-2', 'ap-northeast-1',
                 'eu-central-1', 'eu-west-1', 'sa-east-1'],
 'ivs': ['us-east-1', 'us-west-2', 'ap-south-1', 'ap-northeast-2',
         'ap-northeast-1', 'eu-central-1', 'eu-west-1'],
 'ivschat': ['us-east-1', 'us-west-2', 'ap-south-1', 'ap-northeast-2',
             'ap-northeast-1', 'eu-central-1', 'eu-west-1'],
 'kafkaconnect': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                  'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                  'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                  'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
                  'eu-north-1', 'sa-east-1'],
 'kendra': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
            'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
            'ca-central-1', 'eu-west-1', 'eu-west-2'],
 'kinesis': ['global'],
 'kinesisanalyticsv2': ['global'],
 'kinesisfirehose': ['global'],
 'kms': ['global'],
 'lakeformation': ['global'],
 'lambda': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
            'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
            'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
            'eu-west-2', 'eu-west-3', 'eu-north-1', 'sa-east-1'],
 'lex': ['us-east-1', 'us-west-2', 'ap-northeast-2', 'ap-southeast-1',
         'ap-southeast-2', 'ap-northeast-1', 'ca-central-1', 'eu-central-1',
         'eu-west-1', 'eu-west-2'],
 'lightsail': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
               'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
               'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
               'eu-west-2', 'eu-west-3', 'eu-north-1'],
 'logs': ['global'],
 'lookoutequipment': ['us-east-1', 'ap-northeast-2', 'eu-west-1'],
 'lookoutmetrics': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-1',
                    'ap-southeast-2', 'ap-northeast-1', 'eu-central-1',
                    'eu-west-1', 'eu-north-1'],
 'lookoutvision': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-northeast-2',
                   'ap-northeast-1', 'eu-central-1', 'eu-west-1'],
 'm2': ['global'],
 'macie': ['global'],
 'mediaconnect': ['global'],
 'medialive': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
               'ap-northeast-3', 'ap-northeast-2', 'ap-southeast-1',
               'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
               'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
               'eu-north-1', 'sa-east-1'],
 'mediapackage': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                  'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                  'ap-southeast-2', 'ap-northeast-1', 'eu-central-1',
                  'eu-west-1', 'eu-west-2', 'eu-west-3', 'eu-north-1',
                  'sa-east-1'],
 'mediapackagev2': ['global'],
 'memorydb': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
              'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
              'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
              'eu-west-2', 'eu-north-1', 'sa-east-1'],
 'msk': ['global'],
 'mwaa': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1', 'ap-northeast-2',
          'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
          'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3', 'eu-north-1',
          'sa-east-1'],
 'neptune': ['global'],
 'networkfirewall': ['global'],
 'networkmanager': ['global'],
 'nimblestudio': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-1',
                  'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                  'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-north-1'],
 'oam': ['global'],
 'omics': ['us-east-1', 'us-west-2', 'ap-southeast-1', 'eu-central-1',
           'eu-west-1', 'eu-west-2'],
 'opensearchserverless': ['us-east-1', 'us-east-2', 'us-west-2',
                          'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
                          'eu-central-1', 'eu-west-1'],
 'opsworkscm': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
                'eu-central-1', 'eu-west-1'],
 'organizations': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                   'ap-south-1', 'ap-northeast-3', 'ap-northeast-2',
                   'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
                   'ca-central-1', 'eu-central-1', 'eu-west-1', 'eu-west-2',
                   'eu-west-3', 'eu-north-1', 'sa-east-1'],
 'osis': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
          'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
          'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
          'eu-west-2', 'eu-north-1', 'sa-east-1'],
 'pcaconnectorad': ['global'],
 'personalize': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
                 'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
                 'ap-northeast-1', 'ca-central-1', 'eu-central-1',
                 'eu-west-1'],
 'pinpoint': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1',
              'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
              'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
              'eu-west-2'],
 'pipes': ['global'],
 'proton': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-northeast-2',
            'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1',
            'ca-central-1', 'eu-central-1', 'eu-west-1', 'eu-west-2'],
 'ram': ['global'],
 'rds': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-south-1', 'ap-northeast-2',
         'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
         'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-north-1', 'sa-east-1'],
 'redshift': ['global'],
 'refactorspaces': ['global'],
 'rekognition': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                 'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                 'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                 'eu-central-1', 'eu-west-1', 'eu-west-2'],
 'resiliencehub': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                   'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                   'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                   'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
                   'eu-north-1', 'sa-east-1'],
 'resourceexplorer2': ['global'],
 'resourcegroups': ['global'],
 'robomaker': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-1',
               'ap-northeast-1', 'eu-central-1', 'eu-west-1'],
 'route53': ['us-east-1'],
 'route53recoverycontrol': ['us-east-1', 'us-west-2'],
 'route53recoveryreadiness': ['us-east-1', 'us-west-2'],
 'route53resolver': ['global'],
 'rum': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-1',
         'ap-southeast-2', 'ap-northeast-1', 'eu-central-1', 'eu-west-1',
         'eu-west-2', 'eu-north-1'],
 's3': ['global'],
 's3objectlambda': ['global'],
 'sagemaker': ['global'],
 'scheduler': ['global'],
 'secretsmanager': ['global'],
 'securityhub': ['ap-southeast-2'],
 'servicecatalog': ['global'],
 'servicecatalogappregistry': ['global'],
 'ses': ['global'],
 'signer': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1',
            'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2',
            'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1',
            'eu-west-2', 'eu-west-3', 'eu-north-1', 'sa-east-1'],
 'sns': ['global'],
 'sqs': ['global'],
 'ssm': ['global'],
 'ssmcontacts': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                 'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                 'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                 'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
                 'eu-north-1', 'sa-east-1'],
 'ssmincidents': ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2',
                  'ap-south-1', 'ap-northeast-2', 'ap-southeast-1',
                  'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                  'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3',
                  'eu-north-1', 'sa-east-1'],
 'stepfunctions': ['global'],
 'synthetics': ['global'],
 'timestream': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-2',
                'ap-northeast-1', 'eu-central-1', 'eu-west-1'],
 'transfer': ['global'],
 'verifiedpermissions': ['global'],
 'vpclattice': ['us-east-1', 'us-east-2', 'us-west-2', 'ap-southeast-1',
                'ap-southeast-2', 'ap-northeast-1', 'ca-central-1',
                'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-north-1'],
 'wafv2': ['us-east-1'],
 'workspacesweb': ['us-east-1', 'us-west-2', 'ap-south-1', 'ap-southeast-1',
                   'ap-northeast-1', 'ca-central-1', 'eu-central-1',
                   'eu-west-1', 'eu-west-2']
}

Here's the code used to generate this (all you need to do is pip install pystackql):

pystackql is a python wrapper for StackQL, see pystackql or Read the Docs

from pystackql import StackQL

# Initialize StackQL
stackql = StackQL(output='pandas', execution_concurrency_limit=-1)

# pull the latest stackql providers for aws
stackql.executeStmt("REGISTRY PULL aws")
stackql.executeStmt("REGISTRY PULL awscc")

# Predefined regions to check
regions = ['us-east-1', 'us-east-2', 'us-west-1', 'us-west-2', 'ap-south-1', 'ap-northeast-3', 'ap-northeast-2', 'ap-southeast-1', 'ap-southeast-2', 'ap-northeast-1', 'ca-central-1', 'eu-central-1', 'eu-west-1', 'eu-west-2', 'eu-west-3', 'eu-north-1', 'sa-east-1']

# Initialize the supported regions dictionary
supported_regions = {}

def execute_query_for_region(service, resource, region):
  query = f"SELECT COUNT(*) FROM awscc.{service}.{resource} WHERE region = '{region}'"
  df = stackql.execute(query)
  if 'error' in df.columns:
    return False
  else:
    return True

def enumerate_services_and_test_resources():
  services_df = stackql.execute("SHOW SERVICES IN awscc")
  services = services_df['name'].tolist()

  for service in services:
    resources_df = stackql.execute(f"SHOW RESOURCES IN awscc.{service}")
    plural_resources = [resource for resource in resources_df['name'].tolist() if resource.endswith('s')]

    # If plural resources are found, test the first one
    # plural awscc resources implement the Cloud Control list method if supported
    if plural_resources:
      resource = plural_resources[0]
      print(f"Checking {service}...")

      # Query across ALL AWS regions
      all_regions_in_clause = ", ".join([f"'{region}'" for region in regions])
      resource_df = stackql.execute(f"SELECT COUNT(*) as total FROM awscc.{service}.{resource} WHERE region IN ({all_regions_in_clause})")
      if 'error' in resource_df.columns:
        # query each region individually to determine availability
        supported_regions[service] = []
        for region in regions:
          print(f"Checking {service} in {region}...")
          if execute_query_for_region(service, resource, region):
            supported_regions[service].append(region)
        if not supported_regions[service]:
          # additional parameters required aside from region
          del supported_regions[service]
      else:
        supported_regions[service] = ['global']
    else:
      supported_regions[service] = ['check manually']

enumerate_services_and_test_resources()
print(supported_regions)

And here is an application using the output of this program (The 5 Minute Global AWS Inventory).

Unsupported Resource Types with the AWS Cloud Control API

Jeffrey Aven — Sun, 03 Mar 2024 11:29:48 +0000

Our latest AWS provider for StackQL leverages the Cloud Control API.

AWS lists resources supported by the Cloud Control API here.

However, we have put together a list of unsupported resource types with the Cloud Control API; here you go:

AWS::AmazonMQ::Broker
AWS::AmazonMQ::Configuration
AWS::AmazonMQ::ConfigurationAssociation
AWS::ApiGatewayV2::ApiGatewayManagedOverrides
AWS::ApiGatewayV2::Integration
AWS::ApiGatewayV2::Stage
AWS::AppConfig::Deployment
AWS::AppConfig::DeploymentStrategy
AWS::AppMesh::GatewayRoute
AWS::AppMesh::Mesh
AWS::AppMesh::Route
AWS::AppMesh::VirtualGateway
AWS::AppMesh::VirtualNode
AWS::AppMesh::VirtualRouter
AWS::AppMesh::VirtualService
AWS::AppStream::Fleet
AWS::AppStream::Stack
AWS::AppStream::StackFleetAssociation
AWS::AppStream::StackUserAssociation
AWS::AppStream::User
AWS::AppSync::ApiCache
AWS::AppSync::ApiKey
AWS::AppSync::DataSource
AWS::AppSync::GraphQLApi
AWS::AppSync::GraphQLSchema
AWS::AutoScalingPlans::ScalingPlan
AWS::Batch::JobDefinition
AWS::Budgets::Budget
AWS::CertificateManager::Certificate
AWS::Cloud9::EnvironmentEC2
AWS::CloudFormation::CustomResource
AWS::CloudFormation::Macro
AWS::CloudFormation::WaitCondition
AWS::CloudFormation::WaitConditionHandle
AWS::CloudFront::StreamingDistribution
AWS::CloudWatch::AnomalyDetector
AWS::CloudWatch::Dashboard
AWS::CloudWatch::InsightRule
AWS::CodeBuild::Project
AWS::CodeBuild::ReportGroup
AWS::CodeBuild::SourceCredential
AWS::CodeCommit::Repository
AWS::CodeDeploy::DeploymentGroup
AWS::CodePipeline::Pipeline
AWS::CodePipeline::Webhook
AWS::CodeStar::GitHubRepository
AWS::Cognito::UserPoolDomain
AWS::Cognito::UserPoolIdentityProvider
AWS::Cognito::UserPoolResourceServer
AWS::Cognito::UserPoolUICustomizationAttachment
AWS::Config::ConfigurationRecorder
AWS::Config::DeliveryChannel
AWS::Config::OrganizationConfigRule
AWS::Config::RemediationConfiguration
AWS::DAX::Cluster
AWS::DAX::ParameterGroup
AWS::DAX::SubnetGroup
AWS::DirectoryService::MicrosoftAD
AWS::DLM::LifecyclePolicy
AWS::DMS::Certificate
AWS::DMS::Endpoint
AWS::DMS::EventSubscription
AWS::DMS::ReplicationInstance
AWS::DMS::ReplicationSubnetGroup
AWS::DMS::ReplicationTask
AWS::DocDB::DBCluster
AWS::DocDB::DBClusterParameterGroup
AWS::DocDB::DBInstance
AWS::DocDB::DBSubnetGroup
AWS::DocDB::EventSubscription
AWS::EC2::ClientVpnAuthorizationRule
AWS::EC2::ClientVpnEndpoint
AWS::EC2::ClientVpnRoute
AWS::EC2::ClientVpnTargetNetworkAssociation
AWS::EC2::Instance
AWS::EC2::NetworkInterfacePermission
AWS::EC2::SecurityGroup
AWS::EC2::TrafficMirrorFilter
AWS::EC2::TrafficMirrorFilterRule
AWS::EC2::TrafficMirrorSession
AWS::EC2::TrafficMirrorTarget
AWS::EC2::TransitGatewayRoute
AWS::EC2::TransitGatewayRouteTableAssociation
AWS::EC2::TransitGatewayRouteTablePropagation
AWS::EC2::VPCCidrBlock
AWS::EC2::VPNGatewayRoutePropagation
AWS::ElastiCache::CacheCluster
AWS::ElastiCache::ParameterGroup
AWS::ElastiCache::ReplicationGroup
AWS::ElastiCache::SecurityGroup
AWS::ElastiCache::SecurityGroupIngress
AWS::ElasticLoadBalancing::LoadBalancer
AWS::ElasticLoadBalancingV2::ListenerCertificate
AWS::Elasticsearch::Domain
AWS::EMR::Cluster
AWS::EMR::InstanceFleetConfig
AWS::EMR::InstanceGroupConfig
AWS::Events::EventBusPolicy
AWS::FSx::FileSystem
AWS::FSx::Snapshot
AWS::FSx::StorageVirtualMachine
AWS::FSx::Volume
AWS::Glue::Classifier
AWS::Glue::Connection
AWS::Glue::Crawler
AWS::Glue::CustomEntityType
AWS::Glue::Database
AWS::Glue::DataCatalogEncryptionSettings
AWS::Glue::DataQualityRuleset
AWS::Glue::DevEndpoint
AWS::Glue::Job
AWS::Glue::MLTransform
AWS::Glue::Partition
AWS::Glue::SecurityConfiguration
AWS::Glue::Table
AWS::Glue::TableOptimizer
AWS::Glue::Trigger
AWS::Glue::Workflow
AWS::Greengrass::ConnectorDefinition
AWS::Greengrass::ConnectorDefinitionVersion
AWS::Greengrass::CoreDefinition
AWS::Greengrass::CoreDefinitionVersion
AWS::Greengrass::DeviceDefinition
AWS::Greengrass::DeviceDefinitionVersion
AWS::Greengrass::FunctionDefinition
AWS::Greengrass::FunctionDefinitionVersion
AWS::Greengrass::Group
AWS::Greengrass::GroupVersion
AWS::Greengrass::LoggerDefinition
AWS::Greengrass::LoggerDefinitionVersion
AWS::Greengrass::ResourceDefinition
AWS::Greengrass::ResourceDefinitionVersion
AWS::Greengrass::SubscriptionDefinition
AWS::Greengrass::SubscriptionDefinitionVersion
AWS::IAM::AccessKey
AWS::IAM::UserToGroupAddition
AWS::IoT::PolicyPrincipalAttachment
AWS::IoT::ThingPrincipalAttachment
AWS::IoT1Click::Device
AWS::IoT1Click::Placement
AWS::IoT1Click::Project
AWS::IoTThingsGraph::FlowTemplate
AWS::Kinesis::StreamConsumer
AWS::KinesisAnalytics::Application
AWS::KinesisAnalytics::ApplicationOutput
AWS::KinesisAnalytics::ApplicationReferenceDataSource
AWS::KinesisAnalyticsV2::ApplicationCloudWatchLoggingOption
AWS::KinesisAnalyticsV2::ApplicationOutput
AWS::KinesisAnalyticsV2::ApplicationReferenceDataSource
AWS::LakeFormation::DataLakeSettings
AWS::LakeFormation::Permissions
AWS::LakeFormation::Resource
AWS::Lambda::Alias
AWS::ManagedBlockchain::Member
AWS::ManagedBlockchain::Node
AWS::MediaConvert::JobTemplate
AWS::MediaConvert::Preset
AWS::MediaConvert::Queue
AWS::MediaLive::Channel
AWS::MediaLive::Input
AWS::MediaLive::InputSecurityGroup
AWS::MediaStore::Container
AWS::Neptune::DBClusterParameterGroup
AWS::Neptune::DBInstance
AWS::Neptune::DBParameterGroup
AWS::Neptune::DBSubnetGroup
AWS::OpsWorks::App
AWS::OpsWorks::ElasticLoadBalancerAttachment
AWS::OpsWorks::Instance
AWS::OpsWorks::Layer
AWS::OpsWorks::Stack
AWS::OpsWorks::UserProfile
AWS::OpsWorks::Volume
AWS::Pinpoint::ADMChannel
AWS::Pinpoint::APNSChannel
AWS::Pinpoint::APNSSandboxChannel
AWS::Pinpoint::APNSVoipChannel
AWS::Pinpoint::APNSVoipSandboxChannel
AWS::Pinpoint::App
AWS::Pinpoint::ApplicationSettings
AWS::Pinpoint::BaiduChannel
AWS::Pinpoint::Campaign
AWS::Pinpoint::EmailChannel
AWS::Pinpoint::EmailTemplate
AWS::Pinpoint::EventStream
AWS::Pinpoint::GCMChannel
AWS::Pinpoint::PushTemplate
AWS::Pinpoint::Segment
AWS::Pinpoint::SMSChannel
AWS::Pinpoint::SmsTemplate
AWS::Pinpoint::VoiceChannel
AWS::PinpointEmail::ConfigurationSet
AWS::PinpointEmail::ConfigurationSetEventDestination
AWS::PinpointEmail::DedicatedIpPool
AWS::PinpointEmail::Identity
AWS::QLDB::Ledger
AWS::RAM::ResourceShare
AWS::RDS::DBSecurityGroup
AWS::RDS::DBSecurityGroupIngress
AWS::Redshift::ClusterSecurityGroup
AWS::Redshift::ClusterSecurityGroupIngress
AWS::Route53::RecordSet
AWS::Route53::RecordSetGroup
AWS::Route53Resolver::ResolverEndpoint
AWS::SageMaker::CodeRepository
AWS::SageMaker::Endpoint
AWS::SageMaker::EndpointConfig
AWS::SageMaker::Model
AWS::SageMaker::NotebookInstance
AWS::SageMaker::NotebookInstanceLifecycleConfig
AWS::SageMaker::Workteam
AWS::SDB::Domain
AWS::SecretsManager::ResourcePolicy
AWS::SecretsManager::RotationSchedule
AWS::SecretsManager::SecretTargetAttachment
AWS::ServiceCatalog::AcceptedPortfolioShare
AWS::ServiceCatalog::CloudFormationProduct
AWS::ServiceCatalog::LaunchNotificationConstraint
AWS::ServiceCatalog::LaunchRoleConstraint
AWS::ServiceCatalog::LaunchTemplateConstraint
AWS::ServiceCatalog::Portfolio
AWS::ServiceCatalog::PortfolioPrincipalAssociation
AWS::ServiceCatalog::PortfolioProductAssociation
AWS::ServiceCatalog::PortfolioShare
AWS::ServiceCatalog::ResourceUpdateConstraint
AWS::ServiceCatalog::StackSetConstraint
AWS::ServiceCatalog::TagOption
AWS::ServiceCatalog::TagOptionAssociation
AWS::ServiceDiscovery::HttpNamespace
AWS::ServiceDiscovery::Instance
AWS::ServiceDiscovery::PrivateDnsNamespace
AWS::ServiceDiscovery::PublicDnsNamespace
AWS::ServiceDiscovery::Service
AWS::SES::ReceiptFilter
AWS::SES::ReceiptRule
AWS::SES::ReceiptRuleSet
AWS::SNS::Subscription
AWS::SSM::MaintenanceWindow
AWS::SSM::MaintenanceWindowTarget
AWS::SSM::MaintenanceWindowTask
AWS::Transfer::Server
AWS::Transfer::User
AWS::WAF::ByteMatchSet
AWS::WAF::IPSet
AWS::WAF::Rule
AWS::WAF::SizeConstraintSet
AWS::WAF::SqlInjectionMatchSet
AWS::WAF::WebACL
AWS::WAF::XssMatchSet
AWS::WAFRegional::ByteMatchSet
AWS::WAFRegional::GeoMatchSet
AWS::WAFRegional::IPSet
AWS::WAFRegional::RateBasedRule
AWS::WAFRegional::RegexPatternSet
AWS::WAFRegional::Rule
AWS::WAFRegional::SizeConstraintSet
AWS::WAFRegional::SqlInjectionMatchSet
AWS::WAFRegional::WebACL
AWS::WAFRegional::WebACLAssociation
AWS::WAFRegional::XssMatchSet
AWS::WorkSpaces::Workspace

Testing your Infrastructure in CI/CD Pipeline

Yuncheng Yang — Wed, 08 Mar 2023 06:39:25 +0000

Testing Infrastructure ad Code

These days, everyone's using Infrastructure as Code (IaC) to manage their infrastructure.

🛠️ Some popular Infrastructure as Code (IaC) tools include:

Terraform: Open-source IaC tool for managing infrastructure across multiple cloud platforms and providers. Flexible and reliable.
AWS CloudFormation: IaC tool to manage and automate AWS resources. Allows previewing changes before deployment and rolling back infrastructure if needed.
Azure Resource Manager: Robust IaC tool for managing infrastructure using ARM templates. Supports RBAC and provides excellent organization tools.
Google Cloud Deployment Manager: Native infrastructure deployment service for Google Cloud Platform. Uses declarative language and offers built-in console and UI support.
Pulumi: Flexible IaC tool that supports various programming languages. Allows for automation options for deployment delivery, quality assurance, easy auditing, and comprehensive identity control.
Ansible: Red Hat's orchestration and configuration tool that uses YAML-based playbooks to configure infrastructure. Easy to use with robust default configuration and allows for custom modules.

It's great because it's scalable, automated, and ensures consistency across environments.

But when it comes to testing that IaC, a lot of us fall back on the old "deploy and see" method: deploying your infrastructure and then checking to see if it's actually doing what it's supposed to be doing.
It's a time-consuming and error-prone process, and it's not enough to catch all the potential issues. Especially when you're dealing with complex infrastructures with multiple environments.

To make the process more efficient and reliable,** you can create tests for infrastructure that can be run with a CI/CD pipeline.**

Standardize the deployment environment
Automate many of the manual tasks involved in testing and deployment

Use 🌟SQL🌟 with Cloud

If you prefer not to learn and use a domain-specific language to manage resources on the cloud, there are several tools available.

Using SQL also enables the use of relational algebra concepts and operations, such as joins, selections, and projections.

Steampipe: a Postgres-based open-source tool that uses foreign data wrappers and SDK-based provider plugins to query your cloud infrastructure using SQL. Steampipe supports multiple cloud providers, including AWS, Azure, and Google Cloud Platform.
CloudQuery: an open-source tool that collects inventory and configuration data from cloud providers using the provider SDKs. CloudQuery allows you to query your cloud infrastructure using SQL. CloudQuery supports multiple cloud providers, including AWS, Azure, Google Cloud Platform, and Kubernetes.
IaSQL: a Postgres-based tool that allows you to query and provision resources in AWS.
StackQL: an open-source query engine that allows you to query, provision, and interact with cloud and SaaS resources using SQL.
StackQL cloud provider interfaces are extensions of the provider's OpenAPI specification, exposing all operations available in a provider's API using SQL grammar. StackQL's document-based provider definitions make bringing your providers or APIs, and extending to other cloud or SaaS platforms easy.

Testing tools

There are several IaC testing tools available, including Terratest, Kitchen-Terraform, and Chef InSpec.

These tools can help automate the process of testing your infrastructure code and catch issues.

Terratest

Terratest is a Go library that provides patterns and helpers for testing infrastructure.

Terratest allows you to execute your real IaC tools (Terraform, Packer, etc.) to deploy real infrastructure in a real environment.
You can then use the tools built into Terratest to validate that the infrastructure works correctly in that environment by making HTTP requests, API calls, SSH connections, etc. Terratest can undeploy everything at the end of the test.

Here's an example of how to use Terratest to test a Terraform module:

package test

import (
  "fmt"
  "testing"

  "github.com/gruntwork-io/terratest/modules/terraform"
  "github.com/stretchr/testify/assert"
)

func TestTerraformModule(t *testing.T) {
  terraformOptions := &terraform.Options{
    TerraformDir: "../examples/simple",
  }

  defer terraform.Destroy(t, terraformOptions)

  terraform.InitAndApply(t, terraformOptions)

  output := terraform.Output(t, terraformOptions, "output_name")
  assert.Equal(t, "expected_output", output)
}

This test will run Terraform to create the infrastructure, then check that the output matches the expected output.

Chef InSpec

Chef InSpec is an open-source testing and compliance automation framework. It allows you to write tests for your infrastructure code and check that it meets the desired state.

You can use InSpec to test various infrastructure components, such as operating systems, cloud providers, and databases. InSpec can also test compliance with industry standards like PCI DSS, HIPAA, and CIS benchmarks.

Here's an example of how to use Chef InSpec to test a Terraform module:

control "example-control" do
  title "Example Control"
  desc "An example InSpec control"

  describe aws_instance('example-instance') do
    it { should be_running }
    its('instance_type') { should eq 't2.micro' }
  end

  describe aws_security_group('example-security-group') do
    it { should allow_in(port: 22, ipv4_range: '0.0.0.0/0') }
  end
end

This test will check that an AWS EC2 instance named example-instance is running and is of the correct instance type, and that the security group example-security-group allows incoming traffic on port 22 from any IP address.

Kitchen-Terraform

Kitchen-Terraform is a Ruby-based test harness for Terraform modules.

Kitchen-Terraform allows automated testing of Terraform code, including syntax and linting checks.
It can also create and destroy infrastructure in a testing environment and run tests against it. It can be integrated with Chef InSpec to perform additional testing of infrastructure code for a comprehensive testing process.

Here's an example of how to use Kitchen-Terraform to test a Terraform module:

---
driver:
  name: terraform

provisioner:
  name: terraform

verifier:
  name: terraform

platforms:
  - name: terraform

suites:
  - name: default
    verifier:
      rakefile: test/integration/default/default_test.rb

This test will create a Terraform instance and apply the Terraform configuration in the default suite. After that, it will run the tests in default_test.rb, which can include any number of tests.

GitHub Action: stackql-assert

The stackql-assert is a GitHub action that allows you to run a StackQL query with minimal setup.
It is used to test assertions against the results of a StackQL query, which can validate the state of a resource after an IaC or lifecycle operation has been performed, or validate the system (e.g., CSPM or compliance queries).

For example, you can use the stackql-assert action in a Terraform deployment pipeline:

- name: Terraform Apply
        env:
          TF_VAR_google_credentials: ${{ secrets.GOOGLE_CREDS }}
        id: apply
        run: cd terraform; terraform apply -no-color -var-file=stackql-demo.tfvars -auto-approve

- name: check terraform deployment using stackql-assert - should fail
  uses: stackql/stackql-assert@v1.0.2
  with:
    auth_obj_path: './stackql/auth.json'
    test_query_file_path: './stackql/scripts/check-terraform-instances.iql'
    expected_results_str: '[{"name":"terraform-test-1","name":"terraform-test-2"}]'

This example run a StackQL SELECT query and compare the actual result with an expected result after a Terraform deployment.
This can test specific configuration properties of the resource (for compliance or policy enforcement) or just the existence of the resource.

Reference

https://bluelight.co/blog/best-infrastructure-as-code-tools#what-are-the-best-infrastructure-as-code-tools-for-2022

https://qxf2.com/blog/testing-infrastructure-as-code-beginner/

AWS Provider for StackQL Released

Jeffrey Aven — Tue, 20 Sep 2022 02:09:02 +0000

StackQL AWS provider is available now!

StackQL allows users to query, report, analyze, provision, and operate cloud and SaaS resources using a simple SQL-based framework

With StackQL and the AWS provider, you can run queries like...

SELECT instanceType, COUNT(*) as num_instances
FROM aws.ec2.instances
WHERE region = 'ap-southeast-2'
GROUP BY instanceType;

and much more, including mutation operations using INSERT and JOIN operations (within a provider or across different providers).

Provider docs available here, also check out this blog article.

Other providers are available for Azure, GCP, GitHub, Kubernetes, Okta, Netlify and Firebase

StackQL provider for Azure is now available

Jeffrey Aven — Wed, 31 Aug 2022 22:11:12 +0000

We have just released the Microsoft Azure provider for StackQL to go along with StackQL providers available for Google, Kubernetes, GitHub, Okta, Netlify, and Firebase, with AWS to follow soon.

The StackQL provider for Azure provides observability across the Azure estate for CSPM, asset management, finops, and more, in addition to IaC, config management, and ops (lifecycle management) functionality.

The StackQL azure provider exposes 230 services, 2,450 resources (of which 1,985 or 81% are available using SELECT statements), and 10,140 methods.

The StackQL Azure provider was created using the Autorest project using Azure specification docs from the azure-rest-api-specs repository. We will be adding integrated interactive authentication; for now, this is cli/sdk based; you can find all the documentation here.

We are looking for Azure enthusiasts to road-test it! Reach out here if you are interested.

StackQL is on dev.to

Jeffrey Aven — Wed, 31 Aug 2022 21:58:09 +0000

It was on the TODO list for some time now but were finally here!

Our project stackql uses OpenAPI definition documents from cloud and SaaS providers to enable developers and analysts to query and interact with cloud resources using SQL. Use cases include CSPM, asset inventory and analysis, finops, and general cloud/SaaS estate observability using SELECT statements. The product also exposes IaC and config management operations using DML grammar (INSERT, etc), and lifecycle operations (like starting and stopping instances) using an EXEC statement.

StackQL can operate as a client or a server using the Postgres wire protocol (it does not require or implement a Postgres database, however) and is designed to integrate with reporting and BI systems as a data source. We also have full support for JOIN statements including cross-provider joins.

With our low code approach to provider plugin development (extensions to the provider's OpenAPI specs) we welcome developers to connect and contribute to existing providers or create new ones for your desired cloud (including public and private) or SaaS provider.

We have existing blog properties, including stackql.io/blog and fullstackchronicles.io, if you want to get up to speed with our journey.

Please reach out here or via GitHub if you want to know more.