Alteryx Designer Desktop Discussions

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

How to output to teradata from excel table using Indatabase

sonseeahray
8 - Asteroid

Hello,

 

How would I go about outputting to Teradata from an Excel file using In-database?

 

Thanks!

5 REPLIES 5
ArtApa
Alteryx
Alteryx
sonseeahray
8 - Asteroid

Hi @ArtApa,

 

Sorry I didn't see your response yesterday. I'll check it out!

Thank you!

sonseeahray
8 - Asteroid

Hi @ArtApa,

 

This is the test workflow to output from an Excel file to a Teradata table. It is failing with the error message that the user doesn't have CREATE TABLE access. Could this message indicate something else? I do have this access.

 

sonseeahray_3-1619197875544.png

 

 

 

sonseeahray_2-1619197785439.png

 

ArtApa
Alteryx
Alteryx

Hi @sonseeahray - Alteryx doesn't overcome your existing data government framework. It honours existing permission and access rights. If you don't have the rights to create tables you need to speak with your IT to see if you can be granted one. 

sonseeahray
8 - Asteroid

@ArtApa, I mentioned that I do have the permissions to CREATE TABLEs in the Teradata database I am attempting to output to. This is why I asked "Could this message indicate something else? I do have this access"

Labels