Skip to main content

Celonis Product Documentation

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