question

sagdec-0788 avatar image
0 Votes"
sagdec-0788 asked PRADEEPCHEEKATLA-MSFT commented

How to get a summary of all the tables registed in Data catalog

Hi everyone,

I am totally new to Data catalog and I am asked to show a summary of all the tables information registered in Data catalog. Is there a easy way to get it rather than using API? If cannot, can you share a short example of how to write the query? Really sorry to ask this question but I am not familiar with the REST API.

Thanks!

azure-data-catalog
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @sagdec-0788,

Welcome to the Microsoft Q&A platform.

Using Portal:

After you've registered a data source, you can discover it by using filtering and search from within the Data Catalog portal.

Reference: How to discover data sources in Azure Data Catalog

Using REST API:

The Data Catalog has a Search query syntax: Search data assets

Data Asset: Provides operations for working with data assets and annotations.


For updated Data Catalog features, please use the new Azure Purview service, which offers unified data governance for your entire data estate.

Hope this helps. Do let us know if you any further queries.


Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.



· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

Thanks for your reply. I can do the filtering and sorting on the data catalog website. Is there a way to export the summary information to excel?

Thanks!

0 Votes 0 ·

Hello @sagdec-0788,

Unfortunately, you cannot export the summary information to excel.

You can Save searches and pin data assets in Azure Data Catalog.

A saved search in Data Catalog is a reusable, per-user search definition. You can define a search, including search terms, tags, and other filters, and then save it. You can re-run the saved search definition later to return any data assets that match its search criteria.


0 Votes 0 ·

Hello @sagdec-0788,
Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·
Show more comments