ssas.model_json_33_dataSources - V

type: V ( view ), modify_date: 2021-09-01 06:27:16

RepoObject_guid: FA5FD8EE-E90A-EC11-8516-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.model_json_33_datasources

Columns

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

1

nvarchar(128)

NOT NULL

2

nvarchar(500)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(4000)

NULL

nvarchar(500)

NULL

nvarchar(500)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_33_datasources

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_33_datasources

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_33_datasources

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_33_datasources

Column Reference Diagram

entity_1_1_colref-ssas.model_json_33_datasources

Indexes

PK_model_json_33_dataSources

idx_model_json_33_dataSources__2

Column Details

_

databasename

1

databasename

nvarchar(128)

NOT NULL

Referenced Columns

dataSources_name

2

dataSources_name

nvarchar(500)

NULL

dataSources_account

dataSources_account

nvarchar(500)

NULL

dataSources_annotations_ja

dataSources_annotations_ja

nvarchar(max)

NULL

dataSources_connectionString

dataSources_connectionString

nvarchar(4000)

NULL

dataSources_impersonationMode

dataSources_impersonationMode

nvarchar(500)

NULL

dataSources_provider

dataSources_provider

nvarchar(500)

NULL

sql_modules_definition

ssas.model_json_33_dataSources - V script
/*
--check

Select
    Distinct
    j2.[Key]
  , j2.Type
From
    ssas.model_json_20                            As T1
    Cross Apply OpenJson ( T1.l2_dataSources_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
order by
    j2.[Key]
  , j2.Type
Go
*/
CREATE View ssas.model_json_33_dataSources
As
Select
    T1.databasename
  , j2.dataSources_name
  , j2.dataSources_account
  , j2.dataSources_annotations_ja
  , j2.dataSources_connectionString
  , j2.dataSources_impersonationMode
  , j2.dataSources_provider
From
    ssas.model_json_20                            As T1
    Cross Apply OpenJson ( T1.l2_dataSources_ja ) As j1
    Cross Apply
    OpenJson ( j1.Value )
    With
    (
        dataSources_name NVarchar ( 500 ) N'$.name'
      , dataSources_account NVarchar ( 500 ) N'$.account'
      , dataSources_annotations_ja NVarchar ( Max ) N'$.annotations' As Json
      , dataSources_connectionString NVarchar ( 4000 ) N'$.connectionString'
      , dataSources_impersonationMode NVarchar ( 500 ) N'$.impersonationMode'
      , dataSources_provider NVarchar ( 500 ) N'$.provider'
    ) As j2