Jump to

• Request
• Response

Gets Live Table Feeds

get

/data-tools/live-table-feeds/

Gets Live Table Feeds

Request

There are no request parameters for this operation.

There's no request body for this operation.

Back to Top

Response

200 Response

Live Table Feeds

Body ()

Root Schema : schema

Type: object

Show Source

• live_table_feeds: array live_table_feeds

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

Nested Schema : live_table_feeds

Type: array

Show Source

• Array of: object live-table-feed

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

Nested Schema : live-table-feed

Type: object

Show Source

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

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

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

  Type of matching for object_filter

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

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

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

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

  Example: SALES

{
    "type":"object",
    "properties":{
        "live_table_feed_name":{
            "$ref":"#/components/schemas/live_table_feed_name"
        },
        "table_name":{
            "$ref":"#/components/schemas/table_name"
        },
        "storage_link_name":{
            "$ref":"#/components/schemas/storage_link_name"
        },
        "object_filter":{
            "$ref":"#/components/schemas/object_filter"
        },
        "object_filter_type":{
            "$ref":"#/components/schemas/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":"#/components/schemas/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

No Live Table Feeds found

Back to Top