Snowflake connection fails in extract due to invalid authorization
The source of the issue is unknown, but you can take a couple steps to resolve the issue:
- Login to Tableau server at: https://tableau.wisconsin.edu/
- On top right hand corner, click on your icon (1 in the image below)
- From the menu, choose “My Account Settings” (2 in the image below)
- Make sure you are on the “Settings” tab (3 in the image below)
- Scroll down until you see “Snowflake” (4 in the image below)
- Delete the credentials you see (5 in the image below)
- After deleting, we want to re-add it. Click “Add” (6 in the image below)
- In the pop-up window, specify the following settings:
- Instance URL: laa66896.us-east-1.snowflakecomputing.com
- Role: leave it blank.
Snowflake Connection fails in Tableau Desktop
If you see an error like this when you try to connect to Snowflake:
Please follow these steps:
- Close Tableau if it’s open.
- Go to Control Panel > Programs > Programs and Features.
- Find Tableau in the list of programs. Click Uninstall/Change.
- Click Repair in the pop-up window.
If that fails, then uninstall and re-install Tableau (you’ll likely need to have your product key at hand, just in case Windows doesn’t remember it).
Invalid username or password error on publish
On the publish window, click the “Edit” under “Data Sources”. Then click the dropdown for your Snowflake connection and choose yourself. Like this:
The lost connection error
Error "The crosstab exceeds the size allowed and cannot be exported." Exporting to Crosstab
Tableau Server has a limit 33,554,432 cells for downloading csv from crosstab. Limit the data by filtering before downloading it and it should resolve the issue.