ssas.model_json_10 - V

type: V ( view ), modify_date: 2021-09-01 12:43:15

RepoObject_guid: EF5FD8EE-E90A-EC11-8516-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.model_json_10

Columns

Table 1. Columns of ssas.model_json_10 - V
PK Column Name Data Type NULL? ID

nvarchar(128)

NOT NULL

int

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_10

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_10

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_10

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_10

Column Reference Diagram

entity_1_1_colref-ssas.model_json_10

Indexes

idx_model_json_10__1

Column Details

_

databasename

databasename

nvarchar(128)

NOT NULL

Referenced Columns
Referencing Columns

l1_compatibilityLevel

l1_compatibilityLevel

int

NULL

l1_id

l1_id

nvarchar(500)

NULL

Referencing Columns

l1_model_j

l1_model_j

nvarchar(max)

NULL

l1_name

l1_name

nvarchar(500)

NULL

Referencing Columns

sql_modules_definition

ssas.model_json_10 - V script
/*
Select
    Distinct
    j2.[Key]
  , j2.Type
From
    ssas.model_json As T1
    Cross Apply OpenJson ( T1.model_json )
                --As j1
                --Cross Apply OpenJson ( j1.Value )
                       As j2
order by j2.[Key]
Go
*/
CREATE View ssas.model_json_10
As
Select
    T1.databasename
  , j2.l1_name
  , j2.l1_compatibilityLevel
  , j2.l1_id
  , j2.l1_model_j
From
    ssas.model_json As T1
    Cross Apply
    OpenJson ( T1.model_utf8 Collate Database_Default )
    With
    (
        l1_name NVarchar ( 500 ) N'$.name'
      , l1_compatibilityLevel Int N'$.compatibilityLevel'
      , l1_id NVarchar ( 500 ) N'$.id'
      , l1_model_j NVarchar ( Max ) N'$.model' As Json
    )               As j2
Where
    T1.isModelJson = 1