I have a source table with a column that stored as LEDGER_BAL_AMT as a String value, I have loaded this LEDGER_BAL_AMT as FLOAT in target table by using BIGQUERY.
When I query for this column I get it as a scientific notation like this:
6.2998225E7
But i need the output should be stored as FLOAT and the value like below
62998225.0
