If you define a column list for an insert, Databricks will assign the corresponding default value instead. If there is no default value defined, it will insert null.

However, if one of those columns is not nullable, an error is raised.

Can you check if Client_Name is nullable in the delta lake table?