Convert GUID To String
Determines if a source column of type GUID/UniqueIdentifier is automatically converted to a String data type.
The conversion is applied wherever BimlFlex resolves column data types for generated artifacts (table definitions, SSIS data flows, and load SQL across the staging, Data Vault, and Data Mart layers) so a GUID source column is carried as a string type end to end.
When to Change This Setting
Keep the default Y to carry GUID columns as strings consistently across target platforms. Set it to N to keep GUID columns on their native data type where the target platform supports one.
Related Settings
| Setting | Interaction |
|---|---|
| Apply Data Type Mappings | The broader control for expanding source data types through Data Type Mappings |
Notes
- This setting is part of the Core settings category.
- The default value for this setting is
Y.