Sign in Dashboard Get started
  1. Packages
  2. Packages
  3. Oracle Cloud Infrastructure
  4. API Docs
  5. DatabaseTools
  6. getDatabaseToolsSqlReport
Viewing docs for Oracle Cloud Infrastructure v4.12.0
published on Thursday, May 21, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

oci.DatabaseTools.getDatabaseToolsSqlReport

oci logo
Viewing docs for Oracle Cloud Infrastructure v4.12.0
published on Thursday, May 21, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

    This data source provides details about a specific Database Tools Sql Report resource in Oracle Cloud Infrastructure Database Tools service.

    Gets details of the specified Database Tools SQL report.

    Example Usage

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

const testDatabaseToolsSqlReport = oci.databasetools.getDatabaseToolsSqlReport({
    databaseToolsSqlReportId: testDatabaseToolsSqlReportOciDatabaseToolsDatabaseToolsSqlReport.id,
});

    import pulumi
import pulumi_oci as oci

test_database_tools_sql_report = oci.databasetools.get_database_tools_sql_report(database_tools_sql_report_id=test_database_tools_sql_report_oci_database_tools_database_tools_sql_report["id"])

    package main

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

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasetools.GetDatabaseToolsSqlReport(ctx, &databasetools.GetDatabaseToolsSqlReportArgs{
			DatabaseToolsSqlReportId: testDatabaseToolsSqlReportOciDatabaseToolsDatabaseToolsSqlReport.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 testDatabaseToolsSqlReport = Oci.DatabaseTools.GetDatabaseToolsSqlReport.Invoke(new()
    {
        DatabaseToolsSqlReportId = testDatabaseToolsSqlReportOciDatabaseToolsDatabaseToolsSqlReport.Id,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseTools.DatabaseToolsFunctions;
import com.pulumi.oci.DatabaseTools.inputs.GetDatabaseToolsSqlReportArgs;
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 testDatabaseToolsSqlReport = DatabaseToolsFunctions.getDatabaseToolsSqlReport(GetDatabaseToolsSqlReportArgs.builder()
            .databaseToolsSqlReportId(testDatabaseToolsSqlReportOciDatabaseToolsDatabaseToolsSqlReport.id())
            .build());

    }
}

    variables:
  testDatabaseToolsSqlReport:
    fn::invoke:
      function: oci:DatabaseTools:getDatabaseToolsSqlReport
      arguments:
        databaseToolsSqlReportId: ${testDatabaseToolsSqlReportOciDatabaseToolsDatabaseToolsSqlReport.id}

    Example coming soon!

    Using getDatabaseToolsSqlReport

    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 getDatabaseToolsSqlReport(args: GetDatabaseToolsSqlReportArgs, opts?: InvokeOptions): Promise<GetDatabaseToolsSqlReportResult>
function getDatabaseToolsSqlReportOutput(args: GetDatabaseToolsSqlReportOutputArgs, opts?: InvokeOptions): Output<GetDatabaseToolsSqlReportResult>
    def get_database_tools_sql_report(database_tools_sql_report_id: Optional[str] = None,
                                  opts: Optional[InvokeOptions] = None) -> GetDatabaseToolsSqlReportResult
def get_database_tools_sql_report_output(database_tools_sql_report_id: pulumi.Input[Optional[str]] = None,
                                  opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseToolsSqlReportResult]
    func LookupDatabaseToolsSqlReport(ctx *Context, args *LookupDatabaseToolsSqlReportArgs, opts ...InvokeOption) (*LookupDatabaseToolsSqlReportResult, error)
func LookupDatabaseToolsSqlReportOutput(ctx *Context, args *LookupDatabaseToolsSqlReportOutputArgs, opts ...InvokeOption) LookupDatabaseToolsSqlReportResultOutput

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

    public static class GetDatabaseToolsSqlReport 
{
    public static Task<GetDatabaseToolsSqlReportResult> InvokeAsync(GetDatabaseToolsSqlReportArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseToolsSqlReportResult> Invoke(GetDatabaseToolsSqlReportInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetDatabaseToolsSqlReportResult> getDatabaseToolsSqlReport(GetDatabaseToolsSqlReportArgs args, InvokeOptions options)
public static Output<GetDatabaseToolsSqlReportResult> getDatabaseToolsSqlReport(GetDatabaseToolsSqlReportArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DatabaseTools/getDatabaseToolsSqlReport:getDatabaseToolsSqlReport
  arguments:
    # arguments dictionary
    data "oci_databasetools_getdatabasetoolssqlreport" "name" {
    # arguments
}

    The following arguments are supported:

    DatabaseToolsSqlReportId string
    The OCID of a Database Tools SQL Report.
    DatabaseToolsSqlReportId string
    The OCID of a Database Tools SQL Report.
    database_tools_sql_report_id string
    The OCID of a Database Tools SQL Report.
    databaseToolsSqlReportId String
    The OCID of a Database Tools SQL Report.
    databaseToolsSqlReportId string
    The OCID of a Database Tools SQL Report.
    database_tools_sql_report_id str
    The OCID of a Database Tools SQL Report.
    databaseToolsSqlReportId String
    The OCID of a Database Tools SQL Report.

    getDatabaseToolsSqlReport Result

    The following output properties are available:

    Columns List<GetDatabaseToolsSqlReportColumn>
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    CompartmentId string
    The OCID of the compartment containing the Database Tools SQL report.
    DatabaseToolsSqlReportId string
    DefinedTags Dictionary<string, string>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    The description of the variable
    DisplayName string
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    FreeformTags Dictionary<string, string>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    Id string
    The OCID of the Database Tools SQL report.
    Instructions string
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    LifecycleDetails string
    A message describing the current state in more detail.
    Locks List<GetDatabaseToolsSqlReportLock>
    Locks associated with this resource.
    Purpose string
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    Source string
    SQL query executed to generate the report.
    State string
    The current state of the Database Tools SQL report.
    SystemTags Dictionary<string, string>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    TimeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    TimeUpdated string
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    Type string
    The type of the variable
    Variables List<GetDatabaseToolsSqlReportVariable>
    Variables referenced in the Database Tools SQL Report source.
    Columns []GetDatabaseToolsSqlReportColumn
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    CompartmentId string
    The OCID of the compartment containing the Database Tools SQL report.
    DatabaseToolsSqlReportId string
    DefinedTags map[string]string
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    The description of the variable
    DisplayName string
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    FreeformTags map[string]string
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    Id string
    The OCID of the Database Tools SQL report.
    Instructions string
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    LifecycleDetails string
    A message describing the current state in more detail.
    Locks []GetDatabaseToolsSqlReportLock
    Locks associated with this resource.
    Purpose string
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    Source string
    SQL query executed to generate the report.
    State string
    The current state of the Database Tools SQL report.
    SystemTags map[string]string
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    TimeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    TimeUpdated string
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    Type string
    The type of the variable
    Variables []GetDatabaseToolsSqlReportVariable
    Variables referenced in the Database Tools SQL Report source.
    columns list(object)
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartment_id string
    The OCID of the compartment containing the Database Tools SQL report.
    database_tools_sql_report_id string
    defined_tags map(string)
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    The description of the variable
    display_name string
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeform_tags map(string)
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id string
    The OCID of the Database Tools SQL report.
    instructions string
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    lifecycle_details string
    A message describing the current state in more detail.
    locks list(object)
    Locks associated with this resource.
    purpose string
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    source string
    SQL query executed to generate the report.
    state string
    The current state of the Database Tools SQL report.
    system_tags map(string)
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    time_created string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    time_updated string
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    type string
    The type of the variable
    variables list(object)
    Variables referenced in the Database Tools SQL Report source.
    columns List<GetSqlReportColumn>
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartmentId String
    The OCID of the compartment containing the Database Tools SQL report.
    databaseToolsSqlReportId String
    definedTags Map<String,String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    The description of the variable
    displayName String
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeformTags Map<String,String>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id String
    The OCID of the Database Tools SQL report.
    instructions String
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    lifecycleDetails String
    A message describing the current state in more detail.
    locks List<GetSqlReportLock>
    Locks associated with this resource.
    purpose String
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    source String
    SQL query executed to generate the report.
    state String
    The current state of the Database Tools SQL report.
    systemTags Map<String,String>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated String
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    timeUpdated String
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    type String
    The type of the variable
    variables List<GetSqlReportVariable>
    Variables referenced in the Database Tools SQL Report source.
    columns GetDatabaseToolsSqlReportColumn[]
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartmentId string
    The OCID of the compartment containing the Database Tools SQL report.
    databaseToolsSqlReportId string
    definedTags {[key: string]: string}
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    The description of the variable
    displayName string
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeformTags {[key: string]: string}
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id string
    The OCID of the Database Tools SQL report.
    instructions string
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    lifecycleDetails string
    A message describing the current state in more detail.
    locks GetDatabaseToolsSqlReportLock[]
    Locks associated with this resource.
    purpose string
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    source string
    SQL query executed to generate the report.
    state string
    The current state of the Database Tools SQL report.
    systemTags {[key: string]: string}
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    timeUpdated string
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    type string
    The type of the variable
    variables GetDatabaseToolsSqlReportVariable[]
    Variables referenced in the Database Tools SQL Report source.
    columns Sequence[GetDatabaseToolsSqlReportColumn]
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartment_id str
    The OCID of the compartment containing the Database Tools SQL report.
    database_tools_sql_report_id str
    defined_tags Mapping[str, str]
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description str
    The description of the variable
    display_name str
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeform_tags Mapping[str, str]
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id str
    The OCID of the Database Tools SQL report.
    instructions str
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    lifecycle_details str
    A message describing the current state in more detail.
    locks Sequence[GetDatabaseToolsSqlReportLock]
    Locks associated with this resource.
    purpose str
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    source str
    SQL query executed to generate the report.
    state str
    The current state of the Database Tools SQL report.
    system_tags Mapping[str, str]
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    time_created str
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    time_updated str
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    type str
    The type of the variable
    variables Sequence[GetDatabaseToolsSqlReportVariable]
    Variables referenced in the Database Tools SQL Report source.
    columns List<Property Map>
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartmentId String
    The OCID of the compartment containing the Database Tools SQL report.
    databaseToolsSqlReportId String
    definedTags Map<String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    The description of the variable
    displayName String
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeformTags Map<String>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id String
    The OCID of the Database Tools SQL report.
    instructions String
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    lifecycleDetails String
    A message describing the current state in more detail.
    locks List<Property Map>
    Locks associated with this resource.
    purpose String
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    source String
    SQL query executed to generate the report.
    state String
    The current state of the Database Tools SQL report.
    systemTags Map<String>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated String
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    timeUpdated String
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    type String
    The type of the variable
    variables List<Property Map>
    Variables referenced in the Database Tools SQL Report source.

    Supporting Types

    GetDatabaseToolsSqlReportColumn

    Description string
    The description of the variable
    Name string
    The name of the variable
    Type string
    The type of the variable
    Description string
    The description of the variable
    Name string
    The name of the variable
    Type string
    The type of the variable
    description string
    The description of the variable
    name string
    The name of the variable
    type string
    The type of the variable
    description String
    The description of the variable
    name String
    The name of the variable
    type String
    The type of the variable
    description string
    The description of the variable
    name string
    The name of the variable
    type string
    The type of the variable
    description str
    The description of the variable
    name str
    The name of the variable
    type str
    The type of the variable
    description String
    The description of the variable
    name String
    The name of the variable
    type String
    The type of the variable

    GetDatabaseToolsSqlReportLock

    Message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    RelatedResourceId string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    TimeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    Type string
    The type of the variable
    Message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    RelatedResourceId string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    TimeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    Type string
    The type of the variable
    message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    related_resource_id string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    time_created string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    type string
    The type of the variable
    message String
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    relatedResourceId String
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    timeCreated String
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    type String
    The type of the variable
    message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    relatedResourceId string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    timeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    type string
    The type of the variable
    message str
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    related_resource_id str
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    time_created str
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    type str
    The type of the variable
    message String
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    relatedResourceId String
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    timeCreated String
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    type String
    The type of the variable

    GetDatabaseToolsSqlReportVariable

    Description string
    The description of the variable
    Name string
    The name of the variable
    Type string
    The type of the variable
    Description string
    The description of the variable
    Name string
    The name of the variable
    Type string
    The type of the variable
    description string
    The description of the variable
    name string
    The name of the variable
    type string
    The type of the variable
    description String
    The description of the variable
    name String
    The name of the variable
    type String
    The type of the variable
    description string
    The description of the variable
    name string
    The name of the variable
    type string
    The type of the variable
    description str
    The description of the variable
    name str
    The name of the variable
    type str
    The type of the variable
    description String
    The description of the variable
    name String
    The name of the variable
    type String
    The type of the variable

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Viewing docs for Oracle Cloud Infrastructure v4.12.0
    published on Thursday, May 21, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-oci

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial