In the image you can see the query and the results.
gas_native is a string. I need to convert it to a datatype that lets me do operations but everything I try results in the values being rounded. As you can see in the column after.
What can i use to prevent rounding?
I have tried float64, NUMERIC, BIGNUMERIC. nothing works.
What happens when you visualise the results in a table rather than staying in the query window?
I had a similar issue this morning where coordinates were being rounded down to 2 significant figures in the query view, but all was fine when visualised.