TimestreamWrite / Client / create_table

create_table#

TimestreamWrite.Client.create_table(**kwargs)#

Adds a new table to an existing database in your account. In an Amazon Web Services account, table names must be at least unique within each Region if they are in the same database. You might have identical table names in the same Region if the tables are in separate databases. While creating the table, you must specify the table name, database name, and the retention properties. Service quotas apply. See code sample for details.

Request Syntax

response = client.create_table(
    DatabaseName='string',
    TableName='string',
    RetentionProperties={
        'MemoryStoreRetentionPeriodInHours': 123,
        'MagneticStoreRetentionPeriodInDays': 123
    },
    Tags=[
        {
            'Key': 'string',
            'Value': 'string'
        },
    ],
    MagneticStoreWriteProperties={
        'EnableMagneticStoreWrites': True|False,
        'MagneticStoreRejectedDataLocation': {
            'S3Configuration': {
                'BucketName': 'string',
                'ObjectKeyPrefix': 'string',
                'EncryptionOption': 'SSE_S3'|'SSE_KMS',
                'KmsKeyId': 'string'
            }
        }
    }
)

Parameters:

DatabaseName (string) –
[REQUIRED]

The name of the Timestream database.
TableName (string) –
[REQUIRED]

The name of the Timestream table.
RetentionProperties (dict) –
The duration for which your time-series data must be stored in the memory store and the magnetic store.
- MemoryStoreRetentionPeriodInHours (integer) – [REQUIRED]
  
  The duration for which data must be stored in the memory store.
- MagneticStoreRetentionPeriodInDays (integer) – [REQUIRED]
  
  The duration for which data must be stored in the magnetic store.
Tags (list) –
A list of key-value pairs to label the table.
- (dict) –
  
  A tag is a label that you assign to a Timestream database and/or table. Each tag consists of a key and an optional value, both of which you define. With tags, you can categorize databases and/or tables, for example, by purpose, owner, or environment.
  - Key (string) – [REQUIRED]
    
    The key of the tag. Tag keys are case sensitive.
  - Value (string) – [REQUIRED]
    
    The value of the tag. Tag values are case-sensitive and can be null.
MagneticStoreWriteProperties (dict) –
Contains properties to set on the table when enabling magnetic store writes.
- EnableMagneticStoreWrites (boolean) – [REQUIRED]
  
  A flag to enable magnetic store writes.
- MagneticStoreRejectedDataLocation (dict) –
  
  The location to write error reports for records rejected asynchronously during magnetic store writes.
  - S3Configuration (dict) –
    
    Configuration of an S3 location to write error reports for records rejected, asynchronously, during magnetic store writes.
    - BucketName (string) –
      
      The bucket name of the customer S3 bucket.
    - ObjectKeyPrefix (string) –
      
      The object key preview for the customer S3 location.
    - EncryptionOption (string) –
      
      The encryption option for the customer S3 location. Options are S3 server-side encryption with an S3 managed key or Amazon Web Services managed key.
    - KmsKeyId (string) –
      
      The KMS key ID for the customer S3 location when encrypting with an Amazon Web Services managed key.

Return type:

dict

Returns:

Response Syntax

{
    'Table': {
        'Arn': 'string',
        'TableName': 'string',
        'DatabaseName': 'string',
        'TableStatus': 'ACTIVE'|'DELETING'|'RESTORING',
        'RetentionProperties': {
            'MemoryStoreRetentionPeriodInHours': 123,
            'MagneticStoreRetentionPeriodInDays': 123
        },
        'CreationTime': datetime(2015, 1, 1),
        'LastUpdatedTime': datetime(2015, 1, 1),
        'MagneticStoreWriteProperties': {
            'EnableMagneticStoreWrites': True|False,
            'MagneticStoreRejectedDataLocation': {
                'S3Configuration': {
                    'BucketName': 'string',
                    'ObjectKeyPrefix': 'string',
                    'EncryptionOption': 'SSE_S3'|'SSE_KMS',
                    'KmsKeyId': 'string'
                }
            }
        }
    }
}

Response Structure

(dict) –
- Table (dict) –
  
  The newly created Timestream table.
  - Arn (string) –
    
    The Amazon Resource Name that uniquely identifies this table.
  - TableName (string) –
    
    The name of the Timestream table.
  - DatabaseName (string) –
    
    The name of the Timestream database that contains this table.
  - TableStatus (string) –
    
    The current state of the table:
    - DELETING - The table is being deleted.
    - ACTIVE - The table is ready for use.
  - RetentionProperties (dict) –
    
    The retention duration for the memory store and magnetic store.
    - MemoryStoreRetentionPeriodInHours (integer) –
      
      The duration for which data must be stored in the memory store.
    - MagneticStoreRetentionPeriodInDays (integer) –
      
      The duration for which data must be stored in the magnetic store.
  - CreationTime (datetime) –
    
    The time when the Timestream table was created.
  - LastUpdatedTime (datetime) –
    
    The time when the Timestream table was last updated.
  - MagneticStoreWriteProperties (dict) –
    
    Contains properties to set on the table when enabling magnetic store writes.
    - EnableMagneticStoreWrites (boolean) –
      
      A flag to enable magnetic store writes.
    - MagneticStoreRejectedDataLocation (dict) –
      
      The location to write error reports for records rejected asynchronously during magnetic store writes.
      - S3Configuration (dict) –
        
        Configuration of an S3 location to write error reports for records rejected, asynchronously, during magnetic store writes.
        
        BucketName (string) –
        
        The bucket name of the customer S3 bucket.
        
        ObjectKeyPrefix (string) –
        
        The object key preview for the customer S3 location.
        
        EncryptionOption (string) –
        
        The encryption option for the customer S3 location. Options are S3 server-side encryption with an S3 managed key or Amazon Web Services managed key.
        
        KmsKeyId (string) –
        
        The KMS key ID for the customer S3 location when encrypting with an Amazon Web Services managed key.

Exceptions

TimestreamWrite.Client.exceptions.ConflictException
TimestreamWrite.Client.exceptions.ValidationException
TimestreamWrite.Client.exceptions.AccessDeniedException
TimestreamWrite.Client.exceptions.ResourceNotFoundException
TimestreamWrite.Client.exceptions.ServiceQuotaExceededException
TimestreamWrite.Client.exceptions.ThrottlingException
TimestreamWrite.Client.exceptions.InvalidEndpointException
TimestreamWrite.Client.exceptions.InternalServerException
TimestreamWrite.Client.exceptions.InvalidEndpointException