Forum Discussion

jesuslogmein's avatar
jesuslogmein
Icon for Helper I rankHelper I
2 years ago
Solved

Copy Data Lakehouse

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:   %%sql ...
data engineering
data science
data warehouse
  • jesuslogmein's avatar
    jesuslogmein
    2 years ago

    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.

jesuslogmein's avatar
jesuslogmein
Icon for Helper I rankHelper I
2 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Glad to know that your issue got resolved. Please continue using Fabric Community on your further queries.