List of Databricks tables created by a user
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2022 01:50 AM
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2022 03:01 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2022 05:47 AM
Thanks for the information.
Will we be able to access tables across multiple workspaces?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2023 10:23 AM
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-f...
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2023 01:26 PM
Hi Arun, hope your query is answered. Please select the best answer or let us know if any further questions.

