While connected live to a SQL table, you right-click a column in Tableau's Data pane and choose Rename. What happens as a result of this action within Tableau Desktop and in the underlying database schema?
Both Tableau and the source database are updated; Tableau issues an ALTER TABLE command to rename the physical column.
The field is renamed in Tableau, but you must refresh the connection or extract before any worksheet will display the new name.
Only the current worksheet shows the new name; other worksheets continue to display the original field name until manually renamed.
The field's name is updated in all worksheets in the workbook, but the original database column name remains unchanged.
Renaming a field in Tableau only changes the friendly name that Tableau displays inside the workbook (and any other workbooks or data source files that reuse the renamed metadata). All worksheets in the workbook immediately reflect the new field name, but the actual column name in the source database or extract is left untouched. Therefore, there is no need to refresh data or modify the database itself. The change is purely a metadata adjustment within Tableau.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What does 'live connection' mean in Tableau?
Open an interactive chat with Bash
What is the difference between renaming a field in Tableau versus changing its name in the database?
Open an interactive chat with Bash
What does 'friendly name' mean in the context of Tableau?
Open an interactive chat with Bash
What does a 'live connection' mean in Tableau?
Open an interactive chat with Bash
How does renaming a field in Tableau affect the database schema?
Open an interactive chat with Bash
What is Tableau metadata and why is it important?
Open an interactive chat with Bash
Tableau Desktop Foundations
Connecting to and Preparing Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .