Fabrick - write to lakehouse - get error 24596 when accesssing table using sql afterwards

Sql error number: 24596. Error Message: Failed to complete the command because the underlying location does not exist. Underlying data description: table 'dbo.Source_D365_LH_CustInvoiceTrans', file '...