When I checking big query table schema in schema tab a column data type shows as integer but when I’m querying INFORATION_SCHEMA the result shows datatype of same field in same table shows as int64, why the two naming conventions followed. please help
See the following (here) … at that location I read:
INT64 with alias INT, SMALLINT, INTEGER, BIGINT, TINYINT, BYTEINT
What that seems to tell me is that the language allows a variety of declarations for data types but in the BigQuery implementation, they will all map to an INT64 representation.
