What is data virtualization from a Spotlight perspective?
When you connect databases and data warehouses to Spotlight, Spotlight creates a virtual representation of the data assets they contain. Spotlight acts as a live connection to these data assets and does not move or copy the data itself. You can discover, combine, and enrich these virtual assets inside the unified Spotlight interface, then connect to them through you BI tools of choice to perform analysis.
Virtualization has several key advantages.
- BI queries against a virtual dataset inherit any Spotlight data prep done on it, making queries more specific and minimizing data traffic out of your systems.
- Compute is pushed down to your data systems where possible, enabling better optimization and load management.
- Your data systems authenticate users with each Spotlight query, so your existing access control mechanisms retain control over your data.