SaaS connector data

All connectors in the SaaS connector group are providing the same type of data to Snow License Manager. This data consists of the properties and objects described in the following sections. All tables are in the gsd schema.

Provider account

Field in SaaS

Description

Field in SLM

AccountCreationDate

Date when the SaaS account was created

tblAccountInstance | CreationDate

AccountInstanceId

Unique id for the SaaS connector

tblAccountInstance | Id

AccountInstanceName

Name of the SaaS connector

tblAccountInstance | Name

AccountType

Object with additional information about the SaaS connector

gsd.tblAccountType

AggregationStartDate

Date and time of the data aggregation start

tblAccountInstanceImport | AggregationDate

Subscriptions

List of subscriptions for the SaaS product

tblSubscriptionInstance

Users

List of SaaS product users

tblUser

Account type

Field in SaaS

Description

Field in SLM

AccountTypeId

Internal id unique for every SaaS provider

tblAccountType | Id

AccountTypeName

Name of the SaaS product

tblAccountType | AccountTypeName

HasLastUserActivityDate

Specifies if the date of the last user activity is included in the response

tblAccountType | HasLastUserActivityDate

ProviderName

Name of the SaaS provider

tblAccountType | ProviderName

Thumbnail

SaaS product logo

tblAccountTypeKeyValueBinaryStore | Payload

Subscription

Field in SaaS

Description

Field in SLM

AssignedUserIds

List of the billable user ids for the current subscription model

tblImportSubscriptionInstanceUserHistory

AssignedUsers

Number of the billable users

tblImportSubscriptionInstanceHistory | AssignedUsers

AvailableUserAssignments

Number of the available user accounts for the current subscription

tblImportSubscriptionInstanceHistory | AvailableUsers

CreatedDateTime

Date and time when the subscription was created

tblSubscriptionInstance | CreatedDateTime

SubscriptionInstanceId

Internal id for the subscription

tblSubscriptionInstance | Id

SubscriptionMeteringType

Type of the subscription model. It can be PerUser, PerUserCap, Agreement or Undefined

tblSubscriptionMeteringType

TypeDefinition

Object that consists of friendly subscription name and type id

tblSubscriptionType

UserCap

Maximum number of users for the subscription

tblImportSubscriptionInstanceHistory | UserCap

User

Field in SaaS

Description

Field in SLM

Id

Unique user id

tblUser | Id

Email

User email address

tblUser | Email

Username

Username

tblUser | UserName

Name

Full name of the user

tblUser | Name

RegistrationDateTime

Date when the user registered

tblUser | RegistrationDateTime

FirstActivityDateTime

Date of the first activity by the user

tblUser | FirstActivityDateTime

LastActivityDateTime

Date of the last activity by the user

tblUser | LastActivityDateTime

Status

User status.

It can have one of the following values: Undefined, Active, Inactive, Disabled, Deleted, Invited, Suspended

tblUserStatus

Note

Object relations use internal database references between tables (enforced by foreign keys), for example tblAccountInstance referencing the account type for the instance with the column AccountTypeRefId pointing to the RefId column of tblAccountType.