ALTER APPLICATION SET CONFIGURATION DEFINITION¶

구문¶

For APPLICATION_NAME:

ALTER APPLICATION SET CONFIGURATION DEFINITION <config>
  TYPE = APPLICATION_NAME
  LABEL = '<label>'
  DESCRIPTION = '<description>'
  APPLICATION_ROLES = ( <app_role1> [ , <app_role2> ... ] );

For STRING:

ALTER APPLICATION SET CONFIGURATION DEFINITION <config>
  TYPE = STRING
  LABEL = '<label>'
  DESCRIPTION = '<description>'
  APPLICATION_ROLES = ( <app_role1> [ , <app_role2> ... ] )
  SENSITIVE = { TRUE | FALSE };

For SECRET_AUTHORIZATION:

ALTER APPLICATION SET CONFIGURATION DEFINITION <config>
  TYPE = SECRET_AUTHORIZATION
  SECRET = <schema>.<secret>
  LABEL = '<label>'
  DESCRIPTION = '<description>'
  APPLICATION_ROLES = ( <app_role1> [ , <app_role2> ... ] );

매개 변수¶

config

앱 구성의 식별자입니다.

TYPE

앱 구성의 유형을 지정합니다. 지원되는 값은 다음과 같습니다.

• APPLICATION_NAME

• STRING

• SECRET_AUTHORIZATION

SECRET = schema.secret

Specifies the secret that the consumer populates with tokens during the OAuth flow. Required when TYPE = SECRET_AUTHORIZATION. The secret must be owned by the application creating the configuration.

The name can be specified as schema.secret, in which case the app’s own database is implied, or as the fully qualified database.schema.secret. In either form, the secret must be owned by the app.

On configuration creation, the system validates that the secret has been granted MODIFY to all the specified application roles. For more information, see Request OAuth authorization from consumers.

LABEL = 'label'

Specifies a label for the app configuration to be displayed in the Snowsight.

DESCRIPTION = 'description'

Specifies a description of the app configuration. Snowflake recommends including information about the app configuration type and why it is required by the app.

APPLICATION_ROLES = ( <app_role1> [ , <app_role2> ... ] )

앱 구성 오브젝트에 액세스할 수 있는 애플리케이션 역할을 지정합니다.

SENSITIVE = { TRUE | FALSE }

Specifies whether the configuration value should be treated as sensitive. When set to TRUE, the value is not displayed in the output of SHOW CONFIGURATIONS or DESCRIBE CONFIGURATION. Required when TYPE = STRING. Not valid for other configuration types. Specifying SENSITIVE with SECRET_AUTHORIZATION or APPLICATION_NAME returns a compilation error. For more information, see 민감한 구성.

사용법 노트¶

• 이 명령은 Snowflake Native App 에서만 사용할 수 있습니다.

• When creating a configuration definition for the server app name for inter-app communication, you must set the LABEL and DESCRIPTION parameters to the same values as the LABEL and DESCRIPTION parameters of the associated APPLICATION SPECIFICATION object.