Smartsheet ODBC, Tableau, and DataTable

Neil Egsgard
Neil Egsgard ✭✭✭✭✭
edited 03/25/24 in API & Developers


We are trying to connect Smartsheet data in a Smartsheet DataTable to Tableau. We have too much data for a single Smartsheet sheet to hold all the data. Is there a way to pull data from a Smartsheet DataTable into Tableau? So far the methods considered are:

  1. Smartsheet ODBC connector
    1. Not seeing the DataTable as source option
  2. SQL from Smartsheet to Tableau
    1. Not possible based on this discussion on Feb 16, 2023
  3. Put data into sheets using DataTable Connector and then pull the data into Tableau
    1. This would work but is not ideal because we would have to maintain additional source sheets. We are using DataTable so we only have one source.

Thank you,

Neil Egsgard

Best Answers