Data Upload to TERADATA database
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Rumanais
8 - Asteroid
‎04-06-2023
08:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- In Database
0 REPLIES 0
