Set up process #

Example Configuration #

kind: source
spec:
  name: gandi
  path: cloudquery/gandi
  registry: cloudquery
  version: "v4.6.0"
  tables: ["*"]
  destinations: ["postgresql"]

  # Learn more about the configuration options at https://cql.ink/gandi_source
  spec:
    # required
    api_key: "${GANDI_API_KEY}"

Authentication #

Configuration Reference #

• api_key (string) (required)

  An API key to access Gandi resources. This can be generated from Gandi's Account Settings Page.
• sharing_id (string) (optional)

  This is your Gandi Organization ID if you wish to limit the queries to a specific Gandi org.
• gandi_debug (bool) (optional) (default: false)

  Enables verbose logging of HTTP calls made by the underlying library.
• endpoint_url (string, optional. Default: https://api.gandi.net)

  Endpoint URL to make the API requests to. To use the Gandi Sandbox API endpoint, set this to https://api.sandbox.gandi.net/.
• timeout_secs (integer as seconds) (optional) (default: 300)

  Default timeout for each API request. Defaults to 5 minutes.
• concurrency (integer) (optional) (default: 1000)

  A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.
• scheduler (string, optional, default: dfs)

  The scheduler to use when determining the priority of resources to sync. Supported values are dfs (depth-first search), round-robin, shuffle and shuffle-queue.

  For more information about this, see performance tuning.

Query Examples #

Detect domain registrations that will expire soon #

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;

Get domains in Gandi LiveDNS #

select fqdn, current, nameservers from gandi_domain_live_dns order by 1;

Get a list of glue records #

select fqdn, name, ips from gandi_domain_glue_records order by 1, 2;

Get list of LiveDNS domains which don't have automatic snapshots enabled #

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;

Inspect LiveDNS snapshots for a given domain #

select count(1) as number_of_snapshots, max(created_at) as last_snapshot_at from gandi_livedns_snapshots where fqdn = 'yourdomain.com';