64 lines
1.6 KiB
Plaintext
64 lines
1.6 KiB
Plaintext
table Dim_IsEagle_AIASpecial
|
|
lineageTag: c34d37c1-0fa9-4028-b722-cc5f40d5a0c6
|
|
|
|
column IS_EAGLE_FLAG_CODE
|
|
dataType: string
|
|
lineageTag: 44dd3005-dc3e-411d-94a5-1a80078caceb
|
|
summarizeBy: none
|
|
sourceColumn: IS_EAGLE_FLAG_CODE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column is_eagle
|
|
dataType: string
|
|
lineageTag: 4ba13d1a-aae9-442f-b89e-ee8cd2e07faa
|
|
summarizeBy: none
|
|
sourceColumn: is_eagle
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition Dim_IsEagle_AIASpecial = m
|
|
mode: import
|
|
queryGroup: OLD\非首页
|
|
source = ```
|
|
let
|
|
Source =
|
|
Value.NativeQuery(
|
|
Databricks.Catalogs(
|
|
ServerAddress, HttpPath, [
|
|
Catalog = CatalogName,
|
|
Database = null,
|
|
EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
|
|
]
|
|
){
|
|
[Name = CatalogName, Kind = "Database"]
|
|
}[Data],
|
|
"
|
|
select
|
|
CONCAT(AUDIT_COD, MARKET, DATA_SOURCE) AS IS_EAGLE_FLAG_CODE,
|
|
CASE when MARKET = 'ALL Market' and DATA_SOURCE = 'AIA(Monthly)' then ' ' --AIA ALL Market 不用挂eagle flag
|
|
WHEN is_eagle is not null THEN is_eagle
|
|
else ' ' END AS is_eagle
|
|
--is_eagle
|
|
FROM
|
|
dm.dm_td_aia_is_eagle_flag
|
|
group by
|
|
1,2
|
|
"
|
|
& UsingLimit,
|
|
null,
|
|
[
|
|
EnableFolding = true
|
|
]
|
|
)
|
|
in
|
|
Source
|
|
```
|
|
|
|
annotation PBI_NavigationStepName = Navigation
|
|
|
|
annotation PBI_ResultType = Exception
|
|
|
|
annotation TabularEditor_TableGroup = 04_DimTable
|
|
|