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. |
Last updated