How to round up to 4 digits after decimal point in Bigquery ?
There is no Decimal datatype in BigQuery. You will have to use NUMERIC. And there is no way to specify the precision of decimals in a NUMERIC Datatype. Often we end up with values like this :
0.0105 would have been much cleaner to read and interpret. There is a way to ROUND the decimal places in Bigquery using the ROUND() function
Select ROUND(COLUMN_NAME,4) from Mydataset.MyTable;
This will round the results to 4 decimal places. Keep in mind, the end result can be lesser than 4 digits as well:
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds