Big Query Data Type

[Hariharan1310]

Hi Team,

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 

[kolban]

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.