{ "version":"2.0", "metadata":{ "apiVersion":"2017-05-18", "endpointPrefix":"athena", "jsonVersion":"1.1", "protocol":"json", "serviceFullName":"Amazon Athena", "serviceId":"Athena", "signatureVersion":"v4", "targetPrefix":"AmazonAthena", "uid":"athena-2017-05-18" }, "operations":{ "BatchGetNamedQuery":{ "name":"BatchGetNamedQuery", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"BatchGetNamedQueryInput"}, "output":{"shape":"BatchGetNamedQueryOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] }, "BatchGetQueryExecution":{ "name":"BatchGetQueryExecution", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"BatchGetQueryExecutionInput"}, "output":{"shape":"BatchGetQueryExecutionOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] }, "CreateNamedQuery":{ "name":"CreateNamedQuery", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"CreateNamedQueryInput"}, "output":{"shape":"CreateNamedQueryOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ], "idempotent":true }, "CreateWorkGroup":{ "name":"CreateWorkGroup", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"CreateWorkGroupInput"}, "output":{"shape":"CreateWorkGroupOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] }, "DeleteNamedQuery":{ "name":"DeleteNamedQuery", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"DeleteNamedQueryInput"}, "output":{"shape":"DeleteNamedQueryOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ], "idempotent":true }, "DeleteWorkGroup":{ "name":"DeleteWorkGroup", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"DeleteWorkGroupInput"}, "output":{"shape":"DeleteWorkGroupOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ], "idempotent":true }, "GetNamedQuery":{ "name":"GetNamedQuery", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"GetNamedQueryInput"}, "output":{"shape":"GetNamedQueryOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] }, "GetQueryExecution":{ "name":"GetQueryExecution", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"GetQueryExecutionInput"}, "output":{"shape":"GetQueryExecutionOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] }, "GetQueryResults":{ "name":"GetQueryResults", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"GetQueryResultsInput"}, "output":{"shape":"GetQueryResultsOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] }, "GetWorkGroup":{ "name":"GetWorkGroup", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"GetWorkGroupInput"}, "output":{"shape":"GetWorkGroupOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] }, "ListNamedQueries":{ "name":"ListNamedQueries", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"ListNamedQueriesInput"}, "output":{"shape":"ListNamedQueriesOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] }, "ListQueryExecutions":{ "name":"ListQueryExecutions", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"ListQueryExecutionsInput"}, "output":{"shape":"ListQueryExecutionsOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] }, "ListTagsForResource":{ "name":"ListTagsForResource", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"ListTagsForResourceInput"}, "output":{"shape":"ListTagsForResourceOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"}, {"shape":"ResourceNotFoundException"} ] }, "ListWorkGroups":{ "name":"ListWorkGroups", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"ListWorkGroupsInput"}, "output":{"shape":"ListWorkGroupsOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] }, "StartQueryExecution":{ "name":"StartQueryExecution", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"StartQueryExecutionInput"}, "output":{"shape":"StartQueryExecutionOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"}, {"shape":"TooManyRequestsException"} ], "idempotent":true }, "StopQueryExecution":{ "name":"StopQueryExecution", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"StopQueryExecutionInput"}, "output":{"shape":"StopQueryExecutionOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ], "idempotent":true }, "TagResource":{ "name":"TagResource", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"TagResourceInput"}, "output":{"shape":"TagResourceOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"}, {"shape":"ResourceNotFoundException"} ] }, "UntagResource":{ "name":"UntagResource", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"UntagResourceInput"}, "output":{"shape":"UntagResourceOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"}, {"shape":"ResourceNotFoundException"} ] }, "UpdateWorkGroup":{ "name":"UpdateWorkGroup", "http":{ "method":"POST", "requestUri":"/" }, "input":{"shape":"UpdateWorkGroupInput"}, "output":{"shape":"UpdateWorkGroupOutput"}, "errors":[ {"shape":"InternalServerException"}, {"shape":"InvalidRequestException"} ] } }, "shapes":{ "AmazonResourceName":{ "type":"string", "max":1011, "min":1 }, "BatchGetNamedQueryInput":{ "type":"structure", "required":["NamedQueryIds"], "members":{ "NamedQueryIds":{"shape":"NamedQueryIdList"} } }, "BatchGetNamedQueryOutput":{ "type":"structure", "members":{ "NamedQueries":{"shape":"NamedQueryList"}, "UnprocessedNamedQueryIds":{"shape":"UnprocessedNamedQueryIdList"} } }, "BatchGetQueryExecutionInput":{ "type":"structure", "required":["QueryExecutionIds"], "members":{ "QueryExecutionIds":{"shape":"QueryExecutionIdList"} } }, "BatchGetQueryExecutionOutput":{ "type":"structure", "members":{ "QueryExecutions":{"shape":"QueryExecutionList"}, "UnprocessedQueryExecutionIds":{"shape":"UnprocessedQueryExecutionIdList"} } }, "Boolean":{"type":"boolean"}, "BoxedBoolean":{"type":"boolean"}, "BytesScannedCutoffValue":{ "type":"long", "min":10000000 }, "ColumnInfo":{ "type":"structure", "required":[ "Name", "Type" ], "members":{ "CatalogName":{"shape":"String"}, "SchemaName":{"shape":"String"}, "TableName":{"shape":"String"}, "Name":{"shape":"String"}, "Label":{"shape":"String"}, "Type":{"shape":"String"}, "Precision":{"shape":"Integer"}, "Scale":{"shape":"Integer"}, "Nullable":{"shape":"ColumnNullable"}, "CaseSensitive":{"shape":"Boolean"} } }, "ColumnInfoList":{ "type":"list", "member":{"shape":"ColumnInfo"} }, "ColumnNullable":{ "type":"string", "enum":[ "NOT_NULL", "NULLABLE", "UNKNOWN" ] }, "CreateNamedQueryInput":{ "type":"structure", "required":[ "Name", "Database", "QueryString" ], "members":{ "Name":{"shape":"NameString"}, "Description":{"shape":"DescriptionString"}, "Database":{"shape":"DatabaseString"}, "QueryString":{"shape":"QueryString"}, "ClientRequestToken":{ "shape":"IdempotencyToken", "idempotencyToken":true }, "WorkGroup":{"shape":"WorkGroupName"} } }, "CreateNamedQueryOutput":{ "type":"structure", "members":{ "NamedQueryId":{"shape":"NamedQueryId"} } }, "CreateWorkGroupInput":{ "type":"structure", "required":["Name"], "members":{ "Name":{"shape":"WorkGroupName"}, "Configuration":{"shape":"WorkGroupConfiguration"}, "Description":{"shape":"WorkGroupDescriptionString"}, "Tags":{"shape":"TagList"} } }, "CreateWorkGroupOutput":{ "type":"structure", "members":{ } }, "DatabaseString":{ "type":"string", "max":255, "min":1 }, "Date":{"type":"timestamp"}, "Datum":{ "type":"structure", "members":{ "VarCharValue":{"shape":"datumString"} } }, "DeleteNamedQueryInput":{ "type":"structure", "required":["NamedQueryId"], "members":{ "NamedQueryId":{ "shape":"NamedQueryId", "idempotencyToken":true } } }, "DeleteNamedQueryOutput":{ "type":"structure", "members":{ } }, "DeleteWorkGroupInput":{ "type":"structure", "required":["WorkGroup"], "members":{ "WorkGroup":{"shape":"WorkGroupName"}, "RecursiveDeleteOption":{"shape":"BoxedBoolean"} } }, "DeleteWorkGroupOutput":{ "type":"structure", "members":{ } }, "DescriptionString":{ "type":"string", "max":1024, "min":1 }, "EncryptionConfiguration":{ "type":"structure", "required":["EncryptionOption"], "members":{ "EncryptionOption":{"shape":"EncryptionOption"}, "KmsKey":{"shape":"String"} } }, "EncryptionOption":{ "type":"string", "enum":[ "SSE_S3", "SSE_KMS", "CSE_KMS" ] }, "ErrorCode":{ "type":"string", "max":256, "min":1 }, "ErrorMessage":{"type":"string"}, "GetNamedQueryInput":{ "type":"structure", "required":["NamedQueryId"], "members":{ "NamedQueryId":{"shape":"NamedQueryId"} } }, "GetNamedQueryOutput":{ "type":"structure", "members":{ "NamedQuery":{"shape":"NamedQuery"} } }, "GetQueryExecutionInput":{ "type":"structure", "required":["QueryExecutionId"], "members":{ "QueryExecutionId":{"shape":"QueryExecutionId"} } }, "GetQueryExecutionOutput":{ "type":"structure", "members":{ "QueryExecution":{"shape":"QueryExecution"} } }, "GetQueryResultsInput":{ "type":"structure", "required":["QueryExecutionId"], "members":{ "QueryExecutionId":{"shape":"QueryExecutionId"}, "NextToken":{"shape":"Token"}, "MaxResults":{"shape":"MaxQueryResults"} } }, "GetQueryResultsOutput":{ "type":"structure", "members":{ "UpdateCount":{"shape":"Long"}, "ResultSet":{"shape":"ResultSet"}, "NextToken":{"shape":"Token"} } }, "GetWorkGroupInput":{ "type":"structure", "required":["WorkGroup"], "members":{ "WorkGroup":{"shape":"WorkGroupName"} } }, "GetWorkGroupOutput":{ "type":"structure", "members":{ "WorkGroup":{"shape":"WorkGroup"} } }, "IdempotencyToken":{ "type":"string", "max":128, "min":32 }, "Integer":{"type":"integer"}, "InternalServerException":{ "type":"structure", "members":{ "Message":{"shape":"ErrorMessage"} }, "exception":true, "fault":true }, "InvalidRequestException":{ "type":"structure", "members":{ "AthenaErrorCode":{"shape":"ErrorCode"}, "Message":{"shape":"ErrorMessage"} }, "exception":true }, "ListNamedQueriesInput":{ "type":"structure", "members":{ "NextToken":{"shape":"Token"}, "MaxResults":{"shape":"MaxNamedQueriesCount"}, "WorkGroup":{"shape":"WorkGroupName"} } }, "ListNamedQueriesOutput":{ "type":"structure", "members":{ "NamedQueryIds":{"shape":"NamedQueryIdList"}, "NextToken":{"shape":"Token"} } }, "ListQueryExecutionsInput":{ "type":"structure", "members":{ "NextToken":{"shape":"Token"}, "MaxResults":{"shape":"MaxQueryExecutionsCount"}, "WorkGroup":{"shape":"WorkGroupName"} } }, "ListQueryExecutionsOutput":{ "type":"structure", "members":{ "QueryExecutionIds":{"shape":"QueryExecutionIdList"}, "NextToken":{"shape":"Token"} } }, "ListTagsForResourceInput":{ "type":"structure", "required":["ResourceARN"], "members":{ "ResourceARN":{"shape":"AmazonResourceName"}, "NextToken":{"shape":"Token"}, "MaxResults":{"shape":"MaxTagsCount"} } }, "ListTagsForResourceOutput":{ "type":"structure", "members":{ "Tags":{"shape":"TagList"}, "NextToken":{"shape":"Token"} } }, "ListWorkGroupsInput":{ "type":"structure", "members":{ "NextToken":{"shape":"Token"}, "MaxResults":{"shape":"MaxWorkGroupsCount"} } }, "ListWorkGroupsOutput":{ "type":"structure", "members":{ "WorkGroups":{"shape":"WorkGroupsList"}, "NextToken":{"shape":"Token"} } }, "Long":{"type":"long"}, "MaxNamedQueriesCount":{ "type":"integer", "box":true, "max":50, "min":0 }, "MaxQueryExecutionsCount":{ "type":"integer", "box":true, "max":50, "min":0 }, "MaxQueryResults":{ "type":"integer", "box":true, "max":1000, "min":1 }, "MaxTagsCount":{ "type":"integer", "box":true, "min":75 }, "MaxWorkGroupsCount":{ "type":"integer", "box":true, "max":50, "min":1 }, "NameString":{ "type":"string", "max":128, "min":1 }, "NamedQuery":{ "type":"structure", "required":[ "Name", "Database", "QueryString" ], "members":{ "Name":{"shape":"NameString"}, "Description":{"shape":"DescriptionString"}, "Database":{"shape":"DatabaseString"}, "QueryString":{"shape":"QueryString"}, "NamedQueryId":{"shape":"NamedQueryId"}, "WorkGroup":{"shape":"WorkGroupName"} } }, "NamedQueryId":{"type":"string"}, "NamedQueryIdList":{ "type":"list", "member":{"shape":"NamedQueryId"}, "max":50, "min":1 }, "NamedQueryList":{ "type":"list", "member":{"shape":"NamedQuery"} }, "QueryExecution":{ "type":"structure", "members":{ "QueryExecutionId":{"shape":"QueryExecutionId"}, "Query":{"shape":"QueryString"}, "StatementType":{"shape":"StatementType"}, "ResultConfiguration":{"shape":"ResultConfiguration"}, "QueryExecutionContext":{"shape":"QueryExecutionContext"}, "Status":{"shape":"QueryExecutionStatus"}, "Statistics":{"shape":"QueryExecutionStatistics"}, "WorkGroup":{"shape":"WorkGroupName"} } }, "QueryExecutionContext":{ "type":"structure", "members":{ "Database":{"shape":"DatabaseString"} } }, "QueryExecutionId":{"type":"string"}, "QueryExecutionIdList":{ "type":"list", "member":{"shape":"QueryExecutionId"}, "max":50, "min":1 }, "QueryExecutionList":{ "type":"list", "member":{"shape":"QueryExecution"} }, "QueryExecutionState":{ "type":"string", "enum":[ "QUEUED", "RUNNING", "SUCCEEDED", "FAILED", "CANCELLED" ] }, "QueryExecutionStatistics":{ "type":"structure", "members":{ "EngineExecutionTimeInMillis":{"shape":"Long"}, "DataScannedInBytes":{"shape":"Long"}, "DataManifestLocation":{"shape":"String"}, "TotalExecutionTimeInMillis":{"shape":"Long"}, "QueryQueueTimeInMillis":{"shape":"Long"}, "QueryPlanningTimeInMillis":{"shape":"Long"}, "ServiceProcessingTimeInMillis":{"shape":"Long"} } }, "QueryExecutionStatus":{ "type":"structure", "members":{ "State":{"shape":"QueryExecutionState"}, "StateChangeReason":{"shape":"String"}, "SubmissionDateTime":{"shape":"Date"}, "CompletionDateTime":{"shape":"Date"} } }, "QueryString":{ "type":"string", "max":262144, "min":1 }, "ResourceNotFoundException":{ "type":"structure", "members":{ "Message":{"shape":"ErrorMessage"}, "ResourceName":{"shape":"AmazonResourceName"} }, "exception":true }, "ResultConfiguration":{ "type":"structure", "members":{ "OutputLocation":{"shape":"String"}, "EncryptionConfiguration":{"shape":"EncryptionConfiguration"} } }, "ResultConfigurationUpdates":{ "type":"structure", "members":{ "OutputLocation":{"shape":"String"}, "RemoveOutputLocation":{"shape":"BoxedBoolean"}, "EncryptionConfiguration":{"shape":"EncryptionConfiguration"}, "RemoveEncryptionConfiguration":{"shape":"BoxedBoolean"} } }, "ResultSet":{ "type":"structure", "members":{ "Rows":{"shape":"RowList"}, "ResultSetMetadata":{"shape":"ResultSetMetadata"} } }, "ResultSetMetadata":{ "type":"structure", "members":{ "ColumnInfo":{"shape":"ColumnInfoList"} } }, "Row":{ "type":"structure", "members":{ "Data":{"shape":"datumList"} } }, "RowList":{ "type":"list", "member":{"shape":"Row"} }, "StartQueryExecutionInput":{ "type":"structure", "required":["QueryString"], "members":{ "QueryString":{"shape":"QueryString"}, "ClientRequestToken":{ "shape":"IdempotencyToken", "idempotencyToken":true }, "QueryExecutionContext":{"shape":"QueryExecutionContext"}, "ResultConfiguration":{"shape":"ResultConfiguration"}, "WorkGroup":{"shape":"WorkGroupName"} } }, "StartQueryExecutionOutput":{ "type":"structure", "members":{ "QueryExecutionId":{"shape":"QueryExecutionId"} } }, "StatementType":{ "type":"string", "enum":[ "DDL", "DML", "UTILITY" ] }, "StopQueryExecutionInput":{ "type":"structure", "required":["QueryExecutionId"], "members":{ "QueryExecutionId":{ "shape":"QueryExecutionId", "idempotencyToken":true } } }, "StopQueryExecutionOutput":{ "type":"structure", "members":{ } }, "String":{"type":"string"}, "Tag":{ "type":"structure", "members":{ "Key":{"shape":"TagKey"}, "Value":{"shape":"TagValue"} } }, "TagKey":{ "type":"string", "max":128, "min":1 }, "TagKeyList":{ "type":"list", "member":{"shape":"TagKey"} }, "TagList":{ "type":"list", "member":{"shape":"Tag"} }, "TagResourceInput":{ "type":"structure", "required":[ "ResourceARN", "Tags" ], "members":{ "ResourceARN":{"shape":"AmazonResourceName"}, "Tags":{"shape":"TagList"} } }, "TagResourceOutput":{ "type":"structure", "members":{ } }, "TagValue":{ "type":"string", "max":256, "min":0 }, "ThrottleReason":{ "type":"string", "enum":["CONCURRENT_QUERY_LIMIT_EXCEEDED"] }, "Token":{ "type":"string", "max":1024, "min":1 }, "TooManyRequestsException":{ "type":"structure", "members":{ "Message":{"shape":"ErrorMessage"}, "Reason":{"shape":"ThrottleReason"} }, "exception":true }, "UnprocessedNamedQueryId":{ "type":"structure", "members":{ "NamedQueryId":{"shape":"NamedQueryId"}, "ErrorCode":{"shape":"ErrorCode"}, "ErrorMessage":{"shape":"ErrorMessage"} } }, "UnprocessedNamedQueryIdList":{ "type":"list", "member":{"shape":"UnprocessedNamedQueryId"} }, "UnprocessedQueryExecutionId":{ "type":"structure", "members":{ "QueryExecutionId":{"shape":"QueryExecutionId"}, "ErrorCode":{"shape":"ErrorCode"}, "ErrorMessage":{"shape":"ErrorMessage"} } }, "UnprocessedQueryExecutionIdList":{ "type":"list", "member":{"shape":"UnprocessedQueryExecutionId"} }, "UntagResourceInput":{ "type":"structure", "required":[ "ResourceARN", "TagKeys" ], "members":{ "ResourceARN":{"shape":"AmazonResourceName"}, "TagKeys":{"shape":"TagKeyList"} } }, "UntagResourceOutput":{ "type":"structure", "members":{ } }, "UpdateWorkGroupInput":{ "type":"structure", "required":["WorkGroup"], "members":{ "WorkGroup":{"shape":"WorkGroupName"}, "Description":{"shape":"WorkGroupDescriptionString"}, "ConfigurationUpdates":{"shape":"WorkGroupConfigurationUpdates"}, "State":{"shape":"WorkGroupState"} } }, "UpdateWorkGroupOutput":{ "type":"structure", "members":{ } }, "WorkGroup":{ "type":"structure", "required":["Name"], "members":{ "Name":{"shape":"WorkGroupName"}, "State":{"shape":"WorkGroupState"}, "Configuration":{"shape":"WorkGroupConfiguration"}, "Description":{"shape":"WorkGroupDescriptionString"}, "CreationTime":{"shape":"Date"} } }, "WorkGroupConfiguration":{ "type":"structure", "members":{ "ResultConfiguration":{"shape":"ResultConfiguration"}, "EnforceWorkGroupConfiguration":{"shape":"BoxedBoolean"}, "PublishCloudWatchMetricsEnabled":{"shape":"BoxedBoolean"}, "BytesScannedCutoffPerQuery":{"shape":"BytesScannedCutoffValue"}, "RequesterPaysEnabled":{"shape":"BoxedBoolean"} } }, "WorkGroupConfigurationUpdates":{ "type":"structure", "members":{ "EnforceWorkGroupConfiguration":{"shape":"BoxedBoolean"}, "ResultConfigurationUpdates":{"shape":"ResultConfigurationUpdates"}, "PublishCloudWatchMetricsEnabled":{"shape":"BoxedBoolean"}, "BytesScannedCutoffPerQuery":{"shape":"BytesScannedCutoffValue"}, "RemoveBytesScannedCutoffPerQuery":{"shape":"BoxedBoolean"}, "RequesterPaysEnabled":{"shape":"BoxedBoolean"} } }, "WorkGroupDescriptionString":{ "type":"string", "max":1024, "min":0 }, "WorkGroupName":{ "type":"string", "pattern":"[a-zA-z0-9._-]{1,128}" }, "WorkGroupState":{ "type":"string", "enum":[ "ENABLED", "DISABLED" ] }, "WorkGroupSummary":{ "type":"structure", "members":{ "Name":{"shape":"WorkGroupName"}, "State":{"shape":"WorkGroupState"}, "Description":{"shape":"WorkGroupDescriptionString"}, "CreationTime":{"shape":"Date"} } }, "WorkGroupsList":{ "type":"list", "member":{"shape":"WorkGroupSummary"}, "max":50, "min":0 }, "datumList":{ "type":"list", "member":{"shape":"Datum"} }, "datumString":{"type":"string"} } }