Home > Workload Solutions > Data Analytics > Guides > Enable Hybrid Analytics with Dell ECS and Snowflake > Use case 2: SQL query
The following SQL query is used to access data residing in Dell ECS and within a Snowflake Database to visualize the combined sources in Power BI dashboard. Federated queries enable business users, data scientists, and data analysts to run queries across distributed data stores. A user can submit a SQL query that is executed across multiple data sources in place for a holistic view of their data.
Select * from snowflake_sample_data.tpch_sf10.lineitem as t1, ext_nyc_tripdata as t2 where t2.VENDORID=t1.L_ORDERKEY;