# How do I create a derived view in Connect Cloud?

**URL:** <https://community.cdata.com/t/how-do-i-create-a-derived-view-in-connect-cloud/113>\
**Category:** CData Connect Cloud\
**Tags:** question, feature, cloud\
**Created:** [March 28, 2023, 5:57pm UTC](https://community.cdata.com/t/how-do-i-create-a-derived-view-in-connect-cloud/113 "2023-03-28T17:57:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lori](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/lori/32/1929_2.png) [@Lori](https://community.cdata.com/u/Lori)\
**Post date:** [March 28, 2023, 5:57pm UTC](https://community.cdata.com/t/how-do-i-create-a-derived-view-in-connect-cloud/113/1 "2023-03-28T17:57:40Z")

</div>

I often need to query on the same data for reporting. I heard that derived views can help me save a columnar view that contains the filtered tables and fields&nbsp;so I don’t have to build it everytime I need the information. How do I create a derived view?

---

<div class="post-metadata">

**Author:** ![Lori](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/lori/32/1929_2.png) [@Lori](https://community.cdata.com/u/Lori)\
**Post date:** [March 28, 2023, 6:20pm UTC](https://community.cdata.com/t/how-do-i-create-a-derived-view-in-connect-cloud/113/2 "2023-03-28T18:20:30Z")

</div>

Found this great article that shares step-by-step instructions for creating a derived view. The article also includes how to setup a Federated Query. For those who do not know what a Federated Query is, in simple 101 terms. Federated Query is a feature that enables you to query live data from multiple sources. It is definitely a game changer and you should check it out when you have time.&nbsp;[https://www.cdata.com/kb/articles/connect-derived-views-query-federation.rst](https://www.cdata.com/kb/articles/connect-derived-views-query-federation.rst)