Fix: improve schema error handling (#3663)

georgesittas · web-flow · commit 868f30d1ff46 · 2024-06-16T19:08:56.000+03:00
diff --git a/sqlglot/schema.py b/sqlglot/schema.py
@@ -386,6 +386,8 @@ def _normalize(self, schema: t.Dict) -> t.Dict:
 
             if not isinstance(columns, dict):
                 raise SchemaError(error_msg.format(".".join(keys[:-1]), len(flattened_schema[0])))
+            if not columns:
+                raise SchemaError(f"Table {'.'.join(keys[:-1])} must have at least one column")
             if isinstance(first(columns.values()), dict):
                 raise SchemaError(
                     error_msg.format(
