53
edits
Changes
added query example
| 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>