In one customer case with multiple nested folder structures, reading separate SQL and metadata files for Dremio objects did not work correctly and resulted in KeyError: 'sql' in Python or Virtual Dataset must have sql defined errors from Dremio's REST API.
The current workaround is to avoid using the configuration "separate_sql_and_metadata_files": true for complex folder structures.
In one customer case with multiple nested folder structures, reading separate SQL and metadata files for Dremio objects did not work correctly and resulted in
KeyError: 'sql'in Python orVirtual Dataset must have sql definederrors from Dremio's REST API.The current workaround is to avoid using the configuration
"separate_sql_and_metadata_files": truefor complex folder structures.