Primary Key for Teradata Table Build Output

[dzwheat1]

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

[patrick_mcauliffe]

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

[AndrewSu]

@patrick_mcauliffe , is the link in your most recent reply the most up to date version of the macro? :)

[patrick_mcauliffe]

@AndrewSu I have a more up to date one that's a little on the experimental side if you're interested.

[AndrewSu]

@patrick_mcauliffe , if it's functional I'm interested! thanks.