⭐ Repository

📗 Snowflake User

• ID: /types/CA10SN2__CaSnowflakeUser__c

Fields

	Label	API Name	Type	Help
🔒	CloudAware UUID	CA10SN2__caUuid__c	Text(255)
🔒	Comment	CA10SN2__comment__c	LongTextArea(32768)
🔒	Created	CA10SN2__created__c	DateTime
🔒	Created Date	CreatedDate	DateTime
🔒	Default Database Unique ID	CA10SN2__defaultDatabaseUniqueId__c	Text(255)
🔒	Default Namespace	CA10SN2__defaultNamespace__c	Text(255)
🔒🔌	Default Role Name	CA10SN2__defaultRoleName__c	Text(255)
🔒	Default Role Unique ID	CA10SN2__defaultRoleUniqueId__c	Text(255)
🔒	Default Schema Unique ID	CA10SN2__defaultSchemaUniqueId__c	Text(255)
🔒	Default Secondary Role Name	CA10SN2__defaultSecondaryRoleName__c	Text(255)
🔒	Default Secondary Role Unique ID	CA10SN2__defaultSecondaryRoleUniqueId__c	Text(255)
🔒	Default Warehouse	CA10SN2__defaultWarehouse__c	Text(255)
🔒	Deleted	IsDeleted	Checkbox
🔒	Deleted From Snowflake	CA10SN2__disappearanceTime__c	DateTime
🔒	Display Name	CA10SN2__displayName__c	Text(255)
🔒	Email	CA10SN2__email__c	Text(255)
🔒	Expires At	CA10SN2__expiresAt__c	DateTime
🔒🔌	Ext Authn Duo	CA10SN2__extAuthnDuo__c	Text(255)
🔒	Ext Authn UID	CA10SN2__extAuthnUid__c	Text(255)
🔒	First Name	CA10SN2__firstName__c	Text(255)
🔒	Has MFA	CA10SN2__hasMfa__c	Text(255)
🔒🔌	Has Password	CA10SN2__hasPassword__c	Text(255)
🔒	Has RSA Public Key	CA10SN2__hasRsaPublicKey__c	Text(255)
🔒	Is Disabled	CA10SN2__isDisabled__c	Text(255)
🔒	Last Activity Date	LastActivityDate	Date
🔒	Last Modified Date	LastModifiedDate	DateTime
🔒	Last Name	CA10SN2__lastName__c	Text(255)
🔒	Last Success Login	CA10SN2__lastSuccessLogin__c	DateTime
🔒	Login Name	CA10SN2__loginName__c	Text(255)
🔒	Must Change Password	CA10SN2__mustChangePassword__c	Text(255)
🔒	Name	Name	Text(80)
🔒	Name	CA10SN2__name__c	Text(255)
🔒	Owner Name	CA10SN2__ownerName__c	Text(255)
🔒	Owner Unique ID	CA10SN2__ownerUniqueId__c	Text(255)
🔒	Record ID	Id	Text
🔒	Snowflake Account Locator	CA10SN2__snowflakeAccountLocator__c	Text(255)
🔒	Snowflake Lock	CA10SN2__snowflakeLock__c	Text(255)
🔒	System Modstamp	SystemModstamp	DateTime
🔒	Type	CA10SN2__type__c	Text(255)
🔒	Unique ID	CA10SN2__uniqueId__c	Text(255)
🔒	User ID	CA10SN2__userId__c	Text(255)
🔒🔌	password Last Set Time	CA10SN2__passwordLastSetTime__c	DateTime

Extracts

	Name	Extracts File
🔒	CA10SN2__defaultRoleName__c	🔌 object.extracts.yaml
🔒	CA10SN2__extAuthnDuo__c	🔌 object.extracts.yaml
🔒	CA10SN2__hasPassword__c	🔌 object.extracts.yaml
🔒	CA10SN2__passwordLastSetTime__c	🔌 object.extracts.yaml

Lookups

	Label	API Name	Type
🔒	Created By ID	CreatedById / CreatedBy	User
🔒	Default Database	CA10SN2__defaultDatabase__c / CA10SN2__defaultDatabase__r	CA10SN2__CaSnowflakeDatabase__c
🔒	Default Role	CA10SN2__defaultRole__c / CA10SN2__defaultRole__r	CA10SN2__CaSnowflakeRole__c
🔒	Default Schema	CA10SN2__defaultSchema__c / CA10SN2__defaultSchema__r	CA10SN2__CaSnowflakeSchema__c
🔒	Default Secondary Role	CA10SN2__defaultSecondaryRole__c / CA10SN2__defaultSecondaryRole__r	CA10SN2__CaSnowflakeRole__c
🔒	Last Modified By ID	LastModifiedById / LastModifiedBy	User
🔒	Owner	CA10SN2__owner__c / CA10SN2__owner__r	CA10SN2__CaSnowflakeRole__c
🔒	Received Connection ID	ConnectionReceivedId / ConnectionReceived	PartnerNetworkConnection
🔒	Record Type ID	RecordTypeId / RecordType	RecordType
🔒	Sent Connection ID	ConnectionSentId / ConnectionSent	PartnerNetworkConnection
🔒	Snowflake Account	CA10SN2__snowflakeAccount__c / CA10SN2__snowflakeAccount__r	CA10SN2__CaSnowflakeAccount__c
🔒	Snowflake Identity	CA10SN2__snowflakeIdentity__c / CA10SN2__snowflakeIdentity__r	CA10SN2__CaSnowflakeIdentity__c

Extract Files

Extract	Parent	Flags
🔌 object.extracts.yaml	📗 Snowflake User

Logic Files

Logic	Policy	Flags
🧠 prod.logic.yaml🟢	🛡️ Snowflake User Default Role is ACCOUNTADMIN🟢	🟢 x3
🧠 prod.logic.yaml🟢	🛡️ Snowflake User Default Role is not set🟢	🟢 x3
🧠 prod.logic.yaml🟢	🛡️ Snowflake User MFA is not enabled🟢	🟢 x3
🧠 prod.logic.yaml🟢	🛡️ Snowflake User password is not rotated every 90 days🟢	🟢 x3