https://community.databricks.com/t5/data-governance/enable-lineage-data-system-tables/m-p/39916#M1148 <P>Execute the below Python code in your <STRONG>databricks</STRONG> workspace to enable lineage system tables</P><P>&nbsp;</P><LI-CODE lang="python">import requests ctx = dbutils.notebook.entry_point.getDbutils().notebook().getContext() api_url = ctx.tags().get("browserHostName").get() api_token = ctx.apiToken().get() headers = {'Authorization': f'Bearer {api_token}'} account_id = ctx.tags().get("accountId").get() # get metastore id url = f'https://{api_url}/api/2.1/unity-catalog/metastores' metastore_id = requests.get(url, headers=headers).json()['metastores'][0]['metastore_id'] # enable lineage tables url = f'https://{api_url}/api/2.0/unity-catalog/metastores/{metastore_id}/systemschemas/access' requests.put(url, headers=headers)</LI-CODE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ezgif-1-9a34272eba.gif" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/3129i3151AC6545BA70E7/image-size/large?v=v2&amp;px=999" role="button" title="ezgif-1-9a34272eba.gif" alt="ezgif-1-9a34272eba.gif" /></span></P> Tue, 15 Aug 2023 10:27:53 GMT Hubert-Dudek 2023-08-15T10:27:53Z https://community.databricks.com/t5/data-governance/enable-lineage-data-system-tables/m-p/39916#M1148 <P>Execute the below Python code in your <STRONG>databricks</STRONG> workspace to enable lineage system tables</P><P>&nbsp;</P><LI-CODE lang="python">import requests ctx = dbutils.notebook.entry_point.getDbutils().notebook().getContext() api_url = ctx.tags().get("browserHostName").get() api_token = ctx.apiToken().get() headers = {'Authorization': f'Bearer {api_token}'} account_id = ctx.tags().get("accountId").get() # get metastore id url = f'https://{api_url}/api/2.1/unity-catalog/metastores' metastore_id = requests.get(url, headers=headers).json()['metastores'][0]['metastore_id'] # enable lineage tables url = f'https://{api_url}/api/2.0/unity-catalog/metastores/{metastore_id}/systemschemas/access' requests.put(url, headers=headers)</LI-CODE><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ezgif-1-9a34272eba.gif" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/3129i3151AC6545BA70E7/image-size/large?v=v2&amp;px=999" role="button" title="ezgif-1-9a34272eba.gif" alt="ezgif-1-9a34272eba.gif" /></span></P> Tue, 15 Aug 2023 10:27:53 GMT https://community.databricks.com/t5/data-governance/enable-lineage-data-system-tables/m-p/39916#M1148 Hubert-Dudek 2023-08-15T10:27:53Z https://community.databricks.com/t5/data-governance/enable-lineage-data-system-tables/m-p/56953#M1538 <P>Great, I wondered why I didn't see them <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span></P> Thu, 11 Jan 2024 15:39:11 GMT https://community.databricks.com/t5/data-governance/enable-lineage-data-system-tables/m-p/56953#M1538 iplantevin 2024-01-11T15:39:11Z