Forum Discussion
Element115
Memorable Member
Memorable MemberBUG::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. 😉
HimanshuS-msft
Microsoft Employee
Microsoft EmployeeElement115 : 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
Element115Memorable Member
Memorable MemberThis 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