Tables Not Available After Connection to Smartsheet Live Data Connector

[Logan_06]

After creating an ODBC connection to the Smartsheet Live Data Connector, I tried to connect to my Smartsheet tables in Alteryx. It looks like it creates a successful connection, but then none of my tables are available fore me to choose from. What could be causing this issue? 

Visual Query BuilderODBC Connection

[Dubes33]

You have to click on the tables tab and double click the table you want to use this article explains it well how exactly to do it but you also need to remove your uname and quotes in the sql editor after you select the table

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connecting-Alteryx-to-Smartsheet/td-p/...

[apathetichell]

I can't get this thread to open (access denied) but my memory is there was a solid discussion of using API connectivity to Smartsheet vs their terrible ODBC read-only connection...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Upload-Excel-Files-while-writing-to-Sm...