Request Syntax URI Request Parameters Request Body Response Syntax Response Elements Errors See Also

CreateConfiguredTable

Creates a new configured table resource.

Request Syntax


POST /configuredTables HTTP/1.1
Content-type: application/json

{
   "allowedColumns": [ "string" ],
   "analysisMethod": "string",
   "description": "string",
   "name": "string",
   "selectedAnalysisMethods": [ "string" ],
   "tableReference": { ... },
   "tags": { 
      "string" : "string" 
   }
}

URI Request Parameters

The request does not use any URI parameters.

Request Body

The request accepts the following data in JSON format.

allowedColumns

The columns of the underlying table that can be used by collaborations or analysis rules.

Type: Array of strings

Array Members: Minimum number of 1 item.

Length Constraints: Minimum length of 0. Maximum length of 128.

Pattern: [a-z0-9_](([a-z0-9_ ]+-)*([a-z0-9_ ]+))?

Required: Yes

analysisMethod

The analysis method allowed for the configured tables.

DIRECT_QUERY allows SQL queries to be run directly on this table.

DIRECT_JOB allows PySpark jobs to be run directly on this table.

MULTIPLE allows both SQL queries and PySpark jobs to be run directly on this table.

Type: String

Valid Values: DIRECT_QUERY | DIRECT_JOB | MULTIPLE

Required: Yes

description

A description for the configured table.

Type: String

Length Constraints: Minimum length of 0. Maximum length of 255.

Pattern: [\u0020-\uD7FF\uE000-\uFFFD\uD800\uDBFF-\uDC00\uDFFF\t\r\n]*

Required: No

name

The name of the configured table.

Type: String

Length Constraints: Minimum length of 1. Maximum length of 100.

Pattern: (?!\s*$)[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDBFF-\uDC00\uDFFF\t]*

Required: Yes

selectedAnalysisMethods

The analysis methods to enable for the configured table. When configured, you must specify at least two analysis methods.

Type: Array of strings

Valid Values: DIRECT_QUERY | DIRECT_JOB

Required: No

tableReference

A reference to the table being configured.

Type: TableReference object

Note: This object is a Union. Only one member of this object can be specified or returned.

Required: Yes

tags

An optional label that you can assign to a resource when you create it. Each tag consists of a key and an optional value, both of which you define. When you use tagging, you can also use tag-based access control in IAM policies to control access to this resource.

Type: String to string map

Map Entries: Minimum number of 0 items. Maximum number of 200 items.

Key Length Constraints: Minimum length of 1. Maximum length of 128.

Value Length Constraints: Minimum length of 0. Maximum length of 256.

Required: No

Response Syntax


HTTP/1.1 200
Content-type: application/json

{
   "configuredTable": { 
      "allowedColumns": [ "string" ],
      "analysisMethod": "string",
      "analysisRuleTypes": [ "string" ],
      "arn": "string",
      "createTime": number,
      "description": "string",
      "id": "string",
      "name": "string",
      "selectedAnalysisMethods": [ "string" ],
      "tableReference": { ... },
      "updateTime": number
   }
}

Response Elements

If the action is successful, the service sends back an HTTP 200 response.

The following data is returned in JSON format by the service.

configuredTable

The created configured table.

Type: ConfiguredTable object

Errors

For information about the errors that are common to all actions, see Common Errors.

AccessDeniedException

Caller does not have sufficient access to perform this action.

reason: A reason code for the exception.

HTTP Status Code: 403

ConflictException

Updating or deleting a resource can cause an inconsistent state.

reason: A reason code for the exception.
resourceId: The ID of the conflicting resource.
resourceType: The type of the conflicting resource.

HTTP Status Code: 409

InternalServerException

Unexpected error during processing of request.

HTTP Status Code: 500

ResourceNotFoundException

Request references a resource which does not exist.

resourceId: The Id of the missing resource.
resourceType: The type of the missing resource.

HTTP Status Code: 404

ServiceQuotaExceededException

Request denied because service quota has been exceeded.

quotaName: The name of the quota.
quotaValue: The value of the quota.

HTTP Status Code: 402

ThrottlingException

Request was denied due to request throttling.

HTTP Status Code: 429

ValidationException

The input fails to satisfy the specified constraints.

fieldList: Validation errors for specific input parameters.
reason: A reason code for the exception.

HTTP Status Code: 400