How to convert entity_id to notebook name or job
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2023 04:03 AM
Hi, Databricks developers!
I use system.access.table_lineage refering to this page.
It's difficult for us to recognize which notebook was indicated by the entity_id.
How do I get the table to convert entity_ids to Job names or Notebook names?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2023 04:46 AM - edited 12-14-2023 04:47 AM
Hi Ken2
We are still missing the related table to do these lookups ( Workflow/jobs are coming soon )
You can still do these lookups by
1. looking up the relevant URL :
- For a JOB : entity_id = job_id
=> https://{workspace_uRL}/?o={workspace_ID}#job/{job_id/entity_id} - For a notebook : entity_id = notebook id
=> https://{workspace_url}/?o={workspace_id}#notebook/{entity_id/notebooks_id}
2. Look-up the job via the UI OR the Jobs API
For a JOB : entity_id = job_id
So : for a job owned by me looked up in the lineage table
I can find it in the workflows UI
or via the API :
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-14-2023 07:06 PM - edited 12-14-2023 07:09 PM
@mlamairesse
Thank you so much for a very understandable answer!
I'd like to create a list of the linages in a workspace by system tables, at that time I have to convert event id to job id to understands the relations.
I hope someday Databricks provides a feature to lookup the workflow or notebook names via other system tables.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2023 01:52 AM
Workflows system tables are coming very soon. 😃