ssas.model_json_331_dataSources_annotations - V

/*
--get and check existing values

Select
    Distinct
    j2.[Key]
  , j2.Type
From
    ssas.model_json_33_dataSources                         As T1
    Cross Apply OpenJson ( T1.dataSources_annotations_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
order by
    j2.[Key]
  , j2.Type
Go

Select
    T1.*
  , j2.*
From
    ssas.model_json_33_dataSources                         As T1
    Cross Apply OpenJson ( T1.dataSources_annotations_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
Go

Select
    DISTINCT
    j2.*
From
    ssas.model_json_33_dataSources                         As T1
    Cross Apply OpenJson ( T1.dataSources_annotations_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
Where
    j2.[Key] = 'value'
GO
*/
CREATE View ssas.model_json_331_dataSources_annotations
As
Select
    T1.databasename
  , T1.dataSources_name
  , j2.dataSources_annotations_name
  , j2.dataSources_annotations_value
  , j2.dataSources_annotations_value_ja
From
    ssas.model_json_33_dataSources                         As T1
    Cross Apply OpenJson ( T1.dataSources_annotations_ja ) As j1
    Cross Apply
    OpenJson ( j1.Value )
    With
    (
        dataSources_annotations_name NVarchar ( 500 ) N'$.name'
      , dataSources_annotations_value NVarchar ( Max ) N'$.value'
      , dataSources_annotations_value_ja NVarchar ( Max ) N'$.value' As Json --currently no array in my data
    ) As j2