Databases & Schemas

This section shows information about the databases of the top-level objects identified in the source code by SnowConvert.

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

This page of the documentation is for Teradata only.

The Databases and Schemas section of the assessment report for Teradata.

Number of Databases Containing Objects

Represents the number of databases that contain identified top-level objects. Each different database name will only count as one single database.

It is important to consider that this number will only be incremented by the names used in the top-level objects, the references to the object names will not be counted in this assessment value.

The SQL and script files affect this field.

Sample

Input

CREATE TABLE database1.table1(COL1 INTEGER);
CREATE TABLE DATABASE1.table1(COL1 INTEGER);

CREATE VIEW "database2"."view2" AS SELECT * FROM table2;
CREATE VIEW "DATABASE2"."view2" AS SELECT * FROM table2;

CREATE VIEW view3 AS SELECT * FROM database3.table3;

Output

CREATE TABLE database1.table1 (
COL1 INTEGER);

CREATE TABLE DATABASE1.table1 (
COL1 INTEGER);

CREATE OR REPLACE VIEW "database2"."view2"
AS
--** MSC-WARNING - MSCINF0001 - VIEWS SELECTING ALL COLUMNS FROM A SINGLE TABLE ARE NOT REQUIRED IN SNOWFLAKE AND MAY IMPACT PERFORMANCE. **
SELECT
* FROM
table2;

CREATE OR REPLACE VIEW "DATABASE2"."view2"
AS
--** MSC-WARNING - MSCINF0001 - VIEWS SELECTING ALL COLUMNS FROM A SINGLE TABLE ARE NOT REQUIRED IN SNOWFLAKE AND MAY IMPACT PERFORMANCE. **
SELECT
* FROM
table2;

CREATE OR REPLACE VIEW view3
AS
--** MSC-WARNING - MSCINF0001 - VIEWS SELECTING ALL COLUMNS FROM A SINGLE TABLE ARE NOT REQUIRED IN SNOWFLAKE AND MAY IMPACT PERFORMANCE. **
SELECT
* FROM
database3.table3;

Expected Databases containing objects: 4

Explanation: Only the databases used in the name of a DDL (tables, views, macros, join indexes, procedures, and functions) will count as a database object. In this case, database1 and DATABASE1 in CREATE TABLE statements and "database2" and "DATABASE2" in CREATE VIEW statements will be counted.