When running commands like dbt --quiet run-operation generate_source against a Fabric Lakehouse it fails with the following error:
('42S02', "[42S02] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'lh_xxx.information_schema.tables'. (208) (SQLExecDirectW)")
When I edit the fabric__get_tables_by_pattern_sql macro and change the FROM statement to INFORMATION_SCHEMA.TABLES then it works.
Is it possible to for instance check the adapter to see if the table names should be in UPPERCASE?
When running commands like
dbt --quiet run-operation generate_sourceagainst a Fabric Lakehouse it fails with the following error:('42S02', "[42S02] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'lh_xxx.information_schema.tables'. (208) (SQLExecDirectW)")When I edit the fabric__get_tables_by_pattern_sql macro and change the FROM statement to INFORMATION_SCHEMA.TABLES then it works.
Is it possible to for instance check the adapter to see if the table names should be in UPPERCASE?