Question

An analytics engineer at a retail company needs to find whether a curated 'Customers' table already exists somewhere in the tenant before building a new pipeline that would duplicate the data. Multiple teams manage their own workspaces, and the engineer only has access to a subset of them. What is the most efficient way to discover existing data assets across the organization without requesting access to every workspace first?

Accepted Answer

Browse the OneLake catalog, which surfaces discoverable data items across the tenant and lets the engineer search and request access to matching tables.

Answer

Open each workspace individually and inspect its lakehouse tables in the SQL analytics endpoint.

Answer

Create a shortcut to every lakehouse in the tenant and query the metadata tables through T-SQL.

Answer

Use the Real-Time hub to stream table schemas from all eventstreams into a central eventhouse.