70 lines
1.5 KiB
Plaintext
70 lines
1.5 KiB
Plaintext
table 'analytics forecast_scenarios'
|
|
|
|
column scenario_id
|
|
dataType: int64
|
|
formatString: 0
|
|
summarizeBy: none
|
|
sourceColumn: scenario_id
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column name
|
|
dataType: string
|
|
summarizeBy: none
|
|
sourceColumn: name
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column description
|
|
dataType: string
|
|
summarizeBy: none
|
|
sourceColumn: description
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column created_at
|
|
dataType: dateTime
|
|
formatString: General Date
|
|
summarizeBy: none
|
|
sourceColumn: created_at
|
|
|
|
variation Изменение
|
|
isDefault
|
|
relationship: f0a81b20-b81c-4f65-b1a2-44940e80218c
|
|
defaultHierarchy: LocalDateTable_a1ea6953-1d69-4540-a3ab-b29c1d3c0a60.'Иерархия дат'
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column created_by
|
|
dataType: string
|
|
summarizeBy: none
|
|
sourceColumn: created_by
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column params_json
|
|
dataType: string
|
|
summarizeBy: none
|
|
sourceColumn: params_json
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
column active
|
|
dataType: boolean
|
|
formatString: """TRUE"";""TRUE"";""FALSE"""
|
|
summarizeBy: none
|
|
sourceColumn: active
|
|
|
|
annotation SummarizationSetBy = Automatic
|
|
|
|
partition 'analytics forecast_scenarios' = m
|
|
mode: import
|
|
source =
|
|
let
|
|
Источник = Sql.Databases("prdsql"),
|
|
mag_pbi = Источник{[Name="mag_pbi"]}[Data],
|
|
analytics_forecast_scenarios = mag_pbi{[Schema="analytics",Item="forecast_scenarios"]}[Data]
|
|
in
|
|
analytics_forecast_scenarios
|
|
|