select
col as original,
col::double as val_double,
col::float as val_float,
col::decimal(10,4) as val_decimal,
to_number(col, '99999.99999') as val_tonum
from int_fx_conversion_rate;The original value of col is a string such as '1...
I'm reading data into a dataframe withdf = spark.read.json("s3://somepath/")I've tried first creating a delta table using the DeltaTable API with:DeltaTable.createIfNotExists(spark)\
.location(target_path)\
.addColumns(df.sche...