The DroneDeploy Data Exchange is a robust data solution designed for advanced enterprise customers who require deep integration of reality capture data into internal business intelligence systems.
While the Analytics Dashboard provides standardized answers regarding your organization's usage, the Data Exchange allows you to access structured data for custom reporting. Use this tool to export raw, schema-based data to your own data warehouse, enabling you to combine DroneDeploy metrics with internal data sources, such as MSFT Active Directory or Asset Management systems.
Availability
Subscriptions: Available for Enterprise customers. Contact your CSM to enable this feature.
Format: Structured data designed for SQL integration (Relational Star Schema).
Data Architecture
The Data Exchange model uses several tables to analyze platform usage. The relational model (Fact and Dimension tables) allows for complex queries across your entire organization.
What types of data are available?
The DroneDeploy data instance includes several tables that you can use to analyze your usage on the platform. Review the complete customer model below.
(Right-click the table + Open the image in a new tab to zoom in):
Activity
This table contains all activities in your organization. This is an aggregated activity table; the activity_count column aggregates the counts of each action. This includes:
Captures: Captures, Processing
Analysis: Annotations, Issue, Live Stream, Overlay, Link Shares
Views: Annotation Views, Map Views, Media Views, Report Views, Link Share Views
Exports
Admin: Folder, Organization actions
In a Kimball/Star schema, this table functions as a Fact table.
Annotation
This table stores user-created annotations such as location, distance, area, surface area, or volume measurements on a Plan.
Export
This table provides a record of all files and their formats sent using the Export function within the DroneDeploy application, including auto-exports.
Table of Definitions
Folder
A folder contains zero or more projects or sub-folders to organize data in DroneDeploy into groups or locations.
Issue
This table contains a log of all user-created issues on images, 3D models, maps, panoramas, or walkthroughs. You can assign priority and users to specific projects through issues.
Location
This allows users to organize data across DroneDeploy plans and maps within a project.
Location-Plan Relation
This table allows users to connect data in locations across DroneDeploy maps and plans. Much like Levels, Locations persist across all maps/plans in a Project. Because a many-to-many relationship exists between Plan and Location, this table bridges the two together for easier navigation.
Overlay
This table tracks CAD design surfaces, shapefiles, DXFs, GeoTIFFs, and other imagery uploaded or imported via integrations (such as Procore or BIM 360) to aid in analysis.
Flight Record
This table contains flight-specific information such as aircraft model, duration, maximum speed, and altitude.
Plan
The Plan object is the core object that holds the drone/robot path and the resulting data (map, 3D model, walkthrough, panorama, etc.). This remains the central object even if you upload data directly to the Map Engine via the UI or API without executing a flight plan.
Table of Definitions
Project
A Project refers to an individual site or location.
User
This table lists all users and their default roles, both internal and external.
User Group
This table contains custom groupings designated by the organization. Users can belong to multiple groups.
What types of questions can be answered with the data?
The Data Exchange provides the information needed to answer questions such as:
When was the first and last activity date for my organization?
How often are my pilots capturing each month?
How many external users are in my organization?
What is the capture rate for each group within my organization?
How many active projects did my organization have this month?
What are my most viewed projects and where are they located?
The primary value comes from joining DroneDeploy data with your organization’s internal data to answer advanced questions:
What level of drone usage has Department X (as defined in MSFT Active Directory) performed to date?
What is the latest reality capture data for Asset ID 1234 located at X,Y?
FAQs
Q: How is this different from the GraphQL API? A: While our GraphQL API is ideal for automating workflows and querying individual objects (No-SQL), the Data Exchange is designed to pull bulk data for all objects into your data warehouse for SQL integration.
Q: How do I get access to the Data Exchange? A: For more information or to enable this feature, please contact your Customer Success Manager or Account Executive.
v2.2