SnowConvert AI - Renaming Report

什么是重命名对象？

该对象在迁移期间根据 Redshift Studio 中配置的更改进行了名称更改。

备注

报告包括所有迁移的顶级代码单元，无论它们是否经过重命名。

它包含什么信息？

重命名报告以表格式显示，包含以下各列：

ColumnDescription
CodeUnitThe type of the Code Unit.
SourceDatabaseThe source database.
SourceSchemaThe source schema.
SourceNameThe source name.
SnowflakeDatabaseThe Snowflake database.
SnowflakeSchemaThe Snowflake schema
SnowflakeNameThe Snowflake name.

输入代码

CREATE SCHEMA Renaming_example_schema;

CREATE TABLE Renaming_example_schema.Renaming_example_table_tl (
    id INT,
    name VARCHAR(100)
);

INSERT INTO Renaming_example_schema.Renaming_example_table_tl(id, name) VALUES (1, "tom");

SELECT * FROM Renaming_example_schema.Renaming_example_table_tl;

CREATE TABLE DB_1.MASTER.Renaming_example_table_tl_v2 (
    id INT,
    name VARCHAR(100)
);

INSERT INTO DB_1.MASTER.Renaming_example_table_tl_v2(id, name) VALUES (1, "tom");

SELECT * FROM DB_1.MASTER.Renaming_example_table_tl_v2;

CREATE TABLE NoRenaming_db.NoRenaming_schema.NoRenamingTable_test (
    id INT,
    name VARCHAR(100)
)

INSERT INTO NoRenaming_db.NoRenaming_schema.NoRenamingTable_test(id, name) VALUES (1, "tom");

SELECT * FROM NoRenaming_db.NoRenaming_schema.NoRenamingTable_test;
Copy

输出代码

CREATE SCHEMA IF NOT EXISTS Target_Renaming_example_schema
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "10/23/2024" }}'
;

CREATE TABLE Target_Renaming_example_schema.Target_Renaming_example_table_tl (
    id INT,
    name VARCHAR(100)
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "10/23/2024" }}';

INSERT INTO Target_Renaming_example_schema.Target_Renaming_example_table_tl (id, name) VALUES (1, "tom");

SELECT * FROM
    Target_Renaming_example_schema.Target_Renaming_example_table_tl;

CREATE TABLE Target_DB_1.MASTER.Renaming_example_table_tl_v2 (
    id INT,
    name VARCHAR(100)
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "10/23/2024" }}';

INSERT INTO Target_DB_1.MASTER.Renaming_example_table_tl_v2 (id, name) VALUES (1, "tom");

SELECT * FROM
    Target_DB_1.MASTER.Renaming_example_table_tl_v2;

CREATE TABLE NoRenaming_db.NoRenaming_schema.NoRenamingTable_test (
    id INT,
    name VARCHAR(100)
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "10/23/2024" }}'

INSERT INTO NoRenaming_db.NoRenaming_schema.NoRenamingTable_test (id, name) VALUES (1, "tom");

SELECT * FROM
    NoRenaming_db.NoRenaming_schema.NoRenamingTable_test;
Copy

嵌入式对象

重命名和报告仅适用于顶级对象。嵌入式对象不会出现在报告中，重命名也不会应用于这些对象。

输入代码

CREATE TABLE Renaming_example_table_tl (
   id INT,
   name VARCHAR(100)
);

CREATE PROCEDURE Renaming_example_procedure()
    LANGUAGE plpgsql
AS $$
BEGIN
CREATE TABLE Renaming_example_table_embedded (
   id INT,
   name VARCHAR(100)
);
SELECT * FROM Renaming_example_table_embedded;
SELECT * FROM Renaming_example_table_tl;
END;
$$;
Copy

输出代码

CREATE TABLE Target_Renaming_example_table_tl (
   id INT,
   name VARCHAR(100)
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "11/13/2024",  "domain": "test" }}';

CREATE PROCEDURE Target_Renaming_example_procedure ()
RETURNS VARCHAR
    LANGUAGE SQL
    COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "redshift",  "convertedOn": "11/13/2024",  "domain": "test" }}'
AS $$
BEGIN
CREATE TABLE Renaming_example_table_embedded (
   id INT,
   name VARCHAR(100)
);
SELECT * FROM
   Renaming_example_table_embedded;
SELECT * FROM
   Target_Renaming_example_table_tl;
END;
$$;
Copy
语言: 中文