Forum Discussion

Soobramoney's avatar
Soobramoney
Advocate I
1 year ago
Solved

Lakehouse table datatypes

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

Pipelines
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.