96 lines
2.0 KiB
Plaintext
96 lines
2.0 KiB
Plaintext
table DM_AUTH_SALES_TA
|
|
lineageTag: 06a32249-cbac-411b-b4c0-9993c673282a
|
|
|
|
column USER_KCODE
|
|
dataType: string
|
|
lineageTag: 7ca247c5-457b-49dd-90e3-745e32a0885c
|
|
summarizeBy: none
|
|
sourceColumn: USER_KCODE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column TA
|
|
dataType: string
|
|
lineageTag: d5eb5cc4-ba2f-47b2-acfb-9e1245d01470
|
|
summarizeBy: none
|
|
sourceColumn: TA
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column DATA_SOURCE
|
|
dataType: string
|
|
lineageTag: e4988fcf-d2f0-4c1b-b75b-4ccd93588050
|
|
summarizeBy: none
|
|
sourceColumn: DATA_SOURCE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column TA_SOURCE
|
|
dataType: string
|
|
lineageTag: 80423edc-c0de-49db-87f0-053daad33ace
|
|
summarizeBy: none
|
|
sourceColumn: TA_SOURCE
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition DM_AUTH_SALES_TA = m
|
|
mode: import
|
|
queryGroup: OLD\EXTERNAL_权限表
|
|
source = ```
|
|
let
|
|
Source =
|
|
Value.NativeQuery(
|
|
Databricks.Catalogs(
|
|
ServerAddress, HttpPath, [
|
|
Catalog = CatalogName,
|
|
Database = null,
|
|
EnableAutomaticProxyDiscovery = null,EnableQueryResultDownload="0"
|
|
]
|
|
){
|
|
[Name = CatalogName, Kind = "Database"]
|
|
}[Data],
|
|
"
|
|
WITH
|
|
TEMP_TABLE AS (
|
|
SELECT
|
|
USER_KCODE,
|
|
TA,
|
|
DATA_SOURCE,
|
|
TA_SOURCE
|
|
FROM
|
|
dm.dm_auth_sales_ta
|
|
WHERE USER_KCODE is not null and TA is NOT NULL
|
|
)
|
|
SELECT
|
|
*
|
|
FROM
|
|
TEMP_TABLE
|
|
UNION ALL
|
|
SELECT
|
|
USER_KCODE,
|
|
'ALL' TA,
|
|
DATA_SOURCE,
|
|
concat ('ALL', DATA_SOURCE) TA_SOURCE
|
|
FROM
|
|
TEMP_TABLE
|
|
GROUP BY
|
|
USER_KCODE,
|
|
DATA_SOURCE
|
|
"
|
|
& UsingLimit,
|
|
null,
|
|
[
|
|
EnableFolding = true
|
|
]
|
|
)
|
|
in
|
|
Source
|
|
```
|
|
|
|
annotation PBI_NavigationStepName = 导航
|
|
|
|
annotation PBI_ResultType = Exception
|
|
|
|
annotation TabularEditor_TableGroup = 06_AuthTable
|
|
|