The CloudQuery Gandi plugin pulls configuration out of Gandi resources and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v4.7.1
Type
Source
Platforms
Date Published
Loading plugin documentation
CloudQuery's use of cookies
We use tracking cookies to understand how you use the product and help us improve it. Your consent is required before we can enable these cookies. You can opt out via the link in the footer.
kind: source
spec:
name: gandi
path: cloudquery/gandi
registry: cloudquery
version: "v4.7.1"
tables: ["*"]
destinations: ["postgresql"]
# Learn more about the configuration options at https://cql.ink/gandi_source
spec:
# required
api_key: "${GANDI_API_KEY}"
cloudquery needs to be authenticated. An API key is required for authentication. Get your API key from Gandi's Account Settings Page.api_key (string) (required)sharing_id (string) (optional)gandi_debug (bool) (optional) (default: false)endpoint_url (string, optional. Default: https://api.gandi.net)https://api.sandbox.gandi.net/.timeout_secs (integer as seconds) (optional) (default: 300)concurrency (integer) (optional) (default: 1000)scheduler (string, optional, default: dfs)dfs (depth-first search), round-robin, shuffle and shuffle-queue.select fqdn, dates->>'registry_ends_at' as registry_ends_at, date_trunc('day', (dates->>'registry_ends_at')::timestamp - current_timestamp) as days_left from gandi_domains where ((dates->>'registry_ends_at')::timestamp - interval '90 day') < current_timestamp order by 1;
select fqdn, current, nameservers from gandi_domain_live_dns order by 1;
select fqdn, name, ips from gandi_domain_glue_records order by 1, 2;
select d.fqdn from gandi_livedns_domains d left join gandi_livedns_snapshots s on s.fqdn=d.fqdn and s.automatic where s.fqdn is null;
select count(1) as number_of_snapshots, max(created_at) as last_snapshot_at from gandi_livedns_snapshots where fqdn = 'yourdomain.com';