📕 Snowflake User
- Contextual name: 📕 Snowflake User
- ID:
/types/CA10SN__CaSnowflakeUser__c
Fields
| Label | API Name | Type | Help | |
|---|---|---|---|---|
| 🔒 | Bypass MFA Until | CA10SN__bypassMfaUntil__c | DateTime | |
| 🔒 | CloudAware UUID | CA10SN__caUuid__c | Text(255) | |
| 🔒 | Comment | CA10SN__comment__c | LongTextArea(32768) | |
| 🔒 | Created Date | CreatedDate | DateTime | |
| 🔒 | Created On | CA10SN__createdOn__c | DateTime | |
| 🔒 | Default Database Name | CA10SN__defaultDatabaseName__c | Text(255) | |
| 🔒 | Default Namespace | CA10SN__defaultNamespace__c | Text(255) | |
| 🔒🔌 | Default Role Name | CA10SN__defaultRoleName__c | Text(255) | |
| 🔒 | Default Schema Name | CA10SN__defaultSchemaName__c | Text(255) | |
| 🔒 | Default Warehouse Name | CA10SN__defaultWarehouseName__c | Text(255) | |
| 🔒 | Deleted | IsDeleted | Checkbox | |
| 🔒 | Deleted From Snowflake | CA10SN__disappearanceTime__c | DateTime | |
| 🔒 | Disabled | CA10SN__disabled__c | Text(255) | |
| 🔒 | Display Name | CA10SN__displayName__c | Text(255) | |
| 🔒 | Duo Security Authorization ID | CA10SN__extAuthnUid__c | Text(255) | |
| 🔒🔌 | Duo Security Is Enabled | CA10SN__extAuthnDuo__c | Text(255) | |
| 🔒 | CA10SN__email__c | Text(255) | ||
| 🔒 | Expires At | CA10SN__expiresAt__c | DateTime | |
| 🔒 | First Name | CA10SN__firstName__c | Text(255) | |
| 🔒🔌 | Has Password | CA10SN__hasPassword__c | Text(255) | |
| 🔒 | Has RSA Public Key | CA10SN__hasRsaPublicKey__c | Text(255) | |
| 🔒 | Last Activity Date | LastActivityDate | Date | |
| 🔒 | Last Modified Date | LastModifiedDate | DateTime | |
| 🔒 | Last Name | CA10SN__lastName__c | Text(255) | |
| 🔒 | Last Success Login | CA10SN__lastSuccessLogin__c | DateTime | |
| 🔒 | Locked Until | CA10SN__lockedUntilTime__c | DateTime | |
| 🔒 | Login Name | CA10SN__loginName__c | Text(255) | |
| 🔒 | Must Change Password | CA10SN__mustChangePassword__c | Text(255) | |
| 🔒 | Name | Name | Text(80) | |
| 🔒 | Name | CA10SN__name__c | Text(255) | |
| 🔒🔌 | Password Last Set Time | CA10SN__passwordLastSetTime__c | DateTime | |
| 🔒 | Record ID | Id | Text | |
| 🔒 | Snowflake Lock | CA10SN__snowflakeLock__c | Text(255) | |
| 🔒 | System Modstamp | SystemModstamp | DateTime |
Extracts
| Name | Extracts File | |
|---|---|---|
| 🔒 | CA10SN__defaultRoleName__c | 🔌 object.extracts.yaml |
| 🔒 | CA10SN__extAuthnDuo__c | 🔌 object.extracts.yaml |
| 🔒 | CA10SN__hasPassword__c | 🔌 object.extracts.yaml |
| 🔒 | CA10SN__passwordLastSetTime__c | 🔌 object.extracts.yaml |
Lookups
| Label | API Name | Type | |
|---|---|---|---|
| 🔒 | Account | CA10SN__account__c / CA10SN__account__r | CA10SN__CaSnowflakeAccount__c |
| 🔒 | Created By ID | CreatedById / CreatedBy | User |
| 🔒 | Default Database | CA10SN__defaultDatabase__c / CA10SN__defaultDatabase__r | CA10SN__CaSnowflakeDatabase__c |
| 🔒 | Default Role | CA10SN__defaultRole__c / CA10SN__defaultRole__r | CA10SN__CaSnowflakeRole__c |
| 🔒 | Default Schema | CA10SN__defaultSchema__c / CA10SN__defaultSchema__r | CA10SN__CaSnowflakeSchema__c |
| 🔒 | Default Warehouse | CA10SN__defaultWarehouse__c / CA10SN__defaultWarehouse__r | CA10SN__CaSnowflakeWarehouse__c |
| 🔒 | Last Modified By ID | LastModifiedById / LastModifiedBy | User |
| 🔒 | Received Connection ID | ConnectionReceivedId / ConnectionReceived | PartnerNetworkConnection |
| 🔒 | Record Type ID | RecordTypeId / RecordType | RecordType |
| 🔒 | Sent Connection ID | ConnectionSentId / ConnectionSent | PartnerNetworkConnection |
Extract Files
| Extract | Type | 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 |