Forum Discussion
Can we change column type in Fabric SQL Endpoint ?
Hi,
I'm finally manage to make the column as Date. Figure it out that I better not using "Drag and Drop" on the csv file to my Lakehouse table. Instead doing the Get Data feature so I can manually change the column inside PowerQuery, before the table created.
Issue solved. Thanks.
Hi KenMann
Because a CSV is just a text file, when creating a table in the Lakehouse it cannot determine what the column data types are.
One way to do it when querying via the SQL End Point is you can use the following code to cast it on the fly as shown below.
Select
CAST(FullDateAlternateKey as Date) as Date
from dbo.MyTableName
NOTE: The SQL Endpoint is case sensitive for your column names so make sure to spell them exactly the same.
Hi,
Yes, this what I'm thinking as well. But may I know how to do it in SQL Endpoint ?
Are you referring to that button "New sql query" and write the CAST over there like this ?
But, as this is just a query, how this will alter the table it self which then can be used in my data set outside (Power BI Dekstop)
Thanks,
Hi KenMann
When you use the Power Query data source from "SQL Server" you can insert a query, which you can use from your screenshot above, which will then bring the data in as Date.
I'm sorry, but I'm not quite understand what is the meaning by 'data source from "SQL Server" ', since my datasource is from CSV. And by looking at this resource : T-SQL surface area - Microsoft Fabric | Microsoft Learn
There are these limitation in SQL Endpoint:
Hi,
I'm finally manage to make the column as Date. Figure it out that I better not using "Drag and Drop" on the csv file to my Lakehouse table. Instead doing the Get Data feature so I can manually change the column inside PowerQuery, before the table created.
Issue solved. Thanks.