Skip to main content

a. Create Tables: suppliers and suppliers$integration_ids

Important

A common problem with long running transformations and slow data model loads is due to missing statistics in Vertica. This issue can be resolved by adding the Vertica ANALYZE_STATISTICS statement directly in the SQL. For more information, refer to Vertica Transformations Optimization.

Create a transformation “Create Tables: suppliers and suppliers$integration_ids” with the following query:

--Create table with data from initial upload + weekly changes
DROP TABLE IF EXISTS suppliers;
CREATE TABLE suppliers as (
SELECT * from <%=DATASOURCE:ECOVADIS_CONNECTION%>."suppliers"
);
--Same logic for integration_ids
DROP TABLE IF EXISTS "suppliers$integration_ids";
CREATE TABLE "suppliers$integration_ids" as (
SELECT * from <%=DATASOURCE:ECOVADIS_CONNECTION%>."suppliers$integration_ids"
);