Jump to

• Request
• Response

Creates Live Table Feed

post

/data-tools/live-table-feeds/

Creates Live Table Feed

Request

There are no request parameters for this operation.

Supported Media Types

• application/json

Request Body - application/json ()

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);"
]

Back to Top

Response

Supported Media Types

• application/json

201 Response

Live Table Feeds were succesfully created

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);"
]

204 Response

No content

409 Response

Name conflict with existing Live Table Feed

Back to Top