Docs Packages
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Nosql
  5. Table
Oracle Cloud Infrastructure v1.11.0 published on Wednesday, Sep 27, 2023 by Pulumi
pulumi/pulumi-oci

oci.Nosql.Table

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.11.0 published on Wednesday, Sep 27, 2023 by Pulumi
pulumi/pulumi-oci

    This resource provides the Table resource in Oracle Cloud Infrastructure NoSQL Database service.

    Create a new table.

    Example Usage

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testTable = new Oci.Nosql.Table("testTable", new()
    {
        CompartmentId = @var.Compartment_id,
        DdlStatement = @var.Table_ddl_statement,
        DefinedTags = @var.Table_defined_tags,
        FreeformTags = 
        {
            { "bar-key", "value" },
        },
        IsAutoReclaimable = @var.Table_is_auto_reclaimable,
        TableLimits = new Oci.Nosql.Inputs.TableTableLimitsArgs
        {
            MaxReadUnits = @var.Table_table_limits_max_read_units,
            MaxStorageInGbs = @var.Table_table_limits_max_storage_in_gbs,
            MaxWriteUnits = @var.Table_table_limits_max_write_units,
            CapacityMode = @var.Table_table_limits_capacity_mode,
        },
    });

});

    package main

import (
	"github.com/pulumi/pulumi-oci/sdk/go/oci/Nosql"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := Nosql.NewTable(ctx, "testTable", &Nosql.TableArgs{
			CompartmentId: pulumi.Any(_var.Compartment_id),
			DdlStatement:  pulumi.Any(_var.Table_ddl_statement),
			DefinedTags:   pulumi.Any(_var.Table_defined_tags),
			FreeformTags: pulumi.AnyMap{
				"bar-key": pulumi.Any("value"),
			},
			IsAutoReclaimable: pulumi.Any(_var.Table_is_auto_reclaimable),
			TableLimits: &nosql.TableTableLimitsArgs{
				MaxReadUnits:    pulumi.Any(_var.Table_table_limits_max_read_units),
				MaxStorageInGbs: pulumi.Any(_var.Table_table_limits_max_storage_in_gbs),
				MaxWriteUnits:   pulumi.Any(_var.Table_table_limits_max_write_units),
				CapacityMode:    pulumi.Any(_var.Table_table_limits_capacity_mode),
			},
		})
		if err != nil {
			return err
		}
		return nil
	})
}

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Nosql.Table;
import com.pulumi.oci.Nosql.TableArgs;
import com.pulumi.oci.Nosql.inputs.TableTableLimitsArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        var testTable = new Table("testTable", TableArgs.builder()        
            .compartmentId(var_.compartment_id())
            .ddlStatement(var_.table_ddl_statement())
            .definedTags(var_.table_defined_tags())
            .freeformTags(Map.of("bar-key", "value"))
            .isAutoReclaimable(var_.table_is_auto_reclaimable())
            .tableLimits(TableTableLimitsArgs.builder()
                .maxReadUnits(var_.table_table_limits_max_read_units())
                .maxStorageInGbs(var_.table_table_limits_max_storage_in_gbs())
                .maxWriteUnits(var_.table_table_limits_max_write_units())
                .capacityMode(var_.table_table_limits_capacity_mode())
                .build())
            .build());

    }
}

    import pulumi
import pulumi_oci as oci

