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.