Hi All,
I am running into a problem since last 2 days. Would appriciate a help here.
Tableau Desktop + Snowflake: Database/Schema/table list never loads (warehouse list does)
Setup: Tableau Desktop on a Mac (Apple silicon), Snowflake connector, OAuth/SSO sign-in via Okta. Tested on 2026.3 (build 20263.26.1022.1645) and 2026.1, Snowflake ODBC driver 03.80.
Problem: sign-in succeeds and the Warehouse dropdown fills with the right warehouses, but the Database, Schema and table sections never appear on the data source page. "New Custom SQL" is not available either, so there is no way to pick a table.
What the logs show:
- tabprotosrv: warn database-error "[Snowflake][Snowflake ODBC Driver] No more data available", sql-state 02000 (SQLSTATE_METADATA_OBJECT_NOT_FOUND), retcode 100 SQL_NO_DATA, followed by excp 0xA5E10DD9 NOT_FOUND at connectivity_stage CS::LoadMetaData (ConnectivityException::Init, server_version empty). It appears on every connection.
- On the Snowflake side, query history for my user shows only SHOW WAREHOUSES and USE WAREHOUSE for each session. Tableau never sends SHOW DATABASES, SHOW SCHEMAS or SHOW TABLES.
- In Snowsight, SHOW DATABASES returns the same six databases for both roles I use, so this does not look like a permissions problem.
Already tried, no change: full uninstall and clean reinstall (preferences, caches, Keychain entries cleared), 2026.3 and 2026.1, and a TDC with CAP_FAST_METADATA=no (confirmed loaded in the log).
A teammate on 2026.1 (same driver 03.80) works fine. His logs show the same CS::LoadMetaData exception class on some days, but with real Snowflake messages (e.g. "Object does not exist"), not "No more data available". I suspect his connections open with the database and schema already saved in a workbook or data source, but I have not confirmed that.
Questions:
1. Has anyone seen "No more data available" at CS::LoadMetaData with the Snowflake connector?
2. On a brand-new Snowflake connection, do you get the Database/Schema/table list, or do you work from saved workbooks and published data sources?
3. Is there a known cause (driver, OAuth session with no default database or schema, connector setting) or a workaround other than opening a saved connection?
Happy to share the full tabprotosrv log lines. Thanks.
I haven't seen this exact error, so the steps below are for isolating the cause, not a confirmed fix.
Since your Snowsight test used roles you picked yourself, the OAuth session from Tableau may be running with a different role (the user's default one). Could you check:
1. DESCRIBE USER <your user>: look at DEFAULT_ROLE, DEFAULT_NAMESPACE and DEFAULT_WAREHOUSE. Is the default role one that can actually see those databases (not PUBLIC, and not an admin role that Snowflake's OAuth integration blocks)? Compare the values with your teammate's.
2. In the Tableau sign-in dialog, enter a Role that returns the six databases in Snowsight, then sign in again.
3. Sign in with username/password instead of OAuth in the same Desktop build. If the database list loads, the OAuth session/role is the likely cause. If it doesn't, it points to the driver or Desktop side.
If it still fails, a support case with the full tabprotosrv log lines plus the Tableau build and driver version would help.
