Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Learning Google BigQuery

You're reading from  Learning Google BigQuery

Product type Book
Published in Dec 2017
Publisher Packt
ISBN-13 9781787288591
Pages 264 pages
Edition 1st Edition
Languages
Authors (3):
Thirukkumaran Haridass Thirukkumaran Haridass
Profile icon Thirukkumaran Haridass
Mikhail Berlyant Mikhail Berlyant
Eric Brown Eric Brown
Profile icon Eric Brown
View More author details

Table of Contents (9) Chapters

Preface Google Cloud and Google BigQuery Google Cloud SDK Google BigQuery Data Types BigQuery SQL Basic BigQuery SQL Advanced Google BigQuery API Visualizing BigQuery Data Google Cloud Pub/Sub

Supported data types

Here is a table that shows the various supported data types:

Type

Size in bytes

Name (standard SQL)

Description

Integer

8

INT64

Numeric value with no fraction

Floating point

8

FLOAT64

Double-precision decimal value

Boolean

Unset

BOOL

True or false value

String

Unset

STRING

Character data of variable length

Bytes

Unset

BYTES

Variable-length binary

Date

Unset

DATE

Logical calendar date

Datetime

Unset

DATETIME

Year, month, day, hour, minute, second, and subsecond

Time

Unset

TIME

A time, independent of a specific date

Timestamp

Unset

TIMESTAMP

Time with a microsecond precision

Array

Unset

ARRAY

An ordered list of elements of any non-array type. This is available for querying only in Standard SQL.

Struct

Unset

STRUCT

A container of ordered fields...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}