Introducing the Nautobot Source Integration

We've released a new CloudQuery source integration for Nautobot, the network source of truth and DCIM platform. If your team tracks physical infrastructure in Nautobot, you can now sync that data into PostgreSQL, BigQuery, Snowflake, or any other supported destination and query it alongside the rest of your infrastructure inventory.

What Does the Nautobot Integration Sync?

The integration pulls DCIM inventory data from Nautobot's API into seven tables:

• nautobot_devices - network devices with status, serial numbers, and location assignments
• nautobot_locations - sites, buildings, and other physical locations
• nautobot_racks - rack inventory with utilization data
• nautobot_device_types - device models and form factors
• nautobot_manufacturers - hardware manufacturers
• nautobot_interfaces - network interfaces per device
• nautobot_location_types - location hierarchy definitions

Authentication uses a Nautobot API token with read access to DCIM objects. See the integration documentation for configuration details.

Sample Queries

Once your Nautobot data is synced, you can run SQL queries against it. Here are a few to get started.

Devices by Manufacturer and Model

SELECT
    m.name AS manufacturer,
    dt.model,
    dt.u_height,
    dt.device_count
FROM nautobot_device_types dt, nautobot_manufacturers m
WHERE dt.manufacturer->>'id' = m.id
ORDER BY dt.device_count DESC;

Device Count per Location

SELECT
    l.name AS location_name,
    l.description,
    l.device_count,
    l.rack_count
FROM nautobot_locations l
ORDER BY l.device_count DESC;

Interface Summary per Device

SELECT
    i.device->>'id' AS device_id,
    COUNT(*) AS interface_count,
    COUNT(*) FILTER (WHERE i.enabled IS TRUE) AS enabled_count,
    COUNT(*) FILTER (WHERE i.mgmt_only IS TRUE) AS mgmt_count
FROM nautobot_interfaces i
GROUP BY i.device->>'id'
ORDER BY interface_count DESC
LIMIT 20;

Cross-Referencing Nautobot with Cloud Provider Data

The real power of syncing Nautobot data into CloudQuery is joining it with data from other integrations. If you're also syncing AWS data, you can cross-reference your physical DCIM inventory with your cloud resources to get a unified view.

Say you want to find AWS EC2 instances running in regions that correspond to your Nautobot locations - maybe to verify that workloads running on physical devices at a given site have matching cloud resources in the nearest region:

SELECT
    l.name AS nautobot_location,
    l.physical_address,
    d.name AS device_name,
    d.serial AS device_serial,
    i.instance_id AS aws_instance_id,
    i.instance_type AS aws_instance_type,
    i.region AS aws_region
FROM nautobot_locations l
JOIN nautobot_devices d ON d.location->>'id' = l.id
CROSS JOIN aws_ec2_instances i
WHERE l.name ILIKE '%' || i.region || '%'
   OR l.description ILIKE '%' || i.region || '%'
ORDER BY l.name, d.name;

This is a starting point - the exact join logic depends on how your team names locations and maps them to cloud regions. The point is that both datasets live in the same database, so you can correlate them however makes sense for your environment.

Getting Started

1. Head to the Nautobot integration page on CloudQuery Hub
2. Create an API token in your Nautobot instance (User > API Tokens)
3. Configure the integration with your Nautobot host_url and api_token
4. Pick a destination and run your first sync

Frequently Asked Questions

What Is Nautobot?

Nautobot is a network source of truth and DCIM (Data Center Infrastructure Management) platform. Teams use it to track devices, racks, locations, and network interfaces across their physical infrastructure.

What Data Does the CloudQuery Nautobot Integration Sync?

The integration syncs seven tables covering devices, locations, racks, device types, manufacturers, interfaces, and location types. These represent the core DCIM inventory objects from Nautobot's API.

Can I Combine Nautobot Data with Cloud Provider Data?

Yes. Since CloudQuery syncs all data into the same destination database, you can write SQL joins across Nautobot tables and tables from other integrations like AWS, GCP, or Azure. This gives you a single place to query both physical and cloud infrastructure.

What Destinations Are Supported?

Any CloudQuery destination works with the Nautobot integration - PostgreSQL, BigQuery, Snowflake, ClickHouse, S3, and more.

How Do I Authenticate with Nautobot?

The integration uses a Nautobot API token. You can create one in the Nautobot web UI under User > API Tokens, or via the /api/users/tokens/ endpoint. The token needs read access to DCIM objects.

What Version of Nautobot Is Supported?

The integration is at v1.0.0 and works with Nautobot's current API. Check the integration documentation for the latest compatibility details.