Is it possible to set up an Output connection to Dremio? I don't see that as a data source on the Output. Has anyone done this successfully? I'm a new user, so please be kind. :-)
Hi @ssheffer , first of all, welcome on board. Thank you for choosing Alteryx!
I am quite sure, that the community would warmly welcome you.
let me try to help in meantime.
It depends on what version of Alteryx designer you are using, but in 2024.2 (release notes says its there since 2024.1) there is Dremio listed within data sources in Input tool menu. If you using
https://help.alteryx.com/current/en/designer/data-sources/dremio.html
If you using DCM (data connections manager you can choose between ODBC(DSN) and Quick connect - without configuring ODBC DSN.
If you are on older version, and cant upgrade, you can still use "Generic ODBC" connection allowing you select configured ODBC DSN. Hope you are familiar with this terminology. In short, you need ODBC driver(always 64bit versions) and Dremio server credentials. It might be good to test connection via the ODBC 64bit menu and use it later in designer.
hope it will help you,
have a good luck and welcome in great analytics journey!
Petr
@ssheffer Sorry, I missed one important word in your message, sorry for than, you are looking for OUTPUT, sorry, the Dremio connector is READ ONLY as stated in help file. https://help.alteryx.com/current/en/designer/data-sources/dremio.html So unfortunately we don support the write operations.