Skip to content

Instantly share code, notes, and snippets.

@aabundez

aabundez/TMSCHEMA_COLUMNS-ExplicitDataType.txt

Last active April 15, 2021 03:10
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save aabundez/b7fb8d0b1bc09ccc43aa45f799ccd923 to your computer and use it in GitHub Desktop.
Save aabundez/b7fb8d0b1bc09ccc43aa45f799ccd923 to your computer and use it in GitHub Desktop.
Download ZIP
ExplicitDataType codes in $SYSTEM.TMSCHEMA_COLUMNS
Raw
TMSCHEMA_COLUMNS-ExplicitDataType.txt
1 - (Calculated Column, so look at InferredDataType column)
2 - Text
6 - Whole Number
8 - Decimal Number
9 - Date
11 - Boolean
//https://docs.microsoft.com/en-us/analysis-services/tabular-models/data-types-supported-ssas-tabular?view=asallproducts-allversions
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment