# 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).

require '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::ConfigFileLoader.load_config

# Initialize service client with default config file
data_flow_client = OCI::DataFlow::DataFlowClient.new(config: config)

# Send the request to service, some parameters are not required, see API doc for more info
create_sql_endpoint_response =
  data_flow_client.create_sql_endpoint(
    OCI::DataFlow::Models::CreateSqlEndpointDetails.new(
      compartment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
      display_name: 'EXAMPLE-displayName-Value',
      sql_endpoint_version: 'EXAMPLE-sqlEndpointVersion-Value',
      driver_shape: 'EXAMPLE-driverShape-Value',
      executor_shape: 'EXAMPLE-executorShape-Value',
      min_executor_count: 794,
      max_executor_count: 636,
      metastore_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-metastoreId-Value',
      lake_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-lakeId-Value',
      warehouse_bucket_uri: 'EXAMPLE-warehouseBucketUri-Value',
      network_configuration:
        OCI::DataFlow::Models::SqlEndpointSecureAccessConfig.new(
          network_type: 'SECURE_ACCESS',
          access_control_rules: [
            OCI::DataFlow::Models::SecureAccessControlRule.new(
              ip_notation: 'VCN_OCID',
              value: 'EXAMPLE-value-Value',
              vcn_ips: 'EXAMPLE-vcnIps-Value'
            )
          ],
          public_endpoint_ip: 'EXAMPLE-publicEndpointIp-Value'
        ),
      description: 'EXAMPLE-description-Value',
      driver_shape_config:
        OCI::DataFlow::Models::ShapeConfig.new(
          ocpus: 1466.0496, memory_in_gbs: 4607.1733
        ),
      executor_shape_config:
        OCI::DataFlow::Models::ShapeConfig.new(
          ocpus: 2003.8724, memory_in_gbs: 725.84393
        ),
      freeform_tags: {
        'EXAMPLE_KEY_0jOyp' => 'EXAMPLE_VALUE_eiuTB4RZG4gV0ZHTu8QB'
      },
      defined_tags: {
        'EXAMPLE_KEY_vxkkZ' => { 'EXAMPLE_KEY_glCj2' => 'EXAMPLE--Value' }
      },
      spark_advanced_configurations: {
        'EXAMPLE_KEY_HOVIf' => 'EXAMPLE_VALUE_Z9uFNHXGNLMOn7UiOfg4'
      }
    )
  )

# Get the data from response
puts "#{create_sql_endpoint_response.data}"