Creates a new, or alters an existing, schema.

PUT {{baseUrl}}/api/v2/databases/:database/schemas/:name?kind=

Creates a new, or alters an existing, schema. You must provide the full schema definition even when altering an existing schema.

Request Params

Request Body

{"name"=>"VKw97w4S60y", "created_on"=>"<dateTime>", "kind"=>"PERMANENT", "is_default"=>"<boolean>", "is_current"=>"<boolean>", "database_name"=>"<string>", "owner"=>"<string>", "comment"=>"<string>", "options"=>"<string>", "managed_access"=>false, "retention_time"=>"<integer>", "dropped_on"=>"<dateTime>", "owner_role_type"=>"<string>", "budget"=>"<string>", "data_retention_time_in_days"=>"<integer>", "default_ddl_collation"=>"<string>", "log_level"=>"<string>", "pipe_execution_paused"=>"<boolean>", "max_data_extension_time_in_days"=>"<integer>", "suspend_task_after_num_failures"=>"<integer>", "trace_level"=>"<string>", "user_task_managed_initial_warehouse_size"=>"<string>", "user_task_timeout_ms"=>"<integer>"}

HEADERS

RESPONSES

status: OK

{"status":"\u003cstring\u003e"}