Jump to

• Request
• Response

Modify Live Table Feed

put

/ords/_/db-api/stable/data-tools/live-table-feeds/{owner},{feed_name}

Request

Path Parameters

• feed_name: string
• owner: string
  Owner for the Live Table Feed.

Back to Top

Response

200 Response

Live Table Feeds

Body ()

Root Schema : live-table-feeds

Type: object

Show Source

• live_table_feeds(optional): array live_table_feeds

{
    "type":"object",
    "properties":{
        "live_table_feeds":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/live-table-feed"
            }
        }
    }
}

Nested Schema : live_table_feeds

Type: array

Show Source

• Array of: object live-table-feed

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/live-table-feed"
    }
}

Nested Schema : live-table-feed

Type: object

Show Source

• live_table_feed_name(optional): string
  Example: SALES_FEED
• notifications(optional): boolean
  Is the Live Table Feed enabled for notifications?

  Example: false
• object_filter(optional): string
  Filter to select subset of files

  Example: *.csv
• object_filter_type(optional): string
  Allowed Values: [ "GLOB", "REGEX" ]

  Type of matching for object_filter

  Example: GLOB
• scheduled(optional): boolean
  Is the Live Table Feed scheduler job enabled?

  Example: true
• scheduler_interval(optional): string
  DBMS_SCHEDULER interval for Live Table Feed job

  Example: FREQ=DAILY;BYHOUR=9;BYMINUTE=30;BYDAY=MON,TUE,WED,THU,FRI
• sql_statements(optional): array sql_statements
  SQL statements to perform database operation
• storage_link_name(optional): string
  Name of Cloud Storage Link

  Example: MY-BUCKET
• table_name(optional): string
  Table name to load

  Example: SALES

{
    "type":"object",
    "properties":{
        "live_table_feed_name":{
            "$ref":"#/definitions/live_table_feed_name"
        },
        "table_name":{
            "$ref":"#/definitions/table_name"
        },
        "storage_link_name":{
            "$ref":"#/definitions/storage_link_name"
        },
        "object_filter":{
            "$ref":"#/definitions/object_filter"
        },
        "object_filter_type":{
            "$ref":"#/definitions/object_filter_type"
        },
        "scheduled":{
            "type":"boolean",
            "example":true,
            "description":"Is the Live Table Feed scheduler job enabled?"
        },
        "scheduler_interval":{
            "type":"string",
            "example":"FREQ=DAILY;BYHOUR=9;BYMINUTE=30;BYDAY=MON,TUE,WED,THU,FRI",
            "description":"DBMS_SCHEDULER interval for Live Table Feed job"
        },
        "notifications":{
            "type":"boolean",
            "example":false,
            "description":"Is the Live Table Feed enabled for notifications?"
        },
        "sql_statements":{
            "$ref":"#/definitions/sql_statements"
        }
    }
}

Nested Schema : sql_statements

Type: array

SQL statements to perform database operation

Show Source

• Array of: string
  SQL statement

{
    "type":"array",
    "items":{
        "description":"SQL statement",
        "type":"string"
    },
    "description":"SQL statements to perform database operation",
    "example":[
        "CREATE TABLE \"MYSCHEMA\".\"EXAMPLE_TABLE\"(\"ID\" NUMBER, \"DATE_RECV\" DATE);"
    ]
}

Example:

[
    "CREATE TABLE \"MYSCHEMA\".\"EXAMPLE_TABLE\"(\"ID\" NUMBER, \"DATE_RECV\" DATE);"
]

404 Response

Live Table Feed not found

Back to Top