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 TopResponse
200 Response
Live Table Feeds
Nested Schema : live-table-feed
Type:
Show Source
object
-
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 filesExample:
*.csv
-
object_filter_type: string
Allowed Values:
[ "GLOB", "REGEX" ]
Type of matching for object_filterExample:GLOB
-
scheduled: boolean
Is the Live Table Feed scheduler job enabled?Example:
true
-
scheduler_interval: string
DBMS_SCHEDULER interval for Live Table Feed jobExample:
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 LinkExample:
MY-BUCKET
-
table_name: string
Table name to loadExample:
SALES
Nested Schema : sql_statements
Type:
array
SQL statements to perform database operation
Show Source
-
Array of:
string
SQL statement
Example:
[
"CREATE TABLE \"MYSCHEMA\".\"EXAMPLE_TABLE\"(\"ID\" NUMBER, \"DATE_RECV\" DATE);"
]
404 Response
No Live Table Feeds found