--- schema_version: "1" id: b705776802d8e5b5c77909e998463593665df151cbe73daac3a9310f39f9124d title: Add Tables to the Connection collection: tableau version: next locale: en-us portal_url: https://docs.salesforce.com/tableau/next/en-us/server/ipa_vconn_add_tables.md canonical_url: https://help.tableau.com/v0.0/server/en-us/ipa_vconn_add_tables.htm source_site: help.tableau.com content_type: documentation content_hash: 30216cb8eec4c2c1583cde07e2030a38edf094f950ba6804f218b0b038646c78 description: Quick help on adding tables to a virtual connection and setting table mode. --- [Skip to main content](#main-content) # Add Tables to the Connection On the Tables tab: Add tables to the connection **Add tables** Choose an option: - On the left, under **Tables**, double-click table names or select and drag them to the **Tables** pane on the right. Include an entitlement table, if you're using one. - Select ![New Custom SQL button](/tableau/next/en-us/server/en-us/Img/ipa_New_Custom_SQL_btn.png) to create a custom table schema, or select Convert to Custom SQL on an existing table and use it as a starting point for Custom SQL. Select ![The refresh data icon in the virtual connection editor toolbar](/tableau/next/en-us/server/en-us/Img/ipa_vconns_refresh_icon.png) to get the latest data from the database for all the connections. **View and edit table details** 1. Select a table in the Tables tab. 2. In the Table Details section, select a column value to make edits like hide or rename a column, or change the data type. Select live or extract mode for tables Set individual tables to either live or extract mode: - Live Only\- Queried directly from the database. (Live is the default.) - Extracts Only\- Extracted and saved to Tableau. Under Tables, select the table or tables you want to change the mode for and select Actions, and Change to Live or Change to Extract. - Select Create Pending Extracts to create extracts, or Refresh All Extracts to refresh them after creation. - Select a table's Actions menu (...) > Extract Settings to configure the extract for incremental refresh. - Schedule extract refreshes on the virtual connection page after you publish the connection. [Read schedule extract topic](https://help.tableau.com/current/server/en-us/dm_vconn_extract.htm) Set the table visibility state Use the Visibility toggle to show or hide tables from users. ![Check mark means show](/tableau/next/en-us/server/en-us/Img/ipa_vconn_check_mark_show.png) Users can see table data. Create a policy to govern which data users can see. (Visible is the default.) ![X means hide](/tableau/next/en-us/server/en-us/Img/ipa_vconn_x_hide.png) Users can’t see table data. You can use hidden tables in a data policy and as an entitlement table. See table details Select a table at the top of the Tables tab to see its details below. Switch the table information you see using these icons: ![Tag icon represents column data type.](/tableau/next/en-us/server/en-us/Img/ipa_Tag_16px_medium.png) Data type for each column. ![Table icon represents column sample data.](/tableau/next/en-us/server/en-us/Img/ipa_Table_16px_medium.png) Sample data for each column. ![Profile icon represents the column value range.](/tableau/next/en-us/server/en-us/Img/ipa_Panes_show_16px_medium.png) Range of values in a histogram for each column selected. **Quick clip**: View your table details. Your browser does not support the video tag. See Linked keys by selecting ![table icon](/tableau/next/en-us/server/en-us/Img/ipa_Table_16px_medium.png) to see which columns link to other tables. Linked keys show only when databases have primary and foreign key information. Publish the connection and set permissions ### Save a draft or publish a connection Your connection is automatically saved as a draft while you work. Manually save the draft by clicking ![Save icon](/tableau/next/en-us/server/en-us/Img/ipa_Save_16px_medium.png). To share a new virtual connection with other users, you need to publish it. 1. Click ![Publish button](/tableau/next/en-us/server/en-us/Img/ipa_vconn_publish_btn.png) in the upper right corner of the editor. 2. Type a name for the connection in the Name field. 3. Select a project to save the connection to. 4. Click ![Publish button](/tableau/next/en-us/server/en-us/Img/ipa_vconn_publish_btn.png) When you edit an existing connection, it remains available to users in its current published state. - To save updates to a draft, click ![Save icon](/tableau/next/en-us/server/en-us/Img/ipa_Save_16px_medium.png). - To make the updated connection available to users, click ![Publish button](/tableau/next/en-us/server/en-us/Img/ipa_vconn_publish_btn.png) ### Set permissions so others can use the connection You've published the connection, and you're ready to let others use it. To do this, set the Connect capability to Allowed. 1. Navigate to the virtual connection. 2. Open the Actions menu (...) and click Permissions. 3. Select the box under the Connect icon so that connect is allowed for all users. ![Connect capability check box under Permissions Rules](/tableau/next/en-us/server/en-us/Img/ipa_vconn_connect_capability.png) 4. Click Save. [Read publish and permissions topic](https://help.tableau.com/current/server/en-us/dm_vconn_publish_save.htm) [Read virtual connections topic](https://help.tableau.com/current/server/en-us/dm_vconn_create_conn.htm) ## Related tasks [About the Virtual Connection Editor](https://help.tableau.com/v0.0/server/en-us/ipa_vconn_about_editor.htm) [About Data Policies](https://help.tableau.com/v0.0/server/en-us/ipa_vconn_about_data_policy.htm) [Create and Test Data Policies](https://help.tableau.com/v0.0/server/en-us/ipa_vconn_create_data_policy.htm) Not finding what you need? Go online to see [all Tableau help](https://www.tableau.com/support/help)