Data Federation

Domo feature - Data warehouse menu federated

Simplify and streamline storage logistics.

Domo’s federated data model allows you to use data from your existing data lakes and data warehouses without duplicating it in Domo, enabling faster implementation and lower maintenance and overhead costs.

Data federation is supported with several leading cloud data warehouses.

amazon redshift crossdata data io memsql microsoft sequel server MySQL snowflake teradata

Optimize your infrastructure investments.

Make the most of your existing data warehouse investments with federated query capabilities included as a standard part of the Domo platform.

Product featured federated chart A Product feature federated chart B Product feature federated chart B mobile

Avoid redundant data copies.

Simplify storage logistics and avoid duplication with federated queries that create a high-speed cached version of the detailed raw data in your data lake.

Pull only the data you need from your data lake, and no more.

Queries are sent directly to your data lake and translated from Domo query language to the SQL format of your current database technology.

Control and protect your data.

Maintain control by defining the time to live for the cache and granting access only to approved database tables.

Integrate Domo with your SSO provider so that data can be filtered based on user details defined by your SSO provider.

Protect data in all stages of its lifecycle with encryption in transit and at rest.

Use your firewalls to control all inbound and outbound traffic in-transit.

Keep response times quick.

A persistent socket connection minimizes traffic and helps avoid latency issues.

Automatic load balancing toward the client-side agents with the most capacity ensures fast performance.

Use Domo as a rapid prototyping data mart.

As you build your own data lake, use Domo as a flexible data mart to help you test what is useful enough to include in your data lake and help define prioritization.


"Chief Digital Officer tracked 20k+ data sources in real time to see performance across digital media for real-time decisions on where to spend, contributing to $2.1B in ecommerce revenue in 2017."

Global 500 Retailer

Ready to get started?
Try Domo now or watch a demo.