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.