Edit

Share via


Known issue - SQL analytics endpoint sync failure when columnMapping is enabled

You can create a lakehouse table that contains columns with data types not supported by the SQL analytics endpoint. You can also set the table property of delta.columnMapping.mode to name. If both of these cases are true, the metadata sync fails, and you see table sync failures.

Status: Open

Product Experience: Data Warehouse

Symptoms

The SQL analytics endpoint metadata sync fails and causes table sync failures. The failure happens when the lakehouse table has an unsupported column and the delta.columnMapping.mode property is enabled.

Solutions and workarounds

To work around this issue, drop the unsupported column from the lakehouse table.

Next steps