Alteryx to Vertica Database

Question

Hello,

I need to build a scheduled Alteryx workflow to pull data from the Vertica database and automatically insert the output into a new table in the database on a daily basis.

Currently, I have successfully connected Alteryx to Vertica, with no problem to pull any data using query, however, there are some issues with output:

1. The output connection seems ok because it successfully wrote data to the vertical table, but only when I sampled the output to 20 records or fewer.

2. The total output is not large, actually, less than 0.5G, while it still confused me because 20 records is such a small amount.

3. I have tried to adjust the ODBC setting to check the 'Direct Batch Insert' and set the 'Result buffer size' to 1G, but it seems to have not helped.

I have attached the message box from <20 and >20. Please advise if you have any ideas; any insight would be appreciated.

Failed without error message.png

Succeed when selected 20 rows.png

VinodKammula28 · Answer

Hi @RuochanGao

Thanks for reaching out and for providing detailed context along with the screenshots; that was extremely helpful in identifying the root cause.

Based on your description and our analysis of the attached logs, the issue is not with connectivity or query logic but with how the Vertica ODBC driver handles larger insert operations from Alteryx. Here's a breakdown of what’s happening and how we recommend resolving it.