Describe the bug
Power BI is getting an unexpected data type for date columns from the ODBC driver. The driver should return type 93 which is SQL_TYPE_TIMESTAMP. These columns do not show up on Power BI as there is a data type mismatch.
To Reproduce
- Install the ODBC driver from https://github.com/opensearch-project/sql/actions/runs/1555197058
- Open ODBCTest
- Click on the
Catalog button
- Select
SQLColumns
- See data type for date columns is not 93
Expected behavior
Data type in ODBC test should have data type 93 for date columns