The Alibaba Cloud source plugin for CloudQuery extracts configuration from the Alibaba Cloud API and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v5.9.31
Type
Source
Platforms
Date Published
Loading plugin documentation
We use tracking cookies to understand how you use the product and help us improve it. Please accept cookies to help us improve. You can always opt out later via the link in the footer.
postgresql destination is not shown here. See our Quickstart if you need help setting up the destination.kind: source
spec:
name: "alicloud"
path: "cloudquery/alicloud"
registry: "cloudquery"
version: "v5.9.31"
tables: ["*"]
destinations: ["postgresql"]
# Learn more about the configuration options at https://cql.ink/alicloud_source
spec:
accounts:
- name: my_account
regions:
- cn-hangzhou
- cn-beijing
- eu-west-1
- us-west-1
# ...
access_key: ${ALICLOUD_ACCESS_KEY}
secret_key: ${ALICLOUD_SECRET_KEY}
# Optional parameters
# concurrency: 50000
# bill_history_months: 12
concurrency (integer, optional, default: 50000):scheduler (string, optional, default: dfs):dfs (depth-first search), round-robin, shuffle and shuffle-queue.accounts (array[object], required):access_key and secret_key are required and can be specified as environment variables, as shown in the example above.name (string, required): A unique name for the account.regions (array[string], required): A list of regions to sync. For example, ["cn-hangzhou", "cn-beijing"].access_key (string, required): A valid access key for the accountsecret_key (string, required): A valid secret key for the account, corresponding to the access keybill_history_months (integer, optional):alicloud_bss_bill and alicloud_bss_bill_overview tables. Defaults to 12.ALICLOUD_ACCESS_KEY - The access key ID.ALICLOUD_SECRET_KEY - The access key secret.access_key: ${ALICLOUD_ACCESS_KEY}
secret_key: ${ALICLOUD_SECRET_KEY}
select
instance_id,
os_name,
region_id,
start_time,
tags
from
alicloud_ecs_instances
where
region_id = 'eu-west-1';
+------------------------+--------------------------------------+-----------+-------------------+---------------+
| instance_id | os_name | region_id | start_time | tags |
|------------------------+--------------------------------------+-----------+-------------------+---------------|
| i-xxxxxxxxxxxxxxxxxxxx | Alibaba Cloud Linux 3.2104 LTS 64位 | eu-west-1 | 2023-01-17T14:40Z | {"Tag": null} |
+------------------------+--------------------------------------+-----------+-------------------+---------------+
select
product_name,
item,
pip_code,
currency,
adjust_amount
from
alicloud_bss_bill_overview;
+------------------------+----------------+----------+----------+---------------+
| product_name | item | pip_code | currency | adjust_amount |
|------------------------+----------------+----------+----------+---------------|
| Object Storage Service | PayAsYouGoBill | oss | USD | 0.0 |
+------------------------+----------------+----------+----------+---------------+
select
account_id,
bucket_name,
object_count,
storage
from
alicloud_oss_bucket_stats;
+------------+-------------+--------------+---------+
| account_id | bucket_name | object_count | storage |
|------------+-------------+--------------+---------|
| test | cq-test | 2 | 29665 |
+------------+-------------+--------------+---------+