SnowConvert AI - Renaming Report¶
Qu’est-ce que le renommage d’un objet ?¶
Il s’agit d’un objet qui a subi un changement de nom au cours de la migration, suite aux modifications configurées dans Redshift Studio.
Note
Le rapport inclut toutes les unités de code de niveau supérieur migrées, qu’elles aient été renommées ou non.
Quelles informations contient-il ?¶
Le rapport sur le renommage est présenté sous forme de table et contient les colonnes suivantes :
Column | Description |
---|---|
CodeUnit | The type of the Code Unit. |
SourceDatabase | The source database. |
SourceSchema | The source schema. |
SourceName | The source name. |
SnowflakeDatabase | The Snowflake database. |
SnowflakeSchema | The Snowflake schema |
SnowflakeName | The Snowflake name. |
Code d’entrée
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;
Code de sortie
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;
Objets intégrés¶
Le renommage et le rapport ne sont disponibles que pour les objets de niveau supérieur. Les objets intégrés n’apparaîtront pas dans le rapport et le renommage ne sera pas appliqué à ces objets.
Code d’entrée
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;
$$;
Code de sortie
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;
$$;