Issues with publishing a workflow to my server

AdmusNets

Hi guys

I am having a confusing issue. I have a connection to a database called CDP. In CDP I usually fetch data from this table: ref_01_nordic_ci_transactional_overview.fact_rep_acq_trx_agg_day_w_gl_test

The owner of the DB informed me that they are migrating the data from the ref_01. To this à rep_acq_trx_agg_day_w_gl_caps

When testing the connection in my Alteryx from my remote machine: I can pull data and push data, however, whenever I try publishing my data I get this error with the new table:

I did not however receive this error with the first table.

Could you help me guide/assist me with what the issue is?

fmvizcaino

Hi @AdmusNets ,

If everything else is working except this newly created table, I'd say it's likely an access issue.

I`m not super familiar with Hive, but I would try running a query to check the permissions of the table, just in case. I asked ChatGPT, and it is something like this. SHOW GRANT ON TABLE <database_name>.<table_name>;

A test you can do to guarantee nothing weird is going on is to access Alteryx Server remotely and run the workflow on the Designer Desktop inside the Server machine (using the same user credential that is responsible for running all alteryx server workflows). If the user can`t see the table from the server machine, you have a good argument for them.

Best,

Fernando Vizcaino