a. Create Tables: suppliers and suppliers$integration_ids
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" );