table DM_AUTH_MERGED_DATA
	lineageTag: 12e68118-e97c-4313-9f17-061993fdaf9d

	column sub_code
		dataType: string
		lineageTag: 4172b48e-71aa-4978-96bd-ed5f1c9bc924
		summarizeBy: none
		sourceColumn: sub_code

		annotation SummarizationSetBy = Automatic

	column parent_code
		dataType: string
		lineageTag: 3443e253-7106-41b3-a75f-2ed9346af9c9
		summarizeBy: none
		sourceColumn: parent_code

		annotation SummarizationSetBy = Automatic

	column role
		dataType: string
		lineageTag: 406627db-aa0d-4668-99e5-b890e7e61186
		summarizeBy: none
		sourceColumn: role

		annotation SummarizationSetBy = Automatic

	partition DM_AUTH_MERGED_DATA = m
		mode: import
		queryGroup: EXTERNAL_权限表
		source = ```
				let
				    Source = 
				Value.NativeQuery(
				        Databricks.Catalogs(
				            ServerAddress, HttpPath, [
				                Catalog = CatalogName,
				                Database = null,
				                EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
				            ]
				        ){
				            [Name = CatalogName, Kind = "Database"]
				        }[Data],
				    "
				    with tmp_c_trtry (
				  select 
				    mr_kcode,mr_name,mr_trty_code,
				    dsm_kcode,dsm_name,dsm_trty_code,
				    rsm_kcode,rsm_name,rsm_trty_code,
				    rsd_kcode,rsd_name,rsd_trty_code,
				    nsd_kcode,nsd_name,nsd_trty_code,
				    bu_code,bu_name_en,sub_bu_code,sub_bu_name_en
				  from dm.dm_td_org
				  where yyyymm in ( select key_value from dm.dm_td_date_config where key_code = 'pfmc_cvh' )
				    and mr_trty_code <> ''
				  group by 
				    mr_kcode,mr_name,mr_trty_code,
				    dsm_kcode,dsm_name,dsm_trty_code,
				    rsm_kcode,rsm_name,rsm_trty_code,
				    rsd_kcode,rsd_name,rsd_trty_code,
				    nsd_kcode,nsd_name,nsd_trty_code,
				    bu_code,bu_name_en,sub_bu_code,sub_bu_name_en
				  )
				-- dsm
				select distinct
				  dsm_kcode sub_code
				  ,rsm_kcode parent_code
				  ,'dsm' role
				from tmp_c_trtry
				union all 
				-- rsm
				select distinct
				  rsm_kcode sub_code
				  ,rsd_kcode parent_code
				  ,'rsm' role
				from tmp_c_trtry
				union all 
				-- rsd
				select distinct
				  rsd_kcode sub_code
				  ,nsd_kcode parent_code
				  ,'rsd' role
				from tmp_c_trtry
				union all 
				-- nsd
				select distinct
				  nsd_kcode sub_code
				  ,sub_bu_name_en parent_code
				  ,'nsd' role
				from tmp_c_trtry"
				      & UsingLimit,
				        null,
				        [
				            EnableFolding = true
				        ]
				    )
				in
				    Source
				```

	annotation PBI_NavigationStepName = 导航

	annotation PBI_ResultType = Exception