test_table = oci.nosql.Table("testTable",
    compartment_id=var["compartment_id"],
    ddl_statement=var["table_ddl_statement"],
    defined_tags=var["table_defined_tags"],
    freeform_tags={
        "bar-key": "value",
    },
    is_auto_reclaimable=var["table_is_auto_reclaimable"],
    table_limits=oci.nosql.TableTableLimitsArgs(
        max_read_units=var["table_table_limits_max_read_units"],
        max_storage_in_gbs=var["table_table_limits_max_storage_in_gbs"],
        max_write_units=var["table_table_limits_max_write_units"],
        capacity_mode=var["table_table_limits_capacity_mode"],
    ))

    import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testTable = new oci.nosql.Table("testTable", {
    compartmentId: _var.compartment_id,
    ddlStatement: _var.table_ddl_statement,
    definedTags: _var.table_defined_tags,
    freeformTags: {
        "bar-key": "value",
    },
    isAutoReclaimable: _var.table_is_auto_reclaimable,
    tableLimits: {
        maxReadUnits: _var.table_table_limits_max_read_units,
        maxStorageInGbs: _var.table_table_limits_max_storage_in_gbs,
        maxWriteUnits: _var.table_table_limits_max_write_units,
        capacityMode: _var.table_table_limits_capacity_mode,
    },
});

    resources:
  testTable:
    type: oci:Nosql:Table
    properties:
      #Required
      compartmentId: ${var.compartment_id}
      ddlStatement: ${var.table_ddl_statement}
      #Optional
      definedTags: ${var.table_defined_tags}
      freeformTags:
        bar-key: value
      isAutoReclaimable: ${var.table_is_auto_reclaimable}
      tableLimits:
        maxReadUnits: ${var.table_table_limits_max_read_units}
        maxStorageInGbs: ${var.table_table_limits_max_storage_in_gbs}
        maxWriteUnits: ${var.table_table_limits_max_write_units}
        capacityMode: ${var.table_table_limits_capacity_mode}

    Create Table Resource

    new Table(name: string, args: TableArgs, opts?: CustomResourceOptions);
    @overload
def Table(resource_name: str,
          opts: Optional[ResourceOptions] = None,
          compartment_id: Optional[str] = None,
          ddl_statement: Optional[str] = None,
          defined_tags: Optional[Mapping[str, Any]] = None,
          freeform_tags: Optional[Mapping[str, Any]] = None,
          is_auto_reclaimable: Optional[bool] = None,
          name: Optional[str] = None,
          table_limits: Optional[_nosql.TableTableLimitsArgs] = None)
@overload
def Table(resource_name: str,
          args: TableArgs,
          opts: Optional[ResourceOptions] = None)
    func NewTable(ctx *Context, name string, args TableArgs, opts ...ResourceOption) (*Table, error)
    public Table(string name, TableArgs args, CustomResourceOptions? opts = null)
    public Table(String name, TableArgs args)
public Table(String name, TableArgs args, CustomResourceOptions options)

    type: oci:Nosql:Table
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args TableArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args TableArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args TableArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args TableArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args TableArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Table Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    The Table resource accepts the following input properties:

    CompartmentId string

    (Updatable) Compartment Identifier.

    DdlStatement string

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    DefinedTags Dictionary<string, object>

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    FreeformTags Dictionary<string, object>

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    IsAutoReclaimable bool

    True if table can be reclaimed after an idle period.

    Name string

    Table name.

    TableLimits TableTableLimits

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    CompartmentId string

    (Updatable) Compartment Identifier.

    DdlStatement string

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    DefinedTags map[string]interface{}

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    FreeformTags map[string]interface{}

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    IsAutoReclaimable bool

    True if table can be reclaimed after an idle period.

    Name string

    Table name.

    TableLimits TableTableLimitsArgs

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    compartmentId String

    (Updatable) Compartment Identifier.

    ddlStatement String

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    definedTags Map<String,Object>

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    freeformTags Map<String,Object>

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    isAutoReclaimable Boolean

    True if table can be reclaimed after an idle period.

    name String

    Table name.

    tableLimits TableTableLimits

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    compartmentId string

    (Updatable) Compartment Identifier.

    ddlStatement string

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    definedTags {[key: string]: any}

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    freeformTags {[key: string]: any}

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    isAutoReclaimable boolean

    True if table can be reclaimed after an idle period.

    name string

    Table name.

    tableLimits TableTableLimits

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    compartment_id str

    (Updatable) Compartment Identifier.

    ddl_statement str

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    defined_tags Mapping[str, Any]

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    freeform_tags Mapping[str, Any]

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    is_auto_reclaimable bool

    True if table can be reclaimed after an idle period.

    name str

    Table name.

    table_limits TableTableLimitsArgs

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    compartmentId String

    (Updatable) Compartment Identifier.

    ddlStatement String

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    definedTags Map<Any>

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    freeformTags Map<Any>

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    isAutoReclaimable Boolean

    True if table can be reclaimed after an idle period.

    name String

    Table name.

    tableLimits Property Map

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the Table resource produces the following output properties:

    Id string

    The provider-assigned unique ID for this managed resource.

    LifecycleDetails string

    A message describing the current state in more detail.

    Schemas List<TableSchema>

    The table schema information as a JSON object.

    State string

    The state of a table.

    SystemTags Dictionary<string, object>

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    TimeCreated string

    The time the the table was created. An RFC3339 formatted datetime string.

    TimeOfExpiration string

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    TimeUpdated string

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    Id string

    The provider-assigned unique ID for this managed resource.

    LifecycleDetails string

    A message describing the current state in more detail.

    Schemas []TableSchema

    The table schema information as a JSON object.

    State string

    The state of a table.

    SystemTags map[string]interface{}

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    TimeCreated string

    The time the the table was created. An RFC3339 formatted datetime string.

    TimeOfExpiration string

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    TimeUpdated string

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    id String

    The provider-assigned unique ID for this managed resource.

    lifecycleDetails String

    A message describing the current state in more detail.

    schemas List<TableSchema>

    The table schema information as a JSON object.

    state String

    The state of a table.

    systemTags Map<String,Object>

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    timeCreated String

    The time the the table was created. An RFC3339 formatted datetime string.

    timeOfExpiration String

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    timeUpdated String

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    id string

    The provider-assigned unique ID for this managed resource.

    lifecycleDetails string

    A message describing the current state in more detail.

    schemas TableSchema[]

    The table schema information as a JSON object.

    state string

    The state of a table.

    systemTags {[key: string]: any}

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    timeCreated string

    The time the the table was created. An RFC3339 formatted datetime string.

    timeOfExpiration string

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    timeUpdated string

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    id str

    The provider-assigned unique ID for this managed resource.

    lifecycle_details str

    A message describing the current state in more detail.

    schemas TableSchema]

    The table schema information as a JSON object.

    state str

    The state of a table.

    system_tags Mapping[str, Any]

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    time_created str

    The time the the table was created. An RFC3339 formatted datetime string.

    time_of_expiration str

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    time_updated str

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    id String

    The provider-assigned unique ID for this managed resource.

    lifecycleDetails String

    A message describing the current state in more detail.

    schemas List<Property Map>

    The table schema information as a JSON object.

    state String

    The state of a table.

    systemTags Map<Any>

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    timeCreated String

    The time the the table was created. An RFC3339 formatted datetime string.

    timeOfExpiration String

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    timeUpdated String

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    Look up Existing Table Resource

    Get an existing Table resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: TableState, opts?: CustomResourceOptions): Table
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        compartment_id: Optional[str] = None,
        ddl_statement: Optional[str] = None,
        defined_tags: Optional[Mapping[str, Any]] = None,
        freeform_tags: Optional[Mapping[str, Any]] = None,
        is_auto_reclaimable: Optional[bool] = None,
        lifecycle_details: Optional[str] = None,
        name: Optional[str] = None,
        schemas: Optional[Sequence[_nosql.TableSchemaArgs]] = None,
        state: Optional[str] = None,
        system_tags: Optional[Mapping[str, Any]] = None,
        table_limits: Optional[_nosql.TableTableLimitsArgs] = None,
        time_created: Optional[str] = None,
        time_of_expiration: Optional[str] = None,
        time_updated: Optional[str] = None) -> Table
    func GetTable(ctx *Context, name string, id IDInput, state *TableState, opts ...ResourceOption) (*Table, error)
    public static Table Get(string name, Input<string> id, TableState? state, CustomResourceOptions? opts = null)
    public static Table get(String name, Output<String> id, TableState state, CustomResourceOptions options)
    Resource lookup is not supported in YAML
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    CompartmentId string

    (Updatable) Compartment Identifier.

    DdlStatement string

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    DefinedTags Dictionary<string, object>

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    FreeformTags Dictionary<string, object>

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    IsAutoReclaimable bool

    True if table can be reclaimed after an idle period.

    LifecycleDetails string

    A message describing the current state in more detail.

    Name string

    Table name.

    Schemas List<TableSchema>

    The table schema information as a JSON object.

    State string

    The state of a table.

    SystemTags Dictionary<string, object>

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    TableLimits TableTableLimits

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    TimeCreated string

    The time the the table was created. An RFC3339 formatted datetime string.

    TimeOfExpiration string

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    TimeUpdated string

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    CompartmentId string

    (Updatable) Compartment Identifier.

    DdlStatement string

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    DefinedTags map[string]interface{}

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    FreeformTags map[string]interface{}

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    IsAutoReclaimable bool

    True if table can be reclaimed after an idle period.

    LifecycleDetails string

    A message describing the current state in more detail.

    Name string

    Table name.

    Schemas []TableSchemaArgs

    The table schema information as a JSON object.

    State string

    The state of a table.

    SystemTags map[string]interface{}

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    TableLimits TableTableLimitsArgs

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    TimeCreated string

    The time the the table was created. An RFC3339 formatted datetime string.

    TimeOfExpiration string

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    TimeUpdated string

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    compartmentId String

    (Updatable) Compartment Identifier.

    ddlStatement String

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    definedTags Map<String,Object>

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    freeformTags Map<String,Object>

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    isAutoReclaimable Boolean

    True if table can be reclaimed after an idle period.

    lifecycleDetails String

    A message describing the current state in more detail.

    name String

    Table name.

    schemas List<TableSchema>

    The table schema information as a JSON object.

    state String

    The state of a table.

    systemTags Map<String,Object>

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    tableLimits TableTableLimits

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    timeCreated String

    The time the the table was created. An RFC3339 formatted datetime string.

    timeOfExpiration String

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    timeUpdated String

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    compartmentId string

    (Updatable) Compartment Identifier.

    ddlStatement string

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    definedTags {[key: string]: any}

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    freeformTags {[key: string]: any}

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    isAutoReclaimable boolean

    True if table can be reclaimed after an idle period.

    lifecycleDetails string

    A message describing the current state in more detail.

    name string

    Table name.

    schemas TableSchema[]

    The table schema information as a JSON object.

    state string

    The state of a table.

    systemTags {[key: string]: any}

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    tableLimits TableTableLimits

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    timeCreated string

    The time the the table was created. An RFC3339 formatted datetime string.

    timeOfExpiration string

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    timeUpdated string

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    compartment_id str

    (Updatable) Compartment Identifier.

    ddl_statement str

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    defined_tags Mapping[str, Any]

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    freeform_tags Mapping[str, Any]

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    is_auto_reclaimable bool

    True if table can be reclaimed after an idle period.

    lifecycle_details str

    A message describing the current state in more detail.

    name str

    Table name.

    schemas TableSchemaArgs]

    The table schema information as a JSON object.

    state str

    The state of a table.

    system_tags Mapping[str, Any]

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    table_limits TableTableLimitsArgs

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    time_created str

    The time the the table was created. An RFC3339 formatted datetime string.

    time_of_expiration str

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    time_updated str

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    compartmentId String

    (Updatable) Compartment Identifier.

    ddlStatement String

    (Updatable) Complete CREATE TABLE DDL statement. When update ddl_statement, it should be ALTER TABLE DDL statement.

    definedTags Map<Any>

    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace": {"bar-key": "value"}}

    freeformTags Map<Any>

    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}

    isAutoReclaimable Boolean

    True if table can be reclaimed after an idle period.

    lifecycleDetails String

    A message describing the current state in more detail.

    name String

    Table name.

    schemas List<Property Map>

    The table schema information as a JSON object.

    state String

    The state of a table.

    systemTags Map<Any>

    Read-only system tag. These predefined keys are scoped to namespaces. At present the only supported namespace is "orcl-cloud"; and the only key in that namespace is "free-tier-retained". Example: {"orcl-cloud"": {"free-tier-retained": "true"}}

    tableLimits Property Map

    (Updatable) Throughput and storage limits configuration of a table. It is required for top level table, must be null for child table as child table shares its top parent table's limits.

    timeCreated String

    The time the the table was created. An RFC3339 formatted datetime string.

    timeOfExpiration String

    If lifecycleState is INACTIVE, indicates when this table will be automatically removed. An RFC3339 formatted datetime string.

    timeUpdated String

    The time the the table's metadata was last updated. An RFC3339 formatted datetime string.

    Supporting Types

    TableSchema, TableSchemaArgs

    Columns List<TableSchemaColumn>

    The columns of a table.

    Identities List<TableSchemaIdentity>

    The identity properties of a table, if any.

    PrimaryKeys List<string>

    A list of column names that make up a key.

    ShardKeys List<string>

    A list of column names that make up a key.

    Ttl int

    The default Time-to-Live for the table, in days.

    Columns []TableSchemaColumn

    The columns of a table.

    Identities []TableSchemaIdentity

    The identity properties of a table, if any.

    PrimaryKeys []string

    A list of column names that make up a key.

    ShardKeys []string

    A list of column names that make up a key.

    Ttl int

    The default Time-to-Live for the table, in days.

    columns List<TableSchemaColumn>

    The columns of a table.

    identities List<TableSchemaIdentity>

    The identity properties of a table, if any.

    primaryKeys List<String>

    A list of column names that make up a key.

    shardKeys List<String>

    A list of column names that make up a key.

    ttl Integer

    The default Time-to-Live for the table, in days.

    columns TableSchemaColumn[]

    The columns of a table.

    identities TableSchemaIdentity[]

    The identity properties of a table, if any.

    primaryKeys string[]

    A list of column names that make up a key.

    shardKeys string[]

    A list of column names that make up a key.

    ttl number

    The default Time-to-Live for the table, in days.

    columns TableSchemaColumn]

    The columns of a table.

    identities TableSchemaIdentity]

    The identity properties of a table, if any.

    primary_keys Sequence[str]

    A list of column names that make up a key.

    shard_keys Sequence[str]

    A list of column names that make up a key.

    ttl int

    The default Time-to-Live for the table, in days.

    columns List<Property Map>

    The columns of a table.

    identities List<Property Map>

    The identity properties of a table, if any.

    primaryKeys List<String>

    A list of column names that make up a key.

    shardKeys List<String>

    A list of column names that make up a key.

    ttl Number

    The default Time-to-Live for the table, in days.

    TableSchemaColumn, TableSchemaColumnArgs

    DefaultValue string

    The column default value.

    IsAsUuid bool

    True if the STRING column was declared AS UUID.

    IsGenerated bool

    True if the STRING AS UUID column is also GENERATED BY DEFAULT.

    IsNullable bool

    The column nullable flag.

    Name string

    Table name.

    Type string

    The column type.

    DefaultValue string

    The column default value.

    IsAsUuid bool

    True if the STRING column was declared AS UUID.

    IsGenerated bool

    True if the STRING AS UUID column is also GENERATED BY DEFAULT.

    IsNullable bool

    The column nullable flag.

    Name string

    Table name.

    Type string

    The column type.

    defaultValue String

    The column default value.

    isAsUuid Boolean

    True if the STRING column was declared AS UUID.

    isGenerated Boolean

    True if the STRING AS UUID column is also GENERATED BY DEFAULT.

    isNullable Boolean

    The column nullable flag.

    name String

    Table name.

    type String

    The column type.

    defaultValue string

    The column default value.

    isAsUuid boolean

    True if the STRING column was declared AS UUID.

    isGenerated boolean

    True if the STRING AS UUID column is also GENERATED BY DEFAULT.

    isNullable boolean

    The column nullable flag.

    name string

    Table name.

    type string

    The column type.

    default_value str

    The column default value.

    is_as_uuid bool

    True if the STRING column was declared AS UUID.

    is_generated bool

    True if the STRING AS UUID column is also GENERATED BY DEFAULT.

    is_nullable bool

    The column nullable flag.

    name str

    Table name.

    type str

    The column type.

    defaultValue String

    The column default value.

    isAsUuid Boolean

    True if the STRING column was declared AS UUID.

    isGenerated Boolean

    True if the STRING AS UUID column is also GENERATED BY DEFAULT.

    isNullable Boolean

    The column nullable flag.

    name String

    Table name.

    type String

    The column type.

    TableSchemaIdentity, TableSchemaIdentityArgs

    ColumnName string

    The name of the identity column.

    IsAlways bool

    True if the identity value is GENERATED ALWAYS.

    IsNull bool

    True if the identity value is GENERATED BY DEFAULT ON NULL.

    ColumnName string

    The name of the identity column.

    IsAlways bool

    True if the identity value is GENERATED ALWAYS.

    IsNull bool

    True if the identity value is GENERATED BY DEFAULT ON NULL.

    columnName String

    The name of the identity column.

    isAlways Boolean

    True if the identity value is GENERATED ALWAYS.

    isNull Boolean

    True if the identity value is GENERATED BY DEFAULT ON NULL.

    columnName string

    The name of the identity column.

    isAlways boolean

    True if the identity value is GENERATED ALWAYS.

    isNull boolean

    True if the identity value is GENERATED BY DEFAULT ON NULL.

    column_name str

    The name of the identity column.

    is_always bool

    True if the identity value is GENERATED ALWAYS.

    is_null bool

    True if the identity value is GENERATED BY DEFAULT ON NULL.

    columnName String

    The name of the identity column.

    isAlways Boolean

    True if the identity value is GENERATED ALWAYS.

    isNull Boolean

    True if the identity value is GENERATED BY DEFAULT ON NULL.

    TableTableLimits, TableTableLimitsArgs

    MaxReadUnits int

    (Updatable) Maximum sustained read throughput limit for the table.

    MaxStorageInGbs int

    (Updatable) Maximum size of storage used by the table.

    MaxWriteUnits int

    (Updatable) Maximum sustained write throughput limit for the table.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    CapacityMode string

    (Updatable) The capacity mode of the table. If capacityMode = ON_DEMAND, maxReadUnits and maxWriteUnits are not used, and both will have the value of zero.

    MaxReadUnits int

    (Updatable) Maximum sustained read throughput limit for the table.

    MaxStorageInGbs int

    (Updatable) Maximum size of storage used by the table.

    MaxWriteUnits int

    (Updatable) Maximum sustained write throughput limit for the table.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    CapacityMode string

    (Updatable) The capacity mode of the table. If capacityMode = ON_DEMAND, maxReadUnits and maxWriteUnits are not used, and both will have the value of zero.

    maxReadUnits Integer

    (Updatable) Maximum sustained read throughput limit for the table.

    maxStorageInGbs Integer

    (Updatable) Maximum size of storage used by the table.

    maxWriteUnits Integer

    (Updatable) Maximum sustained write throughput limit for the table.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    capacityMode String

    (Updatable) The capacity mode of the table. If capacityMode = ON_DEMAND, maxReadUnits and maxWriteUnits are not used, and both will have the value of zero.

    maxReadUnits number

    (Updatable) Maximum sustained read throughput limit for the table.

    maxStorageInGbs number

    (Updatable) Maximum size of storage used by the table.

    maxWriteUnits number

    (Updatable) Maximum sustained write throughput limit for the table.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    capacityMode string

    (Updatable) The capacity mode of the table. If capacityMode = ON_DEMAND, maxReadUnits and maxWriteUnits are not used, and both will have the value of zero.

    max_read_units int

    (Updatable) Maximum sustained read throughput limit for the table.

    max_storage_in_gbs int

    (Updatable) Maximum size of storage used by the table.

    max_write_units int

    (Updatable) Maximum sustained write throughput limit for the table.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    capacity_mode str

    (Updatable) The capacity mode of the table. If capacityMode = ON_DEMAND, maxReadUnits and maxWriteUnits are not used, and both will have the value of zero.

    maxReadUnits Number

    (Updatable) Maximum sustained read throughput limit for the table.

    maxStorageInGbs Number

    (Updatable) Maximum size of storage used by the table.

    maxWriteUnits Number

    (Updatable) Maximum sustained write throughput limit for the table.

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    capacityMode String

    (Updatable) The capacity mode of the table. If capacityMode = ON_DEMAND, maxReadUnits and maxWriteUnits are not used, and both will have the value of zero.

    Import

    Tables can be imported using the id, e.g.

     $ pulumi import oci:Nosql/table:Table test_table "id"

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes

    This Pulumi package is based on the oci Terraform Provider.

    oci logo
    Oracle Cloud Infrastructure v1.11.0 published on Wednesday, Sep 27, 2023 by Pulumi
    pulumi/pulumi-oci