CODEWITHSUNDEEP
google-bigquery
karthikpswamy
karthikpswamy

Reputation: 41

Does null value occupy any memory in BQ table

I have a table in bigquery, 70% of the fields contains null value. I wanted to know whether null value occupy some memory, if so I could switch to NoSQL database. I also wanted to know your suggestions whether BQ is good to go with this kind of data (where 70% of them are null) or NoSQL. Thanks in advance.

Upvotes: 2

Views: 261

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173106

Null values for any data type are calculated as 0 bytes.

See Data Size Calculation

Upvotes: 4

Related Questions