Triggers data load for Live Table Feed
post
/data-tools/live-table-feeds/{owner},{feed_name}/load_new_data
Triggers data load for Live Table Feed.
Request
Path Parameters
-
feed_name(required):
-
owner(required): string
Owner for the Live Table Feed.
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
Live Table Feed not found