Snowflake · JSON Structure

User User Structure

Type: object Properties: 40

Data LakesData SharingData WarehousingDatabaseSQL

User is a JSON Structure definition published by Snowflake, describing 40 properties. It conforms to the https://json-structure.org/draft/2020-12/schema meta-schema.

Properties

name password login_name display_name first_name middle_name last_name email must_change_password disabled days_to_expiry mins_to_unlock default_warehouse default_namespace default_role default_secondary_roles mins_to_bypass_mfa rsa_public_key rsa_public_key_2 comment type enable_unredacted_query_syntax_error network_policy created_on last_successful_login expires_at locked_until has_password has_rsa_public_key rsa_public_key_fp rsa_public_key_2_fp ext_authn_duo ext_authn_uid owner snowflake_lock snowflake_support mins_to_bypass_network_policy password_last_set custom_landing_page_url custom_landing_page_url_flush_next_ui_load

Meta-schema: https://json-structure.org/draft/2020-12/schema

JSON Structure

{
  "$schema": "https://json-structure.org/draft/2020-12/schema",
  "name": "User",
  "type": "object",
  "properties": {
    "name": {
      "type": "string"
    },
    "password": {
      "type": "string"
    },
    "login_name": {
      "type": "string"
    },
    "display_name": {
      "type": "string"
    },
    "first_name": {
      "type": "string"
    },
    "middle_name": {
      "type": "string"
    },
    "last_name": {
      "type": "string"
    },
    "email": {
      "type": "string"
    },
    "must_change_password": {
      "type": "boolean"
    },
    "disabled": {
      "type": "boolean"
    },
    "days_to_expiry": {
      "type": "integer"
    },
    "mins_to_unlock": {
      "type": "integer"
    },
    "default_warehouse": {
      "type": "string"
    },
    "default_namespace": {
      "type": "string"
    },
    "default_role": {
      "type": "string"
    },
    "default_secondary_roles": {
      "type": "string"
    },
    "mins_to_bypass_mfa": {
      "type": "integer"
    },
    "rsa_public_key": {
      "type": "string"
    },
    "rsa_public_key_2": {
      "type": "string"
    },
    "comment": {
      "type": "string"
    },
    "type": {
      "type": "string"
    },
    "enable_unredacted_query_syntax_error": {
      "type": "boolean"
    },
    "network_policy": {
      "type": "string"
    },
    "created_on": {
      "type": "string"
    },
    "last_successful_login": {
      "type": "string"
    },
    "expires_at": {
      "type": "string"
    },
    "locked_until": {
      "type": "string"
    },
    "has_password": {
      "type": "boolean"
    },
    "has_rsa_public_key": {
      "type": "boolean"
    },
    "rsa_public_key_fp": {
      "type": "string"
    },
    "rsa_public_key_2_fp": {
      "type": "string"
    },
    "ext_authn_duo": {
      "type": "boolean"
    },
    "ext_authn_uid": {
      "type": "string"
    },
    "owner": {
      "type": "string"
    },
    "snowflake_lock": {
      "type": "boolean"
    },
    "snowflake_support": {
      "type": "boolean"
    },
    "mins_to_bypass_network_policy": {
      "type": "integer"
    },
    "password_last_set": {
      "type": "string"
    },
    "custom_landing_page_url": {
      "type": "string"
    },
    "custom_landing_page_url_flush_next_ui_load": {
      "type": "boolean"
    }
  }
}