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" );