Creating a SQL Data Flow Application

• Console
• CLI
• API

• Upload your Spark-submit files to an Oracle Cloud Infrastructure Object Storage. See Set Up Object Store for details.

  1. On the Data Flow page, in the left-side menu, select Applications. If you need help finding the Data Flow page, see Listing Applications.
  2. On the Applications page, select Create application.
  3. In the Create application panel, enter a name for the application and an optional description that can help you search for it.
  4. Under Resource configuration, provide the following values. To help calculate the number of resources that you need, see Sizing the Data Flow Application.
     1. Select the Spark version.
     2. (Optional) Select a pool.
     3. For Driver shape, select the type of cluster node to use to host the Spark driver.
     4. (Optional) If you selected a flexible shape for the driver, customize the number of OCPUs and the amount of memory.
     5. For Executor shape, select the type of cluster node to use to host each Spark executor.
     6. (Optional) If you selected a flexible shape for the executor, customize the number of OCPUs and the amount of memory.
     7. (Optional) To enable use of Spark dynamic allocation (autoscaling), select Enable autoscaling.
     8. Enter the Number of executors you need. If you selected to use autoscaling, enter a minimum and maximum number of executors.
  5. Under Application configuration, provide the following values.
     1. (Optional) If the application is for Spark streaming, select Spark Streaming
     1. Note
        
        You must have followed the steps in Getting Started with Spark Streaming for your streaming application to work.
     2. Don't select Use Spark-Submit Options
     3. Select SQL from the Language options.
     4. Under Select a file, Enter specify the File file URL to the application. There are two in one of the following ways to do this:
        • Select the file from the Object Storage file name list. Select Change compartment if the bucket is in a different compartment.
        • Select Enter the file URL manually and enter the file name and the path to it using this format:

           oci://<bucket_name>@<objectstore_namespace>/<file_name>

     5. (Optional) Enter any parameters.
        • Enter the name and value of each parameter.
        • To add another parameter, click +Another parameter.
     6. (Optional) If you have an archive.zip file, upload the file to Oracle Cloud Infrastructure Object Storage and then populate Archive URI with the path to it. There are two ways to do this:
        • Select the file from the Object Storage file name list. Select Change compartment if the bucket is in a different compartment.
        • Select Enter the file path manually and enter the file name and the path to it using this format:

           oci://<bucket_name>@<namespace_name>/<file_name>

     7. Under Application log location, specify where you want to ingest Oracle Cloud Infrastructure Logging in one of the following ways:
        • Select the dataflow-logs bucket from the Object Storage file name list. Select Change compartment if the bucket is in a different compartment.
        • Select Enter the bucket path manually and enter the bucket path to it using this format:

           oci://dataflow-logs@<namespace_name>

     8. (Optional) Select the metastore from the list. If the metastore is in a different compartment, select Change compartment. The Default managed table location is automatically populated based on the metastore.
  6. (Optional) In the Tags section, add one or more tags to the <resourceType>. If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. For more information about tagging, see Resource Tags. If you're not sure whether to apply tags, skip this option or ask an administrator. You can apply tags later.
  7. Add advanced configuration options.
     1. Select Show advanced options.
     2. (Optional) Select Use resource principal auth to enable faster starting or if you expect the Run to last more than 24 hours.
     3. (Optional) Select Enable Spark Oracle data source to use Spark Oracle Datasource.
     4. Select a Delta Lake version. The value you select is reflected in the Spark configuration properties Key/Value pair. See Data Flow and Delta Lake for information on Delta Lake.
     5. In the Logs section, select the Logs groups and the application logs for Oracle Cloud Infrastructure Logging. You can change compartment if the logs groups are in a different compartment.
     6. Enter the key of the Spark configuration property and a value.
        • If you're using Spark streaming, include a key of spark.sql.streaming.graceful.shutdown.timeout with a value of no more than 30 minutes (in milliseconds).
        • If you're using Spark Oracle Datasource, include a key of spark.oracle.datasource.enabled with a value of true.
     7. Select + Another property to add another configuration property.
     8. (Optional) Override the default value for the warehouse bucket by populating Warehouse Bucket bucket URI in the following format:

        oci://<warehouse-name>@<tenancy>

     9. Select the network access.
        1. If you're attaching a private endpoint to Data Flow, select Secure access to private subnet. Select the private endpoint from the resulting list.
           Note
           
           You can't use an IP address to connect to the private endpoint, you must use the FQDN.
        2. If you're not using a private endpoint, select Internet access (No subnet).
     10. (Optional) To enable data lineage collection:
         1. Select Enable data lineage collection.
         2. Select Enter data catalog into manually or select a Data Catalog instance from a configurable compartment in the current tenancy.
         3. (Optional) If you selected Enter data catalog into manually in the previous step, enter the values for Data catalog tenancy OCID, Data catalog compartment OCID, and Data Catalog instance ODID.
     11. For Max run duration in minutes, enter a value between 60 (1 hour) and 10080 (7 days). If you don't enter a value, the submitted run continues until it succeeds, fails, is canceled, or reaches its default maximum duration (24 hours).
  8. Select Create to create the application, or select Save as stack to create it later.
     To change the values for language, name, and file URL in the future, see Editing an Application. You can't change Language if SQL is selected.

• Use the create command and required parameters to create an application:

  Command

  CopyTry It

  oci data-flow application create [OPTIONS]

  For a complete list of flags and variable options for CLI commands, see the CLI Command Reference.

• Run the CreateApplication operation to create an application.