CreateExport
Creates a data export and specifies the data query, the delivery preference, and any optional resource tags.
A DataQuery consists of both a QueryStatement and
TableConfigurations.
The QueryStatement is an SQL statement. Data Exports only supports a limited
subset of the SQL syntax. For more information on the SQL syntax that is supported, see Data query. To
view the available tables and columns, see the Data Exports table
dictionary.
The TableConfigurations is a collection of specified
TableProperties for the table being queried in the QueryStatement.
TableProperties are additional configurations you can provide to change the data and schema of
a table. Each table can have different TableProperties. However, tables are not required to
have any TableProperties. Each table property has a default value that it assumes if not
specified. For more information on table configurations, see Data query. To
view the table properties available for each table, see the Data Exports table
dictionary or use the ListTables API to get a response of all tables
and their available properties.
Request Syntax
{
"Export": {
"DataQuery": {
"QueryStatement": "string",
"TableConfigurations": {
"string" : {
"string" : "string"
}
}
},
"Description": "string",
"DestinationConfigurations": {
"S3Destination": {
"S3Bucket": "string",
"S3OutputConfigurations": {
"Compression": "string",
"Format": "string",
"OutputType": "string",
"Overwrite": "string"
},
"S3Prefix": "string",
"S3Region": "string"
}
},
"ExportArn": "string",
"Name": "string",
"RefreshCadence": {
"Frequency": "string"
}
},
"ResourceTags": [
{
"Key": "string",
"Value": "string"
}
]
}Request Parameters
For information about the parameters that are common to all actions, see Common Parameters.
The request accepts the following data in JSON format.
- Export
-
The details of the export, including data query, name, description, and destination configuration.
Type: Export object
Required: Yes
- ResourceTags
-
An optional list of tags to associate with the specified export. Each tag consists of a key and a value, and each key must be unique for the resource.
Type: Array of ResourceTag objects
Array Members: Minimum number of 0 items. Maximum number of 200 items.
Required: No
Response Syntax
{
"ExportArn": "string"
}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.
- ExportArn
-
The Amazon Resource Name (ARN) for this export.
Type: String
Length Constraints: Minimum length of 20. Maximum length of 2048.
Pattern:
^arn:aws[-a-z0-9]*:[-a-z0-9]+:[-a-z0-9]*:[0-9]{12}:[-a-zA-Z0-9/:_]+$
Errors
For information about the errors that are common to all actions, see Common Errors.
- InternalServerException
-
An error on the server occurred during the processing of your request. Try again later.
HTTP Status Code: 500
- ServiceQuotaExceededException
-
You've reached the limit on the number of resources you can create, or exceeded the size of an individual resource.
HTTP Status Code: 400
- ThrottlingException
-
The request was denied due to request throttling.
HTTP Status Code: 400
- ValidationException
-
The input fails to satisfy the constraints specified by an AWS service.
HTTP Status Code: 400
Examples
The following is a sample request of the CreateExport operation.
This example illustrates one usage of CreateExport.
Sample Request
{
"Export": {
"Name": "ExampleExportName",
"Description": "Example Description",
"DataQuery": {
"QueryStatement": "SELECT identity_line_item_id, identity_time_interval, line_item_product_code,line_item_unblended_cost FROM COST_AND_USAGE_REPORT",
"TableConfigurations": {
"COST_AND_USAGE_REPORT": {
"TIME_GRANULARITY": "DAILY",
"INCLUDE_RESOURCES": "FALSE",
"INCLUDE_MANUAL_DISCOUNT_COMPATIBILITY": "FALSE",
"INCLUDE_SPLIT_COST_ALLOCATION_DATA": "FALSE"
}
}
},
"DestinationConfigurations": {
"S3Destination": {
"S3Bucket": "ExampleS3Bucket",
"S3Prefix": "ExampleS3Prefix",
"S3Region": "us-east-1",
"S3OutputConfigurations": {
"Overwrite": "OVERWRITE_REPORT",
"Format": "TEXT_OR_CSV",
"Compression": "GZIP",
"OutputType": "CUSTOM"
}
}
},
"RefreshCadence": {
"Frequency": "SYNCHRONOUS"
}
},
"ResourceTags": [
{
"Key": "YourTagKey",
"Value": "YourTagValue"
}
]
}The following is a sample response of the CreateExport operation.
This example illustrates one usage of CreateExport.
Sample Response
{
"ExportArn": "arn:aws:bcm-data-exports:::export/Example-b9ac8e7c-6a49-468f-a43e-9ce6b5b051d1"
}See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following:
