53
edits
CloudServices/Sync/ReDash: Difference between revisions
Jump to navigation
Jump to search
added query example
(added descriptions) |
(added query example) |
||
| Line 31: | Line 31: | ||
| submission_date_s3 || varchar || ?? | | submission_date_s3 || varchar || ?? | ||
|} | |} | ||
<big>Query Example</big> | |||
The example below demonstrate how to select data in JSON object. | |||
<code> | |||
WITH errors AS ( | |||
SELECT | |||
failurereason.name AS name, | |||
failurereason.value AS value | |||
FROM sync_summary | |||
WHERE failurereason IS NOT NULL | |||
) | |||
SELECT | |||
name, | |||
COUNT(value) | |||
FROM errors | |||
GROUP BY name | |||
</code> | |||