Sign in Dashboard Get started
  1. Registry
  2. Packages
  3. Oracle Cloud Infrastructure
  4. API Docs
  5. DataSafe
  6. getSubsettingPolicyTableEstimates
Viewing docs for Oracle Cloud Infrastructure v5.3.1
published on Tuesday, Oct 13, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

oci.DataSafe.getSubsettingPolicyTableEstimates

oci logo oci logo
Viewing docs for Oracle Cloud Infrastructure v5.3.1
published on Tuesday, Oct 13, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

    This data source provides the list of Subsetting Policy Table Estimates in Oracle Cloud Infrastructure Data Safe service.

    Gets table size estimates for the specified subsetting policy.

    Example Usage

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

const testSubsettingPolicyTableEstimates = oci.datasafe.getSubsettingPolicyTableEstimates({
    subsettingPolicyId: testSubsettingPolicy.id,
    objects: subsettingPolicyTableEstimateObject,
    schemaNames: subsettingPolicyTableEstimateSchemaName,
    targetId: testTarget.id,
});

    import pulumi
import pulumi_oci as oci

test_subsetting_policy_table_estimates = oci.datasafe.get_subsetting_policy_table_estimates(subsetting_policy_id=test_subsetting_policy["id"],
    objects=subsetting_policy_table_estimate_object,
    schema_names=subsetting_policy_table_estimate_schema_name,
    target_id=test_target["id"])

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := datasafe.GetSubsettingPolicyTableEstimates(ctx, &datasafe.GetSubsettingPolicyTableEstimatesArgs{
			SubsettingPolicyId: testSubsettingPolicy.Id,
			Objects:            subsettingPolicyTableEstimateObject,
			SchemaNames:        subsettingPolicyTableEstimateSchemaName,
			TargetId:           pulumi.StringRef(testTarget.Id),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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

return await Deployment.RunAsync(() => 
{
    var testSubsettingPolicyTableEstimates = Oci.DataSafe.GetSubsettingPolicyTableEstimates.Invoke(new()
    {
        SubsettingPolicyId = testSubsettingPolicy.Id,
        Objects = subsettingPolicyTableEstimateObject,
        SchemaNames = subsettingPolicyTableEstimateSchemaName,
        TargetId = testTarget.Id,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DataSafe.DataSafeFunctions;
import com.pulumi.oci.DataSafe.inputs.GetSubsettingPolicyTableEstimatesArgs;
import java.util.ArrayList;
import java.util.Arrays;
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) {
        final var testSubsettingPolicyTableEstimates = DataSafeFunctions.getSubsettingPolicyTableEstimates(GetSubsettingPolicyTableEstimatesArgs.builder()
            .subsettingPolicyId(testSubsettingPolicy.get("id"))
            .objects(subsettingPolicyTableEstimateObject)
            .schemaNames(subsettingPolicyTableEstimateSchemaName)
            .targetId(testTarget.get("id"))
            .build());

    }
}

    variables:
  testSubsettingPolicyTableEstimates:
    fn::invoke:
      function: oci:DataSafe:getSubsettingPolicyTableEstimates
      arguments:
        subsettingPolicyId: ${testSubsettingPolicy.id}
        objects: ${subsettingPolicyTableEstimateObject}
        schemaNames: ${subsettingPolicyTableEstimateSchemaName}
        targetId: ${testTarget.id}

    terraform {
  required_providers {
    oci = {
      source = "pulumi/oci"
    }
  }
}

data "oci_data_safe_subsetting_policy_table_estimates" "testSubsettingPolicyTableEstimates" {
  subsetting_policy_id = testSubsettingPolicy.id
  objects              = subsettingPolicyTableEstimateObject
  schema_names         = subsettingPolicyTableEstimateSchemaName
  target_id            = testTarget.id
}

    Using getSubsettingPolicyTableEstimates

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getSubsettingPolicyTableEstimates(args: GetSubsettingPolicyTableEstimatesArgs, opts?: InvokeOptions): Promise<GetSubsettingPolicyTableEstimatesResult>
function getSubsettingPolicyTableEstimatesOutput(args: GetSubsettingPolicyTableEstimatesOutputArgs, opts?: InvokeOutputOptions): Output<GetSubsettingPolicyTableEstimatesResult>
    def get_subsetting_policy_table_estimates(filters: Optional[Sequence[GetSubsettingPolicyTableEstimatesFilter]] = None,
                                          objects: Optional[Sequence[str]] = None,
                                          schema_names: Optional[Sequence[str]] = None,
                                          subsetting_policy_id: Optional[str] = None,
                                          target_id: Optional[str] = None,
                                          opts: Optional[InvokeOptions] = None) -> GetSubsettingPolicyTableEstimatesResult
def get_subsetting_policy_table_estimates_output(filters: pulumi.Input[Optional[Sequence[pulumi.Input[GetSubsettingPolicyTableEstimatesFilterArgs]]]] = None,
                                          objects: pulumi.Input[Optional[Sequence[pulumi.Input[str]]]] = None,
                                          schema_names: pulumi.Input[Optional[Sequence[pulumi.Input[str]]]] = None,
                                          subsetting_policy_id: pulumi.Input[Optional[str]] = None,
                                          target_id: pulumi.Input[Optional[str]] = None,
                                          opts: Optional[InvokeOutputOptions] = None) -> Output[GetSubsettingPolicyTableEstimatesResult]
    func GetSubsettingPolicyTableEstimates(ctx *Context, args *GetSubsettingPolicyTableEstimatesArgs, opts ...InvokeOption) (*GetSubsettingPolicyTableEstimatesResult, error)
func GetSubsettingPolicyTableEstimatesOutput(ctx *Context, args *GetSubsettingPolicyTableEstimatesOutputArgs, opts ...InvokeOption) GetSubsettingPolicyTableEstimatesResultOutput

    > Note: This function is named GetSubsettingPolicyTableEstimates in the Go SDK.

    public static class GetSubsettingPolicyTableEstimates 
{
    public static Task<GetSubsettingPolicyTableEstimatesResult> InvokeAsync(GetSubsettingPolicyTableEstimatesArgs args, InvokeOptions? opts = null)
    public static Output<GetSubsettingPolicyTableEstimatesResult> Invoke(GetSubsettingPolicyTableEstimatesInvokeArgs args, InvokeOptions? opts = null)
    public static Output<GetSubsettingPolicyTableEstimatesResult> Invoke(GetSubsettingPolicyTableEstimatesInvokeArgs args, InvokeOutputOptions opts)
}
    public static CompletableFuture<GetSubsettingPolicyTableEstimatesResult> getSubsettingPolicyTableEstimates(GetSubsettingPolicyTableEstimatesArgs args, InvokeOptions options)
public static Output<GetSubsettingPolicyTableEstimatesResult> getSubsettingPolicyTableEstimates(GetSubsettingPolicyTableEstimatesArgs args, InvokeOptions options)
public static Output<GetSubsettingPolicyTableEstimatesResult> getSubsettingPolicyTableEstimates(GetSubsettingPolicyTableEstimatesArgs args, InvokeOutputOptions options)

    fn::invoke:
  function: oci:DataSafe/getSubsettingPolicyTableEstimates:getSubsettingPolicyTableEstimates
  arguments:
    # arguments dictionary
    data "oci_data_safe_get_subsetting_policy_table_estimates" "name" {
    # arguments
}

    The following arguments are supported:

    SubsettingPolicyId string
    The OCID of the subsetting policy.
    Filters List<GetSubsettingPolicyTableEstimatesFilter>
    Objects List<string>
    A filter to return only items related to a specific object name.
    SchemaNames List<string>
    A filter to return only items related to specific schema name.
    TargetId string
    A filter to return only items related to a specific target OCID.
    SubsettingPolicyId string
    The OCID of the subsetting policy.
    Filters []GetSubsettingPolicyTableEstimatesFilter
    Objects []string
    A filter to return only items related to a specific object name.
    SchemaNames []string
    A filter to return only items related to specific schema name.
    TargetId string
    A filter to return only items related to a specific target OCID.
    subsetting_policy_id string
    The OCID of the subsetting policy.
    filters list(object)
    objects list(string)
    A filter to return only items related to a specific object name.
    schema_names list(string)
    A filter to return only items related to specific schema name.
    target_id string
    A filter to return only items related to a specific target OCID.
    subsettingPolicyId String
    The OCID of the subsetting policy.
    filters List<GetSubsettingPolicyTableEstimatesFilter>
    objects List<String>
    A filter to return only items related to a specific object name.
    schemaNames List<String>
    A filter to return only items related to specific schema name.
    targetId String
    A filter to return only items related to a specific target OCID.
    subsettingPolicyId string
    The OCID of the subsetting policy.
    filters GetSubsettingPolicyTableEstimatesFilter[]
    objects string[]
    A filter to return only items related to a specific object name.
    schemaNames string[]
    A filter to return only items related to specific schema name.
    targetId string
    A filter to return only items related to a specific target OCID.
    subsetting_policy_id str
    The OCID of the subsetting policy.
    filters Sequence[GetSubsettingPolicyTableEstimatesFilter]
    objects Sequence[str]
    A filter to return only items related to a specific object name.
    schema_names Sequence[str]
    A filter to return only items related to specific schema name.
    target_id str
    A filter to return only items related to a specific target OCID.
    subsettingPolicyId String
    The OCID of the subsetting policy.
    filters List<Property Map>
    objects List<String>
    A filter to return only items related to a specific object name.
    schemaNames List<String>
    A filter to return only items related to specific schema name.
    targetId String
    A filter to return only items related to a specific target OCID.

    getSubsettingPolicyTableEstimates Result

    The following output properties are available:

    Id string
    The provider-assigned unique ID for this managed resource.
    SubsettingPolicyId string
    TableEstimateCollections List<GetSubsettingPolicyTableEstimatesTableEstimateCollection>
    The list of table_estimate_collection.
    Filters List<GetSubsettingPolicyTableEstimatesFilter>
    Objects List<string>
    SchemaNames List<string>
    The name of the schema that contains the table.
    TargetId string
    The OCID of the target database associated with the table estimate object.
    Id string
    The provider-assigned unique ID for this managed resource.
    SubsettingPolicyId string
    TableEstimateCollections []GetSubsettingPolicyTableEstimatesTableEstimateCollection
    The list of table_estimate_collection.
    Filters []GetSubsettingPolicyTableEstimatesFilter
    Objects []string
    SchemaNames []string
    The name of the schema that contains the table.
    TargetId string
    The OCID of the target database associated with the table estimate object.
    id string
    The provider-assigned unique ID for this managed resource.
    subsetting_policy_id string
    table_estimate_collections list(object)
    The list of table_estimate_collection.
    filters list(object)
    objects list(string)
    schema_names list(string)
    The name of the schema that contains the table.
    target_id string
    The OCID of the target database associated with the table estimate object.
    id String
    The provider-assigned unique ID for this managed resource.
    subsettingPolicyId String
    tableEstimateCollections List<GetSubsettingPolicyTableEstimatesTableEstimateCollection>
    The list of table_estimate_collection.
    filters List<GetSubsettingPolicyTableEstimatesFilter>
    objects List<String>
    schemaNames List<String>
    The name of the schema that contains the table.
    targetId String
    The OCID of the target database associated with the table estimate object.
    id string
    The provider-assigned unique ID for this managed resource.
    subsettingPolicyId string
    tableEstimateCollections GetSubsettingPolicyTableEstimatesTableEstimateCollection[]
    The list of table_estimate_collection.
    filters GetSubsettingPolicyTableEstimatesFilter[]
    objects string[]
    schemaNames string[]
    The name of the schema that contains the table.
    targetId string
    The OCID of the target database associated with the table estimate object.
    id str
    The provider-assigned unique ID for this managed resource.
    subsetting_policy_id str
    table_estimate_collections Sequence[GetSubsettingPolicyTableEstimatesTableEstimateCollection]
    The list of table_estimate_collection.
    filters Sequence[GetSubsettingPolicyTableEstimatesFilter]
    objects Sequence[str]
    schema_names Sequence[str]
    The name of the schema that contains the table.
    target_id str
    The OCID of the target database associated with the table estimate object.
    id String
    The provider-assigned unique ID for this managed resource.
    subsettingPolicyId String
    tableEstimateCollections List<Property Map>
    The list of table_estimate_collection.
    filters List<Property Map>
    objects List<String>
    schemaNames List<String>
    The name of the schema that contains the table.
    targetId String
    The OCID of the target database associated with the table estimate object.

    Supporting Types

    GetSubsettingPolicyTableEstimatesFilter

    Name string
    Values List<string>
    Regex bool
    Name string
    Values []string
    Regex bool
    name string
    values list(string)
    regex bool
    name String
    values List<String>
    regex Boolean
    name string
    values string[]
    regex boolean
    name str
    values Sequence[str]
    regex bool
    name String
    values List<String>
    regex Boolean

    GetSubsettingPolicyTableEstimatesTableEstimateCollection

    items list(object)
    An array of table estimate objects.
    items List<Property Map>
    An array of table estimate objects.

    GetSubsettingPolicyTableEstimatesTableEstimateCollectionItem

    EstimatedRowCount string
    The estimated number of rows in the table after subsetting.
    EstimatedSizeInKbs string
    The estimated size of the table in KBs after subsetting.
    InitialRowCount string
    The initial number of rows in the table.
    InitialSizeInKbs string
    The initial size of the table in KBs.
    ObjectType string
    The type of the database object.
    SchemaName string
    A filter to return only items related to specific schema name.
    TableName string
    The name of the table.
    TargetId string
    A filter to return only items related to a specific target OCID.
    EstimatedRowCount string
    The estimated number of rows in the table after subsetting.
    EstimatedSizeInKbs string
    The estimated size of the table in KBs after subsetting.
    InitialRowCount string
    The initial number of rows in the table.
    InitialSizeInKbs string
    The initial size of the table in KBs.
    ObjectType string
    The type of the database object.
    SchemaName string
    A filter to return only items related to specific schema name.
    TableName string
    The name of the table.
    TargetId string
    A filter to return only items related to a specific target OCID.
    estimated_row_count string
    The estimated number of rows in the table after subsetting.
    estimated_size_in_kbs string
    The estimated size of the table in KBs after subsetting.
    initial_row_count string
    The initial number of rows in the table.
    initial_size_in_kbs string
    The initial size of the table in KBs.
    object_type string
    The type of the database object.
    schema_name string
    A filter to return only items related to specific schema name.
    table_name string
    The name of the table.
    target_id string
    A filter to return only items related to a specific target OCID.
    estimatedRowCount String
    The estimated number of rows in the table after subsetting.
    estimatedSizeInKbs String
    The estimated size of the table in KBs after subsetting.
    initialRowCount String
    The initial number of rows in the table.
    initialSizeInKbs String
    The initial size of the table in KBs.
    objectType String
    The type of the database object.
    schemaName String
    A filter to return only items related to specific schema name.
    tableName String
    The name of the table.
    targetId String
    A filter to return only items related to a specific target OCID.
    estimatedRowCount string
    The estimated number of rows in the table after subsetting.
    estimatedSizeInKbs string
    The estimated size of the table in KBs after subsetting.
    initialRowCount string
    The initial number of rows in the table.
    initialSizeInKbs string
    The initial size of the table in KBs.
    objectType string
    The type of the database object.
    schemaName string
    A filter to return only items related to specific schema name.
    tableName string
    The name of the table.
    targetId string
    A filter to return only items related to a specific target OCID.
    estimated_row_count str
    The estimated number of rows in the table after subsetting.
    estimated_size_in_kbs str
    The estimated size of the table in KBs after subsetting.
    initial_row_count str
    The initial number of rows in the table.
    initial_size_in_kbs str
    The initial size of the table in KBs.
    object_type str
    The type of the database object.
    schema_name str
    A filter to return only items related to specific schema name.
    table_name str
    The name of the table.
    target_id str
    A filter to return only items related to a specific target OCID.
    estimatedRowCount String
    The estimated number of rows in the table after subsetting.
    estimatedSizeInKbs String
    The estimated size of the table in KBs after subsetting.
    initialRowCount String
    The initial number of rows in the table.
    initialSizeInKbs String
    The initial size of the table in KBs.
    objectType String
    The type of the database object.
    schemaName String
    A filter to return only items related to specific schema name.
    tableName String
    The name of the table.
    targetId String
    A filter to return only items related to a specific target OCID.

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo oci logo
    Viewing docs for Oracle Cloud Infrastructure v5.3.1
    published on Tuesday, Oct 13, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-oci

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial