Editar

sys.sp_dw_refresh_ext_table (Transact-SQL)

Applies to: SQL analytics endpoint in Microsoft Fabric Mirrored databases in Microsoft Fabric SQL database in Microsoft Fabric

Use the sp_dw_refresh_ext_table stored procedure to refresh the data for a specific table within a SQL analytics endpoint.

Syntax

Transact-SQL syntax conventions

sys.sp_dw_refresh_ext_table
    [ @tablename = ] "table_name"
[ ; ]

Arguments

[ @tablename = ] "table_name"

The table name is required. The @tablename parameter is two-part name of the table, in quoted identifiers, to be refreshed.

Returns

0 (success) or 1 (failure).

Permissions

You should have access to a SQL analytics endpoint in Microsoft Fabric within a Fabric workspace with Contributor or above permissions.

Remarks

As of May 2026, if you are on the new version of the metadata sync, then you can use sp_dw_refresh_ext_table.

Examples

To refresh the table dbo.publicholidays in the current SQL analytics endpoint.

EXEC sys.sp_dw_refresh_ext_table "dbo.publicholidays"