SnowConvert AI - Databases & Schemas

备注

文档的本页面仅适用于 Teradata。

Teradata 评估报告的数据库和架构部分

包含对象的数据库的数量

表示包含已识别顶级对象的数据库的数量。每个不同的数据库名称仅计为一个数据库。

必须注意的是，这个数字只会随着顶级对象中使用的数据库名称而增加，对对象名称的引用不会计入该评估值。

备注

SQL 和脚本文件会影响此字段。

示例

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;
```

```none
CREATE OR REPLACE TABLE database1.table1 (
COL1 INTEGER)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
;

--** SSC-FDM-0019 - SEMANTIC INFORMATION COULD NOT BE LOADED FOR DATABASE1.table1. CHECK IF THE NAME IS INVALID OR DUPLICATED. **
CREATE OR REPLACE TABLE DATABASE1.table1 (
COL1 INTEGER)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
;

--** SSC-FDM-0007 - MISSING DEPENDENT OBJECT "table2" **
CREATE OR REPLACE VIEW "database2"."view2"
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
AS
--** SSC-FDM-0001 - VIEWS SELECTING ALL COLUMNS FROM A SINGLE TABLE ARE NOT REQUIRED IN SNOWFLAKE AND MAY IMPACT PERFORMANCE. **
SELECT
* FROM
table2;

--** SSC-FDM-0007 - MISSING DEPENDENT OBJECT "table2" **
--** SSC-FDM-0019 - SEMANTIC INFORMATION COULD NOT BE LOADED FOR "DATABASE2"."view2". CHECK IF THE NAME IS INVALID OR DUPLICATED. **
CREATE OR REPLACE VIEW "DATABASE2"."view2"
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
AS
--** SSC-FDM-0001 - VIEWS SELECTING ALL COLUMNS FROM A SINGLE TABLE ARE NOT REQUIRED IN SNOWFLAKE AND MAY IMPACT PERFORMANCE. **
SELECT
* FROM
table2;

--** SSC-FDM-0007 - MISSING DEPENDENT OBJECT "database3.table3" **
CREATE OR REPLACE VIEW view3
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
AS
--** SSC-FDM-0001 - VIEWS SELECTING ALL COLUMNS FROM A SINGLE TABLE ARE NOT REQUIRED IN SNOWFLAKE AND MAY IMPACT PERFORMANCE. **
SELECT
* FROM
database3.table3;
Copy

预期包含对象的数据库数量： 4

解释： 只有以 DDL 名称使用的数据库（表、视图、宏、联接索引、过程和函数）才算作数据库对象。在本例中，CREATE TABLE 语句中的 database1 和 DATABASE1 以及 CREATE VIEW 语句中的 ** “database2”** 和 “DATABASE2” 将被计算在内。

语言: 中文