---
schema_version: "1"
id: e148abc868ea41a0db40403f8284335eff0f8191233f2ce19adfdb83d655d017
title: Schedule Extract Refreshes for a Virtual Connection
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/online/dm_vconn_extract.md
canonical_url: https://help.tableau.com/current/online/en-gb/dm_vconn_extract.htm
source_site: help.tableau.com
content_type: documentation
content_hash: eb153089dd3c57321934fb1dd68ba2c7e7ba303830b76207a728c33944192c19
description: Schedule extract refreshes for the tables in a virtual connection to keep data fresh.
---
[Skip to main content](#main-content)

# Schedule Extract Refreshes for a Virtual Connection

One of the benefits of virtual connections is that you can reuse the same extract multiple times, reducing data proliferation and removing redundant extract refresh jobs. To ensure that extract data is fresh for any content that uses a virtual connection, you can create an extract refresh schedule for the tables in your connection after you publish the connection.

You can also schedule extract refreshes of data sources and workbooks that use virtual connections. See [Schedule Refreshes on Tableau Cloud](https://help.tableau.com/current/online/en-gb/schedule_add.htm) and [Refresh Data on a Schedule](https://help.tableau.com/current/server/en-gb/schedule_add.htm) (Tableau Server).

## Extract tables

See [Extract table data](https://help.tableau.com/current/online/en-gb/dm_vconn_create_conn.htm#vconn_extract_table_data).

## Schedule extract refreshes on Tableau Cloud

1. Navigate to the virtual connection page. (From the Home or Explore page, click Virtual Connections from the drop-down menu, then select your virtual connection.)
2. At the top of the page, a heading should say Data is Extract. If it says Data is Live, refresh your browser.
3. Select the Scheduled Tasks tab and click +New Task.
4. The Create Scheduled Task dialog box opens. The Create Scheduled Task dialog box looks different in Tableau Server and Tableau Cloud. If you are using Tableau Server, see [Schedule Extract Refreshes for a Virtual Connection](https://help.tableau.com/current/server/en-gb/dm_vconn_extract.htm#schedule-extract-refreshes-on-tableau-server) in the Tableau Server Product Help.
5. Select the Refresh Frequency using the drop-downs for Repeats, Every and At. Use the buttons under On to select the days of the week.
6. For cases when multiple tables use extracts, select Dependent or Independent.
    - Dependent means that none of the extracts will be updated if one or more tables' extract refresh jobs fail.
    - Independent means that the success or failure of a table's extract job doesn't affect whether or not other tables' extracts are updated.
7. Select Refresh Type. You can configure the type of extract in the virtual connection editor. For more information, see the Incremental Extracts section of the [Create a Virtual Connection page](https://help.tableau.com/current/online/en-gb/dm_vconn_create_conn.htm#incremental-extract).
    - Full means that full extract refresh jobs will be run on all extracts in the virtual connection, regardless of whether they are configured for full extract refresh or incremental extract refresh.
    - Incremental means that incremental extract refresh jobs will be run on all incremental extracts in the virtual connection. For all other extracts in the virtual connection, full extract refresh jobs will be run.
8. Select Add or Edit Tables and select the tables you want to refresh.
9. Select OK.
10. Select Apply.
![](/tableau/current/en-gb/online/en-gb/Img/dm_vconn_online_extract_sched.png)

Virtual connections that connect to private network data use Tableau Bridge to keep data fresh. For more information, see [Configure and Manage the Bridge Client Pool](https://help.tableau.com/current/online/en-gb/to_enable_bridge_live_connections.htm).

## Time limit for extract refreshes

To ensure that long-running refresh tasks don't take up all system resources and don't prevent refreshes of other extracts on your site, extract refreshes for a virtual connection are subject to a two-hour time limit. For more information about the timeout limit for refresh tasks and suggestions for resolving these errors, see [Time limit for extract refreshes](https://help.tableau.com/current/online/en-gb/schedule_add.htm#timeout). Note: Starting with Tableau Cloud June 2024 and Tableau Server 2024.2, virtual connections support incremental refresh for table extracts. Prior to that release, virtual connections only supported full refreshes.

## Who can do this

To publish a virtual connection or set permissions, you must

- have credentials to the database that the virtual connection connects to, and
- be a server or site administrator, or a Creator.

## Next step

After you schedule extract refreshes for a virtual connection, you can [Use a Virtual Connection](https://help.tableau.com/current/online/en-gb/dm_vconn_use.htm)