Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to modify the field of a table in my lakehouse (I have it in text and I want to change it to FLOAT).
To do so, I thought of creating a new table inserting the values in the table:
Solved! Go to Solution.
thank you very much! in the end I solved it in another way, I had in one of the fields text and I had a problem with the null to convert them in Float. In the end I put in the query a try cast and it was solved.
thank you very much! in the end I solved it in another way, I had in one of the fields text and I had a problem with the null to convert them in Float. In the end I put in the query a try cast and it was solved.
Glad to know that your issue got resolved. Please continue using Fabric Community on your further queries.
Hi @jesuslogmein you could use CTAS in a single statement and add/modify columns as appropriate.
eg in the query below, in the SELECT, select the relevant columns, and cast to other types
%%sql
CREATE TABLE IF NOT EXISTS new_table
USING DELTA AS
SELECT <columns>
FROM source_table