influxdb_instances

Creates, updates, deletes or gets an influxdb_instance resource or lists influxdb_instances in a region

Overview

Name	influxdb_instances
Type	Resource
Description	The AWS::Timestream::InfluxDBInstance resource creates an InfluxDB instance.
Id	aws.timestream.influxdb_instances

Fields

Name	Datatype	Description
username	string	The username for the InfluxDB instance.
password	string	The password for the InfluxDB instance.
organization	string	The organization for the InfluxDB instance.
bucket	string	The bucket for the InfluxDB instance.
db_instance_type	string	The compute instance of the InfluxDB instance.
vpc_subnet_ids	array	A list of EC2 subnet IDs for this InfluxDB instance.
vpc_security_group_ids	array	A list of Amazon EC2 VPC security groups to associate with this InfluxDB instance.
publicly_accessible	boolean	Attach a public IP to the customer ENI.
db_storage_type	string	The storage type of the InfluxDB instance.
allocated_storage	integer	The allocated storage for the InfluxDB instance.
db_parameter_group_identifier	string	The name of an existing InfluxDB parameter group.
log_delivery_configuration	object	Configuration for sending logs to customer account from the InfluxDB instance.
status	string	Status of the InfluxDB Instance.
arn	string	The Amazon Resource Name (ARN) that is associated with the InfluxDB instance.
name	string	The unique name that is associated with the InfluxDB instance.
availability_zone	string	The Availability Zone (AZ) where the InfluxDB instance is created.
secondary_availability_zone	string	The Secondary Availability Zone (AZ) where the InfluxDB instance is created, if DeploymentType is set as WITH_MULTIAZ_STANDBY.
endpoint	string	The connection endpoint for the InfluxDB instance.
influx_auth_parameters_secret_arn	string	The Auth parameters secret Amazon Resource name (ARN) that is associated with the InfluxDB instance.
id	string	The service generated unique identifier for InfluxDB instance.
deployment_type	string	Deployment type of the InfluxDB Instance.
tags	array	An arbitrary set of tags (key-value pairs) for this DB instance.
region	string	AWS region.

Methods

Name	Accessible by	Required Params
create_resource	INSERT	region
delete_resource	DELETE	data__Identifier, region
update_resource	UPDATE	data__Identifier, data__PatchDocument, region
list_resources	SELECT	region
get_resource	SELECT	data__Identifier, region

SELECT examples

Gets all influxdb_instances in a region.

SELECT
region,
username,
password,
organization,
bucket,
db_instance_type,
vpc_subnet_ids,
vpc_security_group_ids,
publicly_accessible,
db_storage_type,
allocated_storage,
db_parameter_group_identifier,
log_delivery_configuration,
status,
arn,
name,
availability_zone,
secondary_availability_zone,
endpoint,
influx_auth_parameters_secret_arn,
id,
deployment_type,
tags
FROM aws.timestream.influxdb_instances
WHERE region = 'us-east-1';

Gets all properties from an individual influxdb_instance.

SELECT
region,
username,
password,
organization,
bucket,
db_instance_type,
vpc_subnet_ids,
vpc_security_group_ids,
publicly_accessible,
db_storage_type,
allocated_storage,
db_parameter_group_identifier,
log_delivery_configuration,
status,
arn,
name,
availability_zone,
secondary_availability_zone,
endpoint,
influx_auth_parameters_secret_arn,
id,
deployment_type,
tags
FROM aws.timestream.influxdb_instances
WHERE region = 'us-east-1' AND data__Identifier = '<Id>';

INSERT example

Use the following StackQL query and manifest file to create a new influxdb_instance resource, using stack-deploy.

Required Properties

/*+ create */
INSERT INTO aws.timestream.influxdb_instances (
 Username,
 Password,
 Organization,
 Bucket,
 DbInstanceType,
 VpcSubnetIds,
 VpcSecurityGroupIds,
 PubliclyAccessible,
 DbStorageType,
 AllocatedStorage,
 DbParameterGroupIdentifier,
 LogDeliveryConfiguration,
 Name,
 DeploymentType,
 Tags,
 region
)
SELECT 
'{{ Username }}',
 '{{ Password }}',
 '{{ Organization }}',
 '{{ Bucket }}',
 '{{ DbInstanceType }}',
 '{{ VpcSubnetIds }}',
 '{{ VpcSecurityGroupIds }}',
 '{{ PubliclyAccessible }}',
 '{{ DbStorageType }}',
 '{{ AllocatedStorage }}',
 '{{ DbParameterGroupIdentifier }}',
 '{{ LogDeliveryConfiguration }}',
 '{{ Name }}',
 '{{ DeploymentType }}',
 '{{ Tags }}',
'{{ region }}';

All Properties

/*+ create */
INSERT INTO aws.timestream.influxdb_instances (
 Username,
 Password,
 Organization,
 Bucket,
 DbInstanceType,
 VpcSubnetIds,
 VpcSecurityGroupIds,
 PubliclyAccessible,
 DbStorageType,
 AllocatedStorage,
 DbParameterGroupIdentifier,
 LogDeliveryConfiguration,
 Name,
 DeploymentType,
 Tags,
 region
)
SELECT 
 '{{ Username }}',
 '{{ Password }}',
 '{{ Organization }}',
 '{{ Bucket }}',
 '{{ DbInstanceType }}',
 '{{ VpcSubnetIds }}',
 '{{ VpcSecurityGroupIds }}',
 '{{ PubliclyAccessible }}',
 '{{ DbStorageType }}',
 '{{ AllocatedStorage }}',
 '{{ DbParameterGroupIdentifier }}',
 '{{ LogDeliveryConfiguration }}',
 '{{ Name }}',
 '{{ DeploymentType }}',
 '{{ Tags }}',
 '{{ region }}';

Manifest

version: 1
name: stack name
description: stack description
providers:
  - aws
globals:
  - name: region
    value: '{{ vars.AWS_REGION }}'
resources:
  - name: influxdb_instance
    props:
      - name: Username
        value: '{{ Username }}'
      - name: Password
        value: '{{ Password }}'
      - name: Organization
        value: '{{ Organization }}'
      - name: Bucket
        value: '{{ Bucket }}'
      - name: DbInstanceType
        value: '{{ DbInstanceType }}'
      - name: VpcSubnetIds
        value:
          - '{{ VpcSubnetIds[0] }}'
      - name: VpcSecurityGroupIds
        value:
          - '{{ VpcSecurityGroupIds[0] }}'
      - name: PubliclyAccessible
        value: '{{ PubliclyAccessible }}'
      - name: DbStorageType
        value: '{{ DbStorageType }}'
      - name: AllocatedStorage
        value: '{{ AllocatedStorage }}'
      - name: DbParameterGroupIdentifier
        value: '{{ DbParameterGroupIdentifier }}'
      - name: LogDeliveryConfiguration
        value:
          S3Configuration:
            BucketName: '{{ BucketName }}'
            Enabled: '{{ Enabled }}'
      - name: Name
        value: '{{ Name }}'
      - name: DeploymentType
        value: '{{ DeploymentType }}'
      - name: Tags
        value:
          - Key: '{{ Key }}'
            Value: '{{ Value }}'

DELETE example

/*+ delete */
DELETE FROM aws.timestream.influxdb_instances
WHERE data__Identifier = '<Id>'
AND region = 'us-east-1';

Permissions

To operate on the influxdb_instances resource, the following permissions are required:

Create

s3:ListBucket,
s3:GetBucketPolicy,
timestream-influxdb:GetDbInstance,
timestream-influxdb:ListDbInstances,
timestream-influxdb:CreateDbInstance,
timestream-influxdb:TagResource,
timestream-influxdb:ListTagsForResource,
ec2:DescribeSubnets,
ec2:DescribeVpcs,
ec2:DescribeNetworkInterfaces,
ec2:DescribeSecurityGroups,
ec2:CreateNetworkInterface,
iam:CreateServiceLinkedRole

Read

timestream-influxdb:GetDbInstance,
timestream-influxdb:ListTagsForResource

Update

s3:ListBucket,
s3:GetBucketPolicy,
timestream-influxdb:GetDbInstance,
timestream-influxdb:ListDbInstances,
timestream-influxdb:UpdateDbInstance,
timestream-influxdb:TagResource,
timestream-influxdb:UntagResource,
timestream-influxdb:ListTagsForResource

Delete

timestream-influxdb:GetDbInstance,
timestream-influxdb:ListDbInstances,
timestream-influxdb:DeleteDbInstance

List

timestream-influxdb:ListDbInstances