table DM_AUTH_EMAIL_NOTIFICATION
	lineageTag: f726acdb-befe-4e7b-b032-36acebc03ef9

	column Kcode
		dataType: string
		lineageTag: 5d38c887-d326-4911-a2d1-efee0ff0e1af
		summarizeBy: none
		sourceColumn: Kcode

		annotation SummarizationSetBy = Automatic

	partition DM_AUTH_EMAIL_NOTIFICATION = 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 Kcode
				from dm.dm_tf_powerinsight_chart_rules
				where ChartId in ('ef790b8b-b344-4b48-96a7-11998227ff12', '9797906f-7f66-4b3b-8c26-86487cd1b854')
				and Rule NOT in ( 'PI_SALES','PI_SALES_DSM')
				group by 1
				"
				      & UsingLimit,
				        null,
				        [
				            EnableFolding = true
				        ]
				    )
				    in
				    Source
				```

	annotation PBI_NavigationStepName = Navigation

	annotation PBI_ResultType = Table