formatTableName

This procedure quotes the fully qualified name of a table or procedure, checks if it exists in the system metadata, adjusts the name casing, and optionally throws an error if the object does not exist (this may be helpful if this is a source table/procedure).

Parameters

Parameter	Description
`tableName`	Table/procedure name, requires a fully-qualified object name. The name will be quoted using the specified casing if the object does not exist. If it exists, the casing will be adjusted accordingly; mandatory
`tableDescription`	Text description of the object. Used in error messages only to distinguish the object for convenience
`checkExists`	If set to `TRUE`, the procedure will fail with an error in case the object does not exist
`isTable`	Whether the object is a table or a procedure; default: `TRUE`

Usage

SQL

CALL UTILS.formatTableName(
    tableName => 'datasource.tablename',
    tableDescription => 'target',
    checkExists => TRUE,
	isTable => TRUE  
);;