Spring is right here. Clocks transfer ahead. The Sakura (cherry blossom) competition in Japan marks the celebration of the brand new season. In India, the holi competition of colours ushers within the new harvest season. It’s a time for renewal and new methods of doing issues.
This month, we’re happy to debut our latest set of SQL options in BigQuery to assist our analysts and information engineers spring ahead. It’s time to put aside the outdated methods of doing issues and as a substitute have a look at these new methods of storing and analyzing all of your information utilizing BigQuery SQL.
Increased precision and extra versatile capabilities to handle your ever-expanding information in BigQuery
BIGNUMERIC information sort (GA)
We stay in an period the place clever gadgets and techniques starting from driverless automobiles to world inventory and forex buying and selling techniques to excessive pace 5G networks are driving almost all elements of recent life. These techniques depend on massive quantities of precision information to carry out actual time evaluation. To assist these analytics, BigQuery is happy to announce the final availability of BIGNUMERIC information sort which helps 76 digits of precision and 38 digits of scale. Much like NUMERIC, this new information sort is offered in all elements of BigQuery from clustering to BI Engine and can also be supported within the JDBC/ODBC drivers and shopper libraries.
Right here is an instance that demonstrates the extra precision and scale utilizing BIGNUMERIC utilized to the assorted powers of e, Euler’s quantity and the bottom of pure logarithms. Documentation
As an apart, do you know that the world record, as of December 5, 2020, for the utmost variety of digits to symbolize e stands at 10π trillion digits?