Lakehouse table datatypes

Soobramoney — Mon, 02 Sep 2024 11:20:58 GMT

Hi,

I have a Fabric Lakehouse table that contains all string data types. I need to load the data into a new table with the correct data types. When I use the copy data activity, I receive an error message stating that null values in string columns cannot be inserted into an int column. How can I update these columns with actual null values, or is there an easier way to load the data with the correct data types?

Thanks

Re: Lakehouse table datatypes

Anonymous — Tue, 03 Sep 2024 02:53:29 GMT

Hi Soobramoney ,

For this type of problem, you can make sure that the columns are defined with the correct data types when you create a new table, and allow null values if necessary.

The following demonstrates the successful insertion of a NULL value in a table:

CREATE TABLE [NullCheck1] ( col1 int not null, col2 VARCHAR(30) NULL, col3 VARCHAR(30) not NULL, col4 int NULL ) GO INSERT INTO [NullCheck1] VALUES (3,NULL,'NA',NULL) select * from [dbo].[NullCheck1]

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Lakehouse table datatypes in Pipelines

Lakehouse table datatypes

Re: Lakehouse table datatypes