Forum Discussion
Solved
BUG::UI inconsistent data type display in lakehouse table view
ISSUE: Data type not displayed to the left of one column name when it is displayed OK for all the other columns in the table. Open another table with the same schema, and it shows there. ...
the last I heard was that HimanshuS-msft wanted the table schema, which I dumped in this thread as plain text (since we can't upload any type of file other than pixs). And this is just a minor UI display glitch, so not losing any sleep over it. Just doing my part to help improve the product and keep MS on its toes, as it were. 😉
Element115 : I am in agreement with Anonymous on this at this time it does not look to be bug . But still I want to check the schema for both the tables . Can you please share schema details . I did tried different options of the data type and all of them works just fine .
Thanks
Himanshu
Ok here's the table schema in xslx ... bloody hell! how do you upload a file on here??
I got a 23x23 table! Can't even use the Table widget in this editor.
This is the best I can do until you provide an link for file upload:
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_PRECISION_RADIX NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_CATALOG CHARACTER_SET_SCHEMA CHARACTER_SET_NAME COLLATION_CATALOG COLLATION_SCHEMA COLLATION_NAME DOMAIN_CATALOG DOMAIN_SCHEMA DOMAIN_NAME 1 LH_RWS dbo FACT_RWS_15M DATE 1 null YES date null null null null null 0 null null null null null null null null null 2 LH_RWS dbo FACT_RWS_15M M15 2 null YES datetime2 null null null null null 6 null null null null null null null null null 3 LH_RWS dbo FACT_RWS_15M HOUR 3 null YES datetime2 null null null null null 6 null null null null null null null null null 4 LH_RWS dbo FACT_RWS_15M DATETIME 4 null YES datetime2 null null null null null 6 null null null null null null null null null 5 LH_RWS dbo FACT_RWS_15M ID_RWS 5 null YES varchar 8000 8000 null null null null null null utf8 null null Latin1_General_100_BIN2_UTF8 null null null 6 LH_RWS dbo FACT_RWS_15M AIR_TEMP 6 null YES float null null 53 2 null null null null null null null null null null null 7 LH_RWS dbo FACT_RWS_15M PRECIPITATION 7 null YES float null null 53 2 null null null null null null null null null null null 8 LH_RWS dbo FACT_RWS_15M ATMOSPHERIC_PRESSURE 8 null YES bigint null null 19 10 0 null null null null null null null null null null 9 LH_RWS dbo FACT_RWS_15M BATTERY_STATUS 9 null YES bigint null null 19 10 0 null null null null null null null null null null 10 LH_RWS dbo FACT_RWS_15M PAVEMENT_CHEMICAL_CONCENTRATION 10 null YES bigint null null 19 10 0 null null null null null null null null null null 11 LH_RWS dbo FACT_RWS_15M PAVEMENT_TEMP 11 null YES float null null 53 2 null null null null null null null null null null null 12 LH_RWS dbo FACT_RWS_15M PAVEMENT_BLOCK 12 null YES bigint null null 19 10 0 null null null null null null null null null null 13 LH_RWS dbo FACT_RWS_15M PRECIPITATION_RATE 13 null YES float null null 53 2 null null null null null null null null null null null 14 LH_RWS dbo FACT_RWS_15M PRECIPITATION_SITUATION 14 null YES bigint null null 19 10 0 null null null null null null null null null null 15 LH_RWS dbo FACT_RWS_15M RELATIVE_HUMIDITY 15 null YES float null null 53 2 null null null null null null null null null null null 16 LH_RWS dbo FACT_RWS_15M SOLAR_RADIATION 16 null YES bigint null null 19 10 0 null null null null null null null null null null 17 LH_RWS dbo FACT_RWS_15M SURFACE_DEPTH 17 null YES float null null 53 2 null null null null null null null null null null null 18 LH_RWS dbo FACT_RWS_15M SURFACE_FREEZE_POINT 18 null YES float null null 53 2 null null null null null null null null null null null 19 LH_RWS dbo FACT_RWS_15M VISIBILITY 19 null YES bigint null null 19 10 0 null null null null null null null null null null 20 LH_RWS dbo FACT_RWS_15M WIND_GUST_DIRECTION 20 null YES bigint null null 19 10 0 null null null null null null null null null null 21 LH_RWS dbo FACT_RWS_15M WIND_GUST_SPEED 21 null YES bigint null null 19 10 0 null null null null null null null null null null 22 LH_RWS dbo FACT_RWS_15M Index 22 null YES bigint null null 19 10 0 null null null null null null null null null null