Assessment Model representation of the data collected by SnowConvert
Tables generated by SnowConvert
Assessment
Structure
Column | Example of a Value for the Column |
ProductName | Mobilize Snow Convert Tool |
CoreVersion | 0.0.0.0 |
AppVersion | Not Provided |
SqlFileCount | 2320 |
SqlSizeMB | 35.85 |
OSVersion | Microsoft Windows NT 6.2.9200.0 |
StartConversion | 2021/06/14 15:24:04 -06:00 |
TotalFiles | 2320 |
TotalFilesNotGenerated | 0 |
TotalLinesOfCode | 412245 |
ConversionSpeed | 535 |
ElapsedTime | 00:12:49 |
TotalSize | 37588251 |
EndConversion | 2021/06/14 15:36:53 -06:00 |
TotalWarnings | 49119 |
TotalParsingErrors | 961 |
TotalConversionErrors | 1 |
TotalCharacterConversionRate | 48 |
SqlIdentifiedObjects | 5204 |
ObjectsSuccessfullyConverted | 2766 |
TableCharacterConversionRate | 95 |
TableFullyConvertedOccurrences | 2754 |
TableTotalOccurrences | 2901 |
TableTotalParsingErrors | 11 |
TableTotalConversionErrors | 4139 |
TableTotalWarnings | 110 |
TableTotalCharacters | 568660 |
TableTotalLinesOfCode | 468 |
ViewCharacterConversionRate | 0 |
ViewFullyConvertedOccurrences | 0 |
ViewTotalOccurrences | 0 |
ViewTotalParsingErrors | 0 |
ViewTotalConversionErrors | 0 |
ViewTotalWarnings | 0 |
ViewTotalCharacters | 0 |
ViewTotalLinesOfCode | 0 |
ProcedureCharacterConversionRate | 60 |
ProcedureFullyConvertedOccurrences | 12 |
ProcedureTotalOccurrences | 2303 |
ProcedureTotalParsingErrors | 877 |
ProcedureTotalConversionErrors | 75893 |
ProcedureTotalWarnings | 46575 |
ProcedureTotalCharacters | 30406479 |
ProcedureTotalLinesOfCode | 362341 |
CloseSession | 2021/06/14 15:36:55 -06:00 |
How to map this table
We will use multiple CustomToolProperties for this mapping
Issues
Column | Example of a Value for the Column | Mapping |
SessionID | ProductSession.SessionId | |
Name | Statement Not Supported | NotificationArgument:Name |
Description | THE STATEMENT IS NOT SUPPORTED IN SNOWFLAKE | NotificationArgument:Description |
Severity | Low | NotificationArgument.Severity |
Line | 30 | Notification.Line |
Column | 1 | Notification.Column |
ParentFile | AllScripts\dbo\procedure\scapopulatespecimentypedimpr.sql | Notification.FileId or NotificationArgument.ParentFile |
Code | MSCEWI1040 | Notification.NotificationCode |
Considerations
Other tables were mentioned in previous meetings. However, we were informed by the SQL Convert team that these tables contain the information they need to store.
Last updated