Alteryx Designer Discussions

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

Primary Key for Teradata Table Build Output

dzwheat1
5 - Atom

Trying to use Teradata SQL to build a table build that is scheduled monthly. Getting high skew factor rates since there is not an option to add primary key when building the table. Any idea on a simple way to create a primary key in a Teradata table through Alteryx? Saw someone use Alter Table in the Post-SQL option of the output data tool, but this was not working for my case

1 REPLY 1
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

I built this quite a while ago, but it should all still be valid.  Let me know if you run into any issues:

https://gallery.alteryx.com/#!app/TeradataOutput/5f00cb428a933718f4b79e70

 

Labels