Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data Upload to TERADATA database

Rumanais
8 - Asteroid

is there a way to upload data using temporary/volatile tables in TERADATA database using Alteryx?

I have tired Dynamic Input tool, pre SQL Statement within the Input tool, Data Stream In, Write data In-DB tools, nothings seems to be working.

 

I have access to create temporary or permanent table within our TERADATA database and typically use the following commands to create the temporary table. 

 

CREATE VOLATILE TABLE tbl_nm
(
column_nm VARCHAR(10))
ON COMMIT PRESERVE ROWS;

 

INSERT INTO tbl_nm VALUES (?)

 

Any advise will be greatly appreciated. 

0 REPLIES 0
Labels