Looks like

INTEGER

is going to be a platform

int

(probably 64 bits on every system osquery works on), while

BIGINT

is

int64_t

(https://github.com/facebook/osquery/blob/master/include/osquery/tables.h#L103)