Uk Core Lmi Dim Indid
UK CORE LMI DIM_INDID
| Column Name | Snowflake | Big Query | Databricks | Parquet | Comment |
|---|---|---|---|---|---|
| INDID | VARCHAR | STRING | STRING | STRING | SIC code. |
| INDID_PARENT | VARCHAR | STRING | STRING | STRING | The parent SIC code. |
| LEVEL | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | Level of the dimension hierarchy. |
| NAME | VARCHAR | STRING | STRING | STRING | Name belonging to the SIC code |
| ORDERID | NUMBER | BIGNUMERIC | DECIMAL | DECIMAL | Ordering by this field will order the codes according to the hierarchy. This field is needed here since ordering by the codes themselves would not result in a proper sort. |
Updated about 8 hours ago
