Skip to content

Databricks Workbook Table Name Length Limit #1189

Closed

Description

@williamdphillips

Describe the bug
When using TSC and attempting to publish a Tableau Workbook created with Tableau Desktop 2022.1.10, there seems to be a table name char limit that Tableau is using internally for the references. When a table name (note that connection names in a workbook's xml) exceeds 63 chars, the name of the connection is cutoff, making it possibly different from the actual table name. This seems like it would not be a problem if, when publishing, the actual table name was being referenced. However, when attempting to publish such a workbook with TSC, the connection to the datasource fails. It seems like this is because it is attempting to connect using the name of the connection rather than the table defined within the connection. If the connection name is within the 63 char limit, this issue doesn't exist.

Example of a connection defined within the xml of a workbook using Databricks SQL connection source:
<relation connection='databricks.0e0f5f608zo1r61aqy9xh11sjmxu' name='drew_databricks_notebook_workpaper_v1_output_aging_category_rat' table='[my_database].[drew_databricks_notebook_workpaper_v1_output_aging_category_ratio_output]' type='table' />

Versions
Details of your environment, including:

  • Tableau Desktop: 2022.1.10
  • Tableau Server Version: 2022.1.10
  • Python version: 3.8
  • TSC library version: 0.23

To Reproduce

  1. Create a Tableau Workbook using Tableau Desktop with Databricks SQL as the source
  2. Using PAT authentication, connect to a SQL Warehouse and ensure you are using a long table name >63 chars
  3. Save the workbook with the connections as well as some visualizations for testing
  4. Check out the XML and note the connection name is cutoff
  5. Attempt to publish the workbook to Tableau Server with TSC
  6. The error will mention that you are unable to establish a connection to the datasource, even though you just did with Tableau Desktop

Error
{ "error": "Tableau_TradeAR_Notebook_2 failed to establish a connection to your datasource." }

Activity

  1. williamdphillips commented on Apr 20, 2023

    @williamdphillips
    Author

    Just an update on this. We again ran into a similar issue when upgrading to 2022.1.11. When attempting to publish a workbook to Tableau Server (via TSC or UI) that was created from Tableau Desktop, if that workbook has a connection (Databricks SQL) that is long, Tableau Server throws a 500 internal server error.

    I'm not sure if this is because of the table name length itself or because of the catalog.schema.table_name total length. We tried reducing the table name for one workbook to test, and it resolved the issue. However, in order to fully resolve it was are opening a support ticket with Tableau to find out why the error is being thrown.

  2. williamdphillips commented on Oct 23, 2023

    @williamdphillips
    Author

    Due to not getting this resolved with Tableau Support, our team was forced to ensure the three level namespace for our schema+tables did not exceed 124 chars.

  3. github-actions commented on Aug 6, 2026

    @github-actions

    This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 14 days if no further activity occurs. If this is still relevant, please comment to keep it open.

  4. jacalata commented on Aug 6, 2026

    @jacalata
    Contributor

    This wasn't actually something that could be fixed in TSC, it is a server-side issue that affected all clients. I don't know if it still exists.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions