describe.sql

rockset> describe "oakland-call-center";
+---------------------+---------------+---------+-----------+
| field               | occurrences   | total   | type      |
|---------------------+---------------+---------+-----------|
| ['BEAT']            | 608949        | 608949  | string    |
| ['COUNCILDISTRICT'] | 608949        | 608949  | string    |
| ['City']            | 608949        | 608949  | string    |
| ['DATETIMECLOSED']  | 608949        | 608949  | string    |
| ['DATETIMEINIT']    | 608949        | 608949  | string    |
| ['DESCRIPTION']     | 608949        | 608949  | string    |
| ['PROBADDRESS']     | 608949        | 608949  | string    |
| ['REFERREDTO']      | 608949        | 608949  | string    |
| ['REQADDRESS']      | 608949        | 608949  | string    |
| ['REQCATEGORY']     | 608949        | 608949  | string    |
| ['REQUESTID']       | 608949        | 608949  | string    |
| ['SOURCE']          | 608949        | 608949  | string    |
| ['SRX']             | 608949        | 608949  | string    |
| ['SRY']             | 608949        | 608949  | string    |
| ['STATUS']          | 608949        | 608949  | string    |
| ['State']           | 608949        | 608949  | string    |
| ['updated_at']      | 608949        | 608949  | timestamp |
| ['_event_time']     | 608949        | 608949  | timestamp |
| ['_id']             | 608949        | 608949  | string    |
+---------------------+---------------+---------+-----------+