List tasks
GET {{baseUrl}}/api/v2/databases/:database/schemas/:schema/tasks?rootOnly=false&like=<string>&startsWith=<string>&showLimit=<integer>&fromName=<string>
Lists tasks under the database and schema, with show options as query parameters.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
rootOnly | boolean | Query parameter to filter the command output to return only root resources (resources with no predecessors). | |
like | string | Query parameter to filter the command output by resource name. Uses case-insensitive pattern matching, with support for SQL wildcard characters. | |
startsWith | string | Query parameter to filter the command output based on the string of characters that appear at the beginning of the object name. Uses case-sensitive pattern matching. | |
showLimit | string | Query parameter to limit the maximum number of rows returned by a command. | |
fromName | string | Query parameter to enable fetching rows only following the first row whose object name matches the specified string. Case-sensitive and does not have to be the full name. |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Accept | string |
RESPONSES
status: OK
[{"name":"\"\"\"p!p\"\"-\"\"\"\"#\"\"a\"","definition":"\u003cstring\u003e","warehouse":"c","schedule":{"schedule_type":"\u003cstring\u003e"},"comment":"\u003cstring\u003e","finalize":"\u003cstring\u003e","task_auto_retry_attempts":"\u003cinteger\u003e","config":{"in7_f":true,"cillumfb":false},"session_parameters":{"veniam_91":98356371},"predecessors":["\u003cstring\u003e","\u003cstring\u003e"],"task_relations":"\u003cstring\u003e","user_task_managed_initial_warehouse_size":"\u003cstring\u003e","user_task_timeout_ms":"\u003cinteger\u003e","suspend_task_after_num_failures":"\u003cinteger\u003e","condition":"\u003cstring\u003e","allow_overlapping_execution":"\u003cboolean\u003e","error_integration":"\u003cstring\u003e","created_on":"\u003cdateTime\u003e","id":"\u003cstring\u003e","owner":"\u003cstring\u003e","owner_role_type":"\u003cstring\u003e","state":"suspended","last_committed_on":"\u003cdateTime\u003e","last_suspended_on":"\u003cdateTime\u003e","database_name":"\u003cstring\u003e","schema_name":"\u003cstring\u003e"},{"name":"\"w\"\"\"\"\"\"\"\"\"\"\"","definition":"\u003cstring\u003e","warehouse":"NgTV","schedule":{"schedule_type":"\u003cstring\u003e"},"comment":"\u003cstring\u003e","finalize":"\u003cstring\u003e","task_auto_retry_attempts":"\u003cinteger\u003e","config":{"Utee1":45254644,"cillum__e":true},"session_parameters":{"consequat_df":-7845971},"predecessors":["\u003cstring\u003e","\u003cstring\u003e"],"task_relations":"\u003cstring\u003e","user_task_managed_initial_warehouse_size":"\u003cstring\u003e","user_task_timeout_ms":"\u003cinteger\u003e","suspend_task_after_num_failures":"\u003cinteger\u003e","condition":"\u003cstring\u003e","allow_overlapping_execution":"\u003cboolean\u003e","error_integration":"\u003cstring\u003e","created_on":"\u003cdateTime\u003e","id":"\u003cstring\u003e","owner":"\u003cstring\u003e","owner_role_type":"\u003cstring\u003e","state":"suspended","last_committed_on":"\u003cdateTime\u003e","last_suspended_on":"\u003cdateTime\u003e","database_name":"\u003cstring\u003e","schema_name":"\u003cstring\u003e"}]