topic Re: List of Databricks tables created by a user in Data Engineering

List of Databricks tables created by a user

Arun_Kumar — Thu, 01 Dec 2022 09:50:45 GMT

Hi team,

Could you please confirm below clarifications

1. How can we get the list of tables created by a user in particular workspace?

2. How can we get the list of tables created by user from multiple workspaces? ( Same user has access to 10 workspaces under one account and that user created different tables in different workspaces)

Re: List of Databricks tables created by a user

apingle — Thu, 01 Dec 2022 11:01:58 GMT

If you're using Unity Catalog, you can query the information_schema.tables table in the catalog and you can find which tables were created by which user.

If you're not using UC, you can iterate over the tables, run a DESCRIBE HISTORY <table_name> command on the table and check the username at version 0. But I doubt that you would still have that version in your log because by default, the logs over 30 days are deleted.

Re: List of Databricks tables created by a user

Arun_Kumar — Thu, 01 Dec 2022 13:47:00 GMT

Thanks for the information.

Will we be able to access tables across multiple workspaces?

Re: List of Databricks tables created by a user

User16752239289 — Thu, 26 Jan 2023 18:23:58 GMT

For unity catalog, you can set up metastore per-regions, then all workspace in the region should share same table and views : https://docs.databricks.com/data-governance/unity-catalog/index.html#how-do-i-set-up-unity-catalog-for-my-organization

For legacy hive meastore tables or views, you can still share same table or views on different workspace when they configured with same external hive metastore.

Re: List of Databricks tables created by a user

ashish1 — Mon, 30 Jan 2023 21:26:46 GMT

Hi Arun, hope your query is answered. Please select the best answer or let us know if any further questions.