# Amazon Timestream Write Amazon Timestream for LiveAnalytics ## [Amazon Timestream Write](https://docs.aws.amazon.com/timestream/latest/APIReference/Welcome_Amazon_Timestream_Write.md) Amazon Timestream is a fast, scalable, fully managed time-series database service that makes it easy to store and analyze trillions of time-series data points per day. With Timestream, you can easily store and analyze IoT sensor data to derive insights from your IoT applications. You can analyze industrial telemetry to streamline equipment management and maintenance. You can also store and analyze log data and metrics to improve the performance and availability of your applications. Timestream is built from the ground up to effectively ingest, process, and store time-series data. It organizes data to optimize query processing. It automatically scales based on the volume of data ingested and on the query volume to ensure you receive optimal performance while inserting and querying data. As your data grows over time, Timestream’s adaptive query processing engine spans across storage tiers to provide fast analysis while reducing costs. ### Actions - [CreateBatchLoadTask](https://docs.aws.amazon.com/timestream/latest/APIReference/API_CreateBatchLoadTask.md): Creates a new Timestream batch load task. - [CreateDatabase](https://docs.aws.amazon.com/timestream/latest/APIReference/API_CreateDatabase.md): Creates a new Timestream database. - [CreateTable](https://docs.aws.amazon.com/timestream/latest/APIReference/API_CreateTable.md): Adds a new table to an existing database in your account. - [DeleteDatabase](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DeleteDatabase.md): Deletes a given Timestream database. - [DeleteTable](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DeleteTable.md): Deletes a given Timestream table. - [DescribeBatchLoadTask](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DescribeBatchLoadTask.md): Returns information about the batch load task, including configurations, mappings, progress, and other details. - [DescribeDatabase](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DescribeDatabase.md): Returns information about the database, including the database name, time that the database was created, and the total number of tables found within the database. - [DescribeEndpoints](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DescribeEndpoints.md): Returns a list of available endpoints to make Timestream API calls against. - [DescribeTable](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DescribeTable.md): Returns information about the table, including the table name, database name, retention duration of the memory store and the magnetic store. - [ListBatchLoadTasks](https://docs.aws.amazon.com/timestream/latest/APIReference/API_ListBatchLoadTasks.md): Provides a list of batch load tasks, along with the name, status, when the task is resumable until, and other details. - [ListDatabases](https://docs.aws.amazon.com/timestream/latest/APIReference/API_ListDatabases.md): Returns a list of your Timestream databases. - [ListTables](https://docs.aws.amazon.com/timestream/latest/APIReference/API_ListTables.md): Provides a list of tables, along with the name, status, and retention properties of each table. - [ListTagsForResource](https://docs.aws.amazon.com/timestream/latest/APIReference/API_ListTagsForResource.md): Lists all tags on a Timestream resource. - [ResumeBatchLoadTask](https://docs.aws.amazon.com/timestream/latest/APIReference/API_ResumeBatchLoadTask.md) - [TagResource](https://docs.aws.amazon.com/timestream/latest/APIReference/API_TagResource.md): Associates a set of tags with a Timestream resource. - [UntagResource](https://docs.aws.amazon.com/timestream/latest/APIReference/API_UntagResource.md): Removes the association of tags from a Timestream resource. - [UpdateDatabase](https://docs.aws.amazon.com/timestream/latest/APIReference/API_UpdateDatabase.md): Modifies the AWS KMS key for an existing database. - [UpdateTable](https://docs.aws.amazon.com/timestream/latest/APIReference/API_UpdateTable.md): Modifies the retention duration of the memory store and magnetic store for your Timestream table. - [WriteRecords](https://docs.aws.amazon.com/timestream/latest/APIReference/API_WriteRecords.md): Enables you to write your time-series data into Timestream. ### Data Types - [BatchLoadProgressReport](https://docs.aws.amazon.com/timestream/latest/APIReference/API_BatchLoadProgressReport.md): Details about the progress of a batch load task. - [BatchLoadTask](https://docs.aws.amazon.com/timestream/latest/APIReference/API_BatchLoadTask.md): Details about a batch load task. - [BatchLoadTaskDescription](https://docs.aws.amazon.com/timestream/latest/APIReference/API_BatchLoadTaskDescription.md): Details about a batch load task. - [CsvConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_CsvConfiguration.md): A delimited data format where the column separator can be a comma and the record separator is a newline character. - [Database](https://docs.aws.amazon.com/timestream/latest/APIReference/API_Database.md): A top-level container for a table. - [DataModel](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DataModel.md): Data model for a batch load task. - [DataModelConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DataModelConfiguration.md) - [DataModelS3Configuration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DataModelS3Configuration.md) - [DataSourceConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DataSourceConfiguration.md): Defines configuration details about the data source. - [DataSourceS3Configuration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DataSourceS3Configuration.md) - [Dimension](https://docs.aws.amazon.com/timestream/latest/APIReference/API_Dimension.md): Represents the metadata attributes of the time series. - [DimensionMapping](https://docs.aws.amazon.com/timestream/latest/APIReference/API_DimensionMapping.md) - [Endpoint](https://docs.aws.amazon.com/timestream/latest/APIReference/API_Endpoint.md): Represents an available endpoint against which to make API calls against, as well as the TTL for that endpoint. - [MagneticStoreRejectedDataLocation](https://docs.aws.amazon.com/timestream/latest/APIReference/API_MagneticStoreRejectedDataLocation.md): The location to write error reports for records rejected, asynchronously, during magnetic store writes. - [MagneticStoreWriteProperties](https://docs.aws.amazon.com/timestream/latest/APIReference/API_MagneticStoreWriteProperties.md): The set of properties on a table for configuring magnetic store writes. - [MeasureValue](https://docs.aws.amazon.com/timestream/latest/APIReference/API_MeasureValue.md): Represents the data attribute of the time series. - [MixedMeasureMapping](https://docs.aws.amazon.com/timestream/latest/APIReference/API_MixedMeasureMapping.md) - [MultiMeasureAttributeMapping](https://docs.aws.amazon.com/timestream/latest/APIReference/API_MultiMeasureAttributeMapping.md) - [MultiMeasureMappings](https://docs.aws.amazon.com/timestream/latest/APIReference/API_MultiMeasureMappings.md) - [PartitionKey](https://docs.aws.amazon.com/timestream/latest/APIReference/API_PartitionKey.md): An attribute used in partitioning data in a table. - [Record](https://docs.aws.amazon.com/timestream/latest/APIReference/API_Record.md): Represents a time-series data point being written into Timestream. - [RecordsIngested](https://docs.aws.amazon.com/timestream/latest/APIReference/API_RecordsIngested.md): Information on the records ingested by this request. - [RejectedRecord](https://docs.aws.amazon.com/timestream/latest/APIReference/API_RejectedRecord.md): Represents records that were not successfully inserted into Timestream due to data validation issues that must be resolved before reinserting time-series data into the system. - [ReportConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_ReportConfiguration.md): Report configuration for a batch load task. - [ReportS3Configuration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_ReportS3Configuration.md) - [RetentionProperties](https://docs.aws.amazon.com/timestream/latest/APIReference/API_RetentionProperties.md): Retention properties contain the duration for which your time-series data must be stored in the magnetic store and the memory store. - [S3Configuration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_S3Configuration.md): The configuration that specifies an S3 location. - [Schema](https://docs.aws.amazon.com/timestream/latest/APIReference/API_Schema.md): A Schema specifies the expected data model of the table. - [Table](https://docs.aws.amazon.com/timestream/latest/APIReference/API_Table.md): Represents a database table in Timestream. - [Tag](https://docs.aws.amazon.com/timestream/latest/APIReference/API_Tag.md): A tag is a label that you assign to a Timestream database and/or table. ## [Amazon Timestream Query](https://docs.aws.amazon.com/timestream/latest/APIReference/Welcome_Amazon_Timestream_Query.md) ### Actions - [CancelQuery](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_CancelQuery.md): Cancels a query that has been issued. - [CreateScheduledQuery](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_CreateScheduledQuery.md): Create a scheduled query that will be run on your behalf at the configured schedule. - [DeleteScheduledQuery](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_DeleteScheduledQuery.md): Deletes a given scheduled query. - [DescribeAccountSettings](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_DescribeAccountSettings.md): Describes the settings for your account that include the query pricing model and the configured maximum TCUs the service can use for your query workload. - [DescribeEndpoints](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_DescribeEndpoints.md): DescribeEndpoints returns a list of available endpoints to make Timestream API calls against. - [DescribeScheduledQuery](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_DescribeScheduledQuery.md): Provides detailed information about a scheduled query. - [ExecuteScheduledQuery](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ExecuteScheduledQuery.md): You can use this API to run a scheduled query manually. - [ListScheduledQueries](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ListScheduledQueries.md): Gets a list of all scheduled queries in the caller's Amazon account and Region. - [ListTagsForResource](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ListTagsForResource.md): List all tags on a Timestream query resource. - [PrepareQuery](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_PrepareQuery.md): A synchronous operation that allows you to submit a query with parameters to be stored by Timestream for later running. - [Query](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_Query.md): Query is a synchronous operation that enables you to run a query against your Amazon Timestream data. - [TagResource](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_TagResource.md): Associate a set of tags with a Timestream resource. - [UntagResource](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_UntagResource.md): Removes the association of tags from a Timestream query resource. - [UpdateAccountSettings](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_UpdateAccountSettings.md): Transitions your account to use TCUs for query pricing and modifies the maximum query compute units that you've configured. - [UpdateScheduledQuery](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_UpdateScheduledQuery.md): Update a scheduled query. ### Data Types - [AccountSettingsNotificationConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_AccountSettingsNotificationConfiguration.md): Configuration settings for notifications related to account settings. - [ColumnInfo](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ColumnInfo.md): Contains the metadata for query results such as the column names, data types, and other attributes. - [Datum](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_Datum.md): Datum represents a single data point in a query result. - [DimensionMapping](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_DimensionMapping.md): This type is used to map column(s) from the query result to a dimension in the destination table. - [Endpoint](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_Endpoint.md): Represents an available endpoint against which to make API calls against, as well as the TTL for that endpoint. - [ErrorReportConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ErrorReportConfiguration.md): Configuration required for error reporting. - [ErrorReportLocation](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ErrorReportLocation.md): This contains the location of the error report for a single scheduled query call. - [ExecutionStats](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ExecutionStats.md): Statistics for a single scheduled query run. - [LastUpdate](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_LastUpdate.md): Configuration object that contains the most recent account settings update, visible only if settings have been updated previously. - [MixedMeasureMapping](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_MixedMeasureMapping.md): MixedMeasureMappings are mappings that can be used to ingest data into a mixture of narrow and multi measures in the derived table. - [MultiMeasureAttributeMapping](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_MultiMeasureAttributeMapping.md): Attribute mapping for MULTI value measures. - [MultiMeasureMappings](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_MultiMeasureMappings.md): Only one of MixedMeasureMappings or MultiMeasureMappings is to be provided. - [NotificationConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_NotificationConfiguration.md): Notification configuration for a scheduled query. - [ParameterMapping](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ParameterMapping.md): Mapping for named parameters. - [ProvisionedCapacityRequest](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ProvisionedCapacityRequest.md): A request to update the provisioned capacity settings for querying data. - [ProvisionedCapacityResponse](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ProvisionedCapacityResponse.md): The response to a request to update the provisioned capacity settings for querying data. - [QueryComputeRequest](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_QueryComputeRequest.md): A request to retrieve or update the compute capacity settings for querying data. - [QueryComputeResponse](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_QueryComputeResponse.md): The response to a request to retrieve or update the compute capacity settings for querying data. - [QueryInsights](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_QueryInsights.md): QueryInsights is a performance tuning feature that helps you optimize your queries, reducing costs and improving performance. - [QueryInsightsResponse](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_QueryInsightsResponse.md): Provides various insights and metrics related to the query that you executed. - [QuerySpatialCoverage](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_QuerySpatialCoverage.md): Provides insights into the spatial coverage of the query, including the table with sub-optimal (max) spatial pruning. - [QuerySpatialCoverageMax](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_QuerySpatialCoverageMax.md): Provides insights into the table with the most sub-optimal spatial range scanned by your query. - [QueryStatus](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_QueryStatus.md): Information about the status of the query, including progress and bytes scanned. - [QueryTemporalRange](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_QueryTemporalRange.md): Provides insights into the temporal range of the query, including the table with the largest (max) time range. - [QueryTemporalRangeMax](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_QueryTemporalRangeMax.md): Provides insights into the table with the most sub-optimal temporal pruning scanned by your query. - [Row](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_Row.md): Represents a single row in the query results. - [S3Configuration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_S3Configuration.md): Details on S3 location for error reports that result from running a query. - [S3ReportLocation](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_S3ReportLocation.md): S3 report location for the scheduled query run. - [ScheduleConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ScheduleConfiguration.md): Configuration of the schedule of the query. - [ScheduledQuery](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ScheduledQuery.md): Scheduled Query - [ScheduledQueryDescription](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ScheduledQueryDescription.md): Structure that describes scheduled query. - [ScheduledQueryInsights](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ScheduledQueryInsights.md): Encapsulates settings for enabling QueryInsights on an ExecuteScheduledQueryRequest. - [ScheduledQueryInsightsResponse](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ScheduledQueryInsightsResponse.md): Provides various insights and metrics related to the ExecuteScheduledQueryRequest that was executed. - [ScheduledQueryRunSummary](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_ScheduledQueryRunSummary.md): Run summary for the scheduled query - [SelectColumn](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_SelectColumn.md): Details of the column that is returned by the query. - [SnsConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_SnsConfiguration.md): Details on SNS that are required to send the notification. - [Tag](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_Tag.md): A tag is a label that you assign to a Timestream database and/or table. - [TargetConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_TargetConfiguration.md): Configuration used for writing the output of a query. - [TargetDestination](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_TargetDestination.md): Destination details to write data for a target data source. - [TimeSeriesDataPoint](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_TimeSeriesDataPoint.md): The timeseries data type represents the values of a measure over time. - [TimestreamConfiguration](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_TimestreamConfiguration.md): Configuration to write data into Timestream database and table. - [TimestreamDestination](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_TimestreamDestination.md): Destination for scheduled query. - [Type](https://docs.aws.amazon.com/timestream/latest/APIReference/API_query_Type.md): Contains the data type of a column in a query result set. ## Common - [Common Parameters](https://docs.aws.amazon.com/timestream/latest/APIReference/CommonParameters.md) - [Common Error Types](https://docs.aws.amazon.com/timestream/latest/APIReference/CommonErrors.md) ## Full content The entire guide is also available as a single markdown file, useful for feeding the full guide to an LLM in one pass: - [Complete guide (single file)](https://docs.aws.amazon.com/timestream/latest/APIReference/full.md)