Skip to content

Instantly share code, notes, and snippets.

emrecolako

  • Coda Platform
  • London
View GitHub Profile
View fivetran.sql
SELECT
TO_CHAR(_fivetran_audit.done, 'YYYY-MM-DD HH24:00') AS "_fivetran_audit.done_hour",
COUNT(*) AS "_fivetran_audit.count"
FROM postgres_public._fivetran_audit AS _fivetran_audit
WHERE
(((_fivetran_audit.done) >= (DATEADD(day,-6, DATE_TRUNC('day',GETDATE()) )) AND (_fivetran_audit.done) < (DATEADD(day,7, DATEADD(day,-6, DATE_TRUNC('day',GETDATE()) ) ))))
GROUP BY 1
ORDER BY 1 DESC
LIMIT 500
View gist:79a0e8bc0bd63fb10910
### Keybase proof
I hereby claim:
* I am emrecolako on github.
* I am emrecolako (https://keybase.io/emrecolako) on keybase.
* I have a public key whose fingerprint is EC3C 202E 92AA 291A 0BE4 B08B ED99 4FAD 0072 5B10
To claim this, I am signing this object:
You can’t perform that action at this time.