Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/connector_preview.sql

Created August 18, 2016 03:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save doryokujin/dede31a7286bffd62cd13b2d62f25cf9 to your computer and use it in GitHub Desktop.
Save doryokujin/dede31a7286bffd62cd13b2d62f25cf9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
connector_preview.sql
$ td connector:preview config.yml 130 ↵
+---------------------------+---------------------+-------------+----------------+
| date_hour:timestamp | browser:string | visits:long | pageviews:long |
+---------------------------+---------------------+-------------+----------------+
| "2016-08-10 07:00:00 UTC" | "Android Browser" | 2 | 2 |
| "2016-08-10 07:00:00 UTC" | "Chrome" | 299 | 1627 |
| "2016-08-10 07:00:00 UTC" | "Edge" | 4 | 16 |
| "2016-08-10 07:00:00 UTC" | "Firefox" | 31 | 173 |
| "2016-08-10 07:00:00 UTC" | "Internet Explorer" | 22 | 48 |
| "2016-08-10 07:00:00 UTC" | "Opera" | 4 | 11 |
| "2016-08-10 07:00:00 UTC" | "Safari" | 13 | 35 |
| "2016-08-10 07:00:00 UTC" | "Safari (in-app)" | 6 | 7 |
| "2016-08-10 08:00:00 UTC" | "Android Browser" | 4 | 4 |
| "2016-08-10 08:00:00 UTC" | "Chrome" | 226 | 1375 |
+---------------------------+---------------------+-------------+----------------+
10 rows in set
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment