List of Databricks tables created by a user

[Arun_Kumar]

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)

[apingle]

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.

[Arun_Kumar]

Thanks for the information.

Will we be able to ​access tables across multiple workspaces?

[User16752239289]

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.

[ashish1]

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