# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).
import oci
# Create a default config using DEFAULT profile in default location
# Refer to
# https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File
# for more info
config = oci.config.from_file()
# Initialize service client with default config file
generative_ai_data_client = oci.generative_ai_data.GenerateSqlFromNlJobClient(
config)
# Send the request to service, some parameters are not required, see API
# doc for more info
generate_sql_from_nl_response = generative_ai_data_client.generate_sql_from_nl(
generate_sql_from_nl_details=oci.generative_ai_data.models.GenerateSqlFromNlDetails(
input_natural_language_query="EXAMPLE-inputNaturalLanguageQuery-Value",
description="EXAMPLE-description-Value",
display_name="EXAMPLE-displayName-Value",
freeform_tags={
'EXAMPLE_KEY_7T07h': 'EXAMPLE_VALUE_MoCoIjwzloTrmE5ZDFd6'},
defined_tags={
'EXAMPLE_KEY_8XyqO': {
'EXAMPLE_KEY_UrrAh': 'EXAMPLE--Value'}}),
semantic_store_id="ocid1.test.oc1..<unique_ID>EXAMPLE-semanticStoreId-Value",
opc_retry_token="EXAMPLE-opcRetryToken-Value",
opc_request_id="APXNSHNRSV6C80ZSI6J3<unique_ID>",
opc_compartment_id="ocid1.test.oc1..<unique_ID>EXAMPLE-opcCompartmentId-Value",
if_match="EXAMPLE-ifMatch-Value")
# Get the data from response
print(generate_sql_from_nl_response.data)