Object References Report

The object references report provides a general overview of the objects referenced by other objects in the input source code.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Built-in objects are not considered as part of this report.

What is an "Object Reference"?

An object reference is the term used to refer to DDL definitions in the source code, that are being referenced by other objects. The table below shows which objects could be referenced in each supported language.

Object	Teradata	Oracle	SQL Server	Extensibility Languages
Table	✓	✓	✓	✓
View	✓	✓	✓	✓
Procedure	✓	✓	✓	✓
Function	✓	✓	✓	✓
Macro	✓
Package Function		✓
Package Procedure		✓
*Package		✓
Join Index	✓
Index		✓
Synonym		✓
Database Link		✓
Type	✓	✓	✓
Materialized View		✓

If an asterisk ('*') is listed in the section above, it means that the object is used to call properties from itself that are not considered DDL statements such as constants, variables, or cursors.

Where can I find it?

The object references report can be found in a folder named "reports", in the output folder of your conversion. The name of the file itself starts with "ObjectReferences" so it can easily be located.

The format of the file is .CSV.

What information does it contain?

The object references report contains the following information about all the references found while converting:

Column	Description
PartitionKey	The unique identifier of the conversion.
FileName	The name of the file in which the object is located.
Calling_Object_Type	The type of the object referencing another object.
Calling_Object_Database	The database of the object referencing another object. For now, only SQL Server objects can have a database.
Calling_Object_Schema	The schema of the object referencing another object.
Calling_Object_Name	The name of the object referencing another object.
Calling_Object_FullName	The fully qualified name of the object referencing another object.
Referenced_Object_Type	The DDL type of the referenced object.
Referenced_Object_Database	The database of the referenced object. For now only SQL Server objects can have a database.
Referenced_Object_Schema	The schema of the referenced object.
Referenced_Object_Name	The name of the referenced object.
Referenced_Object_FullName	The full qualified name of the referenced object.
Line	The line number inside the file where the reference occurs.