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.
