Free Trial

Alteryx Designer Desktop Discussions

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

Data becomes NULL in SQL when a workflow is ran on AYX server

TheaAbella000
7 - Meteor

Hello

 

The out data is being written to sql databse. However when the workflow is ran on server 2 of my columns become NULL when written to sql database but when i ran it locally 2 of my columns are populated in sql as it should

 

I dont know if this has something to do with the google sheets input? Is this a bug? Any idea?

3 REPLIES 3
TheaAbella000
7 - Meteor

*output data

apathetichell
19 - Altair

how do you authenticate to google sheets? Can your server authenticate to google sheets that way? IE - do you connect via username/password style combo or SAML token passed through? Your server will not have that token.

TheaAbella000
7 - Meteor

through client id and secret...do i have to reauthenticate using mine?

Labels
Top Solution Authors