This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
..but this would not work correctly with the standard input tools. We rec'd a generic error. But we found that if we use the In-DB tools, it would read/write the data correctly. In the Workflow we have the In-DB Connect, Select, & Data Stream Out
For the In-DB Connect, from the Connection Name drop down, you have to configure a new Connection using the ODBC driver. We used Generic ODBC
Then you should be able to select your table or write you SQL
I'm not sure why, but with the In DB Stream Out, we had to choose at least one field to sort by for it to work.
Not sure if you have the ability to configure an ODBC connection for you situation but this is what we got to work for Splice Machine.