table Dim_Original_Col_AIA lineageTag: 10007bd6-7a54-472a-a9a2-6945502e4804 column PACK_COD dataType: string lineageTag: 9b37b7dc-6b84-472e-9fde-ce27bd739908 summarizeBy: none sourceColumn: PACK_COD annotation SummarizationSetBy = Automatic column DATA_SOURCE dataType: string lineageTag: 2f3635e3-2c32-42fe-ba01-565e20b04bf3 summarizeBy: none sourceColumn: DATA_SOURCE annotation SummarizationSetBy = Automatic column ATC1 dataType: string lineageTag: 0b497f96-c256-453e-a981-f23b3181dec1 summarizeBy: none sourceColumn: ATC1 annotation SummarizationSetBy = Automatic column ATC2 dataType: string lineageTag: 73ac02c3-3726-4d50-86dd-2e5d98310f9c summarizeBy: none sourceColumn: ATC2 annotation SummarizationSetBy = Automatic column ATC3 dataType: string lineageTag: 77203747-dd6f-47ad-af34-1171b85949c9 summarizeBy: none sourceColumn: ATC3 annotation SummarizationSetBy = Automatic column ATC4 dataType: string lineageTag: 3f99d6ad-f2a1-44a4-b854-138e4f2661ad summarizeBy: none sourceColumn: ATC4 annotation SummarizationSetBy = Automatic column org_prd_cd dataType: string lineageTag: ea0f3cce-57dd-4d6d-b22f-2fd03ebc68ba summarizeBy: none sourceColumn: org_prd_cd annotation SummarizationSetBy = Automatic column org_mole_nm_c dataType: string lineageTag: 90d2ad6a-314b-4527-86a5-a6f18fd1ffbd summarizeBy: none sourceColumn: org_mole_nm_c annotation SummarizationSetBy = Automatic column org_manu_prd_nm_c dataType: string lineageTag: 827221d3-e825-4620-9846-8fc64cbc5d73 summarizeBy: none sourceColumn: org_manu_prd_nm_c annotation SummarizationSetBy = Automatic column org_prd_nm_c dataType: string lineageTag: 5a67b69a-e485-450c-8849-8baa1c9af57f summarizeBy: none sourceColumn: org_prd_nm_c annotation SummarizationSetBy = Automatic column org_pk dataType: string lineageTag: 3940ddff-b49f-4799-a585-302eb80b5dbf summarizeBy: none sourceColumn: org_pk annotation SummarizationSetBy = Automatic column org_prd_str dataType: string lineageTag: d8935814-aa88-4894-b574-355972a85488 summarizeBy: none sourceColumn: org_prd_str annotation SummarizationSetBy = Automatic column org_pth dataType: string lineageTag: bf06afdc-ae92-4a2a-9e6f-8ec369f0f188 summarizeBy: none sourceColumn: org_pth annotation SummarizationSetBy = Automatic column min_pk_unit dataType: string lineageTag: e1126e1f-e911-4f6e-9ca9-1878b85154ba summarizeBy: none sourceColumn: min_pk_unit annotation SummarizationSetBy = Automatic column org_pk_unit dataType: string lineageTag: a3bc3010-dc9e-4f9b-a7c2-e8c40b3d2722 summarizeBy: none sourceColumn: org_pk_unit annotation SummarizationSetBy = Automatic column org_manu_nm dataType: string lineageTag: 975eb300-f50c-4938-91dd-a872693ce429 summarizeBy: none sourceColumn: org_manu_nm annotation SummarizationSetBy = Automatic column PACK_SOURCE = ``` [PACK_COD] & [DATA_SOURCE] ``` lineageTag: e9af8c18-8173-4ec0-8c97-b19ca8df7822 summarizeBy: none annotation SummarizationSetBy = Automatic partition Dim_Original_Col_AIA = m mode: import queryGroup: 'AIA 独有表' source = ``` let Source = Value.NativeQuery( Databricks.Catalogs( ServerAddress, HttpPath, [ Catalog = CatalogName, Database = null, EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0" ] ){ [Name = CatalogName, Kind = "Database"] }[Data], " SELECT PACK_COD, DATA_SOURCE, ATC1, ATC2, ATC3, ATC4, org_prd_cd, org_mole_nm_c, org_manu_prd_nm_c, org_prd_nm_c, org_pk, org_prd_str, org_pth, min_pk_unit, org_pk_unit, org_manu_nm FROM DM.dm_td_aia_original_col " & UsingLimit, null, [ EnableFolding = true ] ) in Source ``` annotation PBI_ResultType = Table annotation PBI_NavigationStepName = Navigation