Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DataSafe
  5. getSqlCollection
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

oci.DataSafe.getSqlCollection

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

    This data source provides details about a specific Sql Collection resource in Oracle Cloud Infrastructure Data Safe service.

    Gets a SQL collection by identifier.

    Example Usage

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

const testSqlCollection = oci.DataSafe.getSqlCollection({
    sqlCollectionId: testSqlCollectionOciDataSafeSqlCollection.id,
});

    import pulumi
import pulumi_oci as oci

test_sql_collection = oci.DataSafe.get_sql_collection(sql_collection_id=test_sql_collection_oci_data_safe_sql_collection["id"])

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := datasafe.GetSqlCollection(ctx, &datasafe.GetSqlCollectionArgs{
			SqlCollectionId: testSqlCollectionOciDataSafeSqlCollection.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 testSqlCollection = Oci.DataSafe.GetSqlCollection.Invoke(new()
    {
        SqlCollectionId = testSqlCollectionOciDataSafeSqlCollection.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.GetSqlCollectionArgs;
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) {
        final var testSqlCollection = DataSafeFunctions.getSqlCollection(GetSqlCollectionArgs.builder()
            .sqlCollectionId(testSqlCollectionOciDataSafeSqlCollection.id())
            .build());

    }
}

    variables:
  testSqlCollection:
    fn::invoke:
      function: oci:DataSafe:getSqlCollection
      arguments:
        sqlCollectionId: ${testSqlCollectionOciDataSafeSqlCollection.id}

    Using getSqlCollection

    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 getSqlCollection(args: GetSqlCollectionArgs, opts?: InvokeOptions): Promise<GetSqlCollectionResult>
function getSqlCollectionOutput(args: GetSqlCollectionOutputArgs, opts?: InvokeOptions): Output<GetSqlCollectionResult>
    def get_sql_collection(sql_collection_id: Optional[str] = None,
                       opts: Optional[InvokeOptions] = None) -> GetSqlCollectionResult
def get_sql_collection_output(sql_collection_id: Optional[pulumi.Input[str]] = None,
                       opts: Optional[InvokeOptions] = None) -> Output[GetSqlCollectionResult]
    func LookupSqlCollection(ctx *Context, args *LookupSqlCollectionArgs, opts ...InvokeOption) (*LookupSqlCollectionResult, error)
func LookupSqlCollectionOutput(ctx *Context, args *LookupSqlCollectionOutputArgs, opts ...InvokeOption) LookupSqlCollectionResultOutput

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

    public static class GetSqlCollection 
{
    public static Task<GetSqlCollectionResult> InvokeAsync(GetSqlCollectionArgs args, InvokeOptions? opts = null)
    public static Output<GetSqlCollectionResult> Invoke(GetSqlCollectionInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetSqlCollectionResult> getSqlCollection(GetSqlCollectionArgs args, InvokeOptions options)
public static Output<GetSqlCollectionResult> getSqlCollection(GetSqlCollectionArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DataSafe/getSqlCollection:getSqlCollection
  arguments:
    # arguments dictionary

    The following arguments are supported:

    SqlCollectionId string
    The OCID of the SQL collection resource.
    SqlCollectionId string
    The OCID of the SQL collection resource.
    sqlCollectionId String
    The OCID of the SQL collection resource.
    sqlCollectionId string
    The OCID of the SQL collection resource.
    sql_collection_id str
    The OCID of the SQL collection resource.
    sqlCollectionId String
    The OCID of the SQL collection resource.

    getSqlCollection Result

    The following output properties are available:

    CompartmentId string
    The OCID of the compartment containing the SQL collection.
    DbUserName string
    The database user name.
    DefinedTags Dictionary<string, string>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
    Description string
    The description of the SQL collection.
    DisplayName string
    The display name of the SQL collection.
    FreeformTags Dictionary<string, string>
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
    GenerateSqlFirewallPolicyTrigger bool
    Id string
    The OCID of the SQL collection.
    LifecycleDetails string
    Details about the current state of the SQL collection in Data Safe.
    PurgeLogsTrigger bool
    RefreshLogInsightsTrigger bool
    SqlCollectionId string
    SqlLevel string
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    StartTrigger bool
    State string
    The current state of the SQL collection.
    Status string
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    StopTrigger bool
    SystemTags Dictionary<string, string>
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
    TargetId string
    The OCID of the target corresponding to the security policy deployment.
    TimeCreated string
    The time that the SQL collection was created, in the format defined by RFC3339.
    TimeLastStarted string
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    TimeLastStopped string
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    TimeUpdated string
    The last date and time the SQL collection was updated, in the format defined by RFC3339.
    CompartmentId string
    The OCID of the compartment containing the SQL collection.
    DbUserName string
    The database user name.
    DefinedTags map[string]string
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
    Description string
    The description of the SQL collection.
    DisplayName string
    The display name of the SQL collection.
    FreeformTags map[string]string
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
    GenerateSqlFirewallPolicyTrigger bool
    Id string
    The OCID of the SQL collection.
    LifecycleDetails string
    Details about the current state of the SQL collection in Data Safe.
    PurgeLogsTrigger bool
    RefreshLogInsightsTrigger bool
    SqlCollectionId string
    SqlLevel string
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    StartTrigger bool
    State string
    The current state of the SQL collection.
    Status string
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    StopTrigger bool
    SystemTags map[string]string
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
    TargetId string
    The OCID of the target corresponding to the security policy deployment.
    TimeCreated string
    The time that the SQL collection was created, in the format defined by RFC3339.
    TimeLastStarted string
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    TimeLastStopped string
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    TimeUpdated string
    The last date and time the SQL collection was updated, in the format defined by RFC3339.
    compartmentId String
    The OCID of the compartment containing the SQL collection.
    dbUserName String
    The database user name.
    definedTags Map<String,String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
    description String
    The description of the SQL collection.
    displayName String
    The display name of the SQL collection.
    freeformTags Map<String,String>
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
    generateSqlFirewallPolicyTrigger Boolean
    id String
    The OCID of the SQL collection.
    lifecycleDetails String
    Details about the current state of the SQL collection in Data Safe.
    purgeLogsTrigger Boolean
    refreshLogInsightsTrigger Boolean
    sqlCollectionId String
    sqlLevel String
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    startTrigger Boolean
    state String
    The current state of the SQL collection.
    status String
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    stopTrigger Boolean
    systemTags Map<String,String>
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
    targetId String
    The OCID of the target corresponding to the security policy deployment.
    timeCreated String
    The time that the SQL collection was created, in the format defined by RFC3339.
    timeLastStarted String
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    timeLastStopped String
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    timeUpdated String
    The last date and time the SQL collection was updated, in the format defined by RFC3339.
    compartmentId string
    The OCID of the compartment containing the SQL collection.
    dbUserName string
    The database user name.
    definedTags {[key: string]: string}
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
    description string
    The description of the SQL collection.
    displayName string
    The display name of the SQL collection.
    freeformTags {[key: string]: string}
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
    generateSqlFirewallPolicyTrigger boolean
    id string
    The OCID of the SQL collection.
    lifecycleDetails string
    Details about the current state of the SQL collection in Data Safe.
    purgeLogsTrigger boolean
    refreshLogInsightsTrigger boolean
    sqlCollectionId string
    sqlLevel string
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    startTrigger boolean
    state string
    The current state of the SQL collection.
    status string
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    stopTrigger boolean
    systemTags {[key: string]: string}
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
    targetId string
    The OCID of the target corresponding to the security policy deployment.
    timeCreated string
    The time that the SQL collection was created, in the format defined by RFC3339.
    timeLastStarted string
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    timeLastStopped string
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    timeUpdated string
    The last date and time the SQL collection was updated, in the format defined by RFC3339.
    compartment_id str
    The OCID of the compartment containing the SQL collection.
    db_user_name str
    The database user name.
    defined_tags Mapping[str, str]
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
    description str
    The description of the SQL collection.
    display_name str
    The display name of the SQL collection.
    freeform_tags Mapping[str, str]
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
    generate_sql_firewall_policy_trigger bool
    id str
    The OCID of the SQL collection.
    lifecycle_details str
    Details about the current state of the SQL collection in Data Safe.
    purge_logs_trigger bool
    refresh_log_insights_trigger bool
    sql_collection_id str
    sql_level str
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    start_trigger bool
    state str
    The current state of the SQL collection.
    status str
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    stop_trigger bool
    system_tags Mapping[str, str]
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
    target_id str
    The OCID of the target corresponding to the security policy deployment.
    time_created str
    The time that the SQL collection was created, in the format defined by RFC3339.
    time_last_started str
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    time_last_stopped str
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    time_updated str
    The last date and time the SQL collection was updated, in the format defined by RFC3339.
    compartmentId String
    The OCID of the compartment containing the SQL collection.
    dbUserName String
    The database user name.
    definedTags Map<String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags Example: {"Operations.CostCenter": "42"}
    description String
    The description of the SQL collection.
    displayName String
    The display name of the SQL collection.
    freeformTags Map<String>
    Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see Resource Tags Example: {"Department": "Finance"}
    generateSqlFirewallPolicyTrigger Boolean
    id String
    The OCID of the SQL collection.
    lifecycleDetails String
    Details about the current state of the SQL collection in Data Safe.
    purgeLogsTrigger Boolean
    refreshLogInsightsTrigger Boolean
    sqlCollectionId String
    sqlLevel String
    Specifies the level of SQL that will be collected. USER_ISSUED_SQL - User issued SQL statements only. ALL_SQL - Includes all SQL statements including SQL statement issued inside PL/SQL units.
    startTrigger Boolean
    state String
    The current state of the SQL collection.
    status String
    Specifies if the status of the SqlCollection. Enabled indicates that the collecting is in progress.
    stopTrigger Boolean
    systemTags Map<String>
    System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see Resource Tags. Example: {"orcl-cloud.free-tier-retained": "true"}
    targetId String
    The OCID of the target corresponding to the security policy deployment.
    timeCreated String
    The time that the SQL collection was created, in the format defined by RFC3339.
    timeLastStarted String
    The timestamp of the most recent SqlCollection start operation, in the format defined by RFC3339.
    timeLastStopped String
    The timestamp of the most recent SqlCollection stop operation, in the format defined by RFC3339.
    timeUpdated String
    The last date and time the SQL collection was updated, in the format defined by RFC3339.

    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 v2.33.0 published on Thursday, May 1, 2025 by Pulumi
    pulumi/pulumi-oci