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.

AndyDDC's avatar
AndyDDC
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

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