8rows
6 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
attempt_id | | yes | — | — |
request_id | | yes | — | — |
attempt_no | | yes | — | — |
config_revision | | yes | — | — |
started_at | | yes | — | — |
state | | yes | — | — |
View definition
CREATE VIEW latest_attempts AS SELECT a.* FROM attempts a WHERE NOT EXISTS(SELECT 1 FROM attempts newer WHERE newer.request_id=a.request_id AND newer.attempt_no>a.attempt_no)Data preview
Sample records
| attempt_id | request_id | attempt_no | config_revision | started_at | state |
|---|---|---|---|---|---|
| attempt-11038-1 | request-11038 | 1 | 17 | 2018-04-30T09:00:00Z | accepted |
| attempt-11045-1 | request-11045 | 1 | 17 | 2018-05-20T09:00:00Z | blocked |
| attempt-11062-1 | request-11062 | 1 | 17 | 2018-05-20T09:00:00Z | blocked |
| attempt-90001-1 | request-90001 | 1 | 17 | 2018-05-20T09:00:00Z | blocked |
| attempt-90002-1 | request-90002 | 1 | 17 | 2018-05-20T09:00:00Z | blocked |
| attempt-90003-1 | request-90003 | 1 | 17 | 2018-05-20T09:00:00Z | blocked |
| attempt-90004-1 | request-90004 | 1 | 17 | 2018-05-20T09:00:00Z | blocked |
| attempt-90005-1 | request-90005 | 1 | 17 | 2018-05-20T09:00:00Z | blocked |