table Dim_HPFlag
	lineageTag: e281e266-d03f-45f7-9f2f-9ff74984c501

	column DATA_SOURCE
		dataType: string
		lineageTag: 0d3fbc8e-247e-4883-92be-032ddd598960
		summarizeBy: none
		sourceColumn: DATA_SOURCE

		annotation SummarizationSetBy = Automatic

	column AIA_HP_FLAG
		dataType: string
		lineageTag: f012cea6-2199-40c3-98b8-aa2c6a1ca94c
		summarizeBy: none
		sourceColumn: AIA_HP_FLAG

		annotation SummarizationSetBy = Automatic

	column HP_SOURCE = [AIA_HP_FLAG] & [DATA_SOURCE]
		lineageTag: 6c0d0a97-6af0-4dae-8bcc-6a8e097d1651
		summarizeBy: none

		annotation SummarizationSetBy = Automatic

	partition Dim_HPFlag = m
		mode: import
		queryGroup: 非首页
		source = ```
				let
				    Source = 
				Value.NativeQuery(
				        Databricks.Catalogs(
				            ServerAddress, HttpPath, [
				                Catalog = CatalogName,
				                Database = null,
				                EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
				            ]
				        ){
				            [Name = CatalogName, Kind = "Database"]
				        }[Data],
				      "
				      SELECT DISTINCT NVL(B.AIA_HP_FLAG, '') AIA_HP_FLAG, A.DATA_SOURCE 
				        FROM DM.DM_TF_EXTERNAL_SALES A
				        LEFT JOIN dm.dm_aia_hp_flag B 
				        ON A.DATA_SOURCE = B.DATA_SOURCE AND A.inst_code = B.inst_code
				      "
				      & UsingLimit,
				        null,
				        [
				            EnableFolding = true
				        ]
				    )
				    in
				    Source
				```

	annotation PBI_ResultType = Table

	annotation PBI_NavigationStepName = Navigation