Articles in this section

Export data from Microsoft Fabric Warehouse

Naga Sri Hari Gonaboyina
Updated

Export data from Microsoft Fabric Warehouse by running a T-SQL query against the warehouse your connection points to. Use the export as the source of a flow to send warehouse data to another application.

Tip: To use handlebars in your query, select the handlebars icon next to SQL query to open the Handlebars editor.

Before you begin

Set up a connection to Microsoft Fabric Warehouse if you don’t have an existing connection that you can use.

Export data from Microsoft Fabric Warehouse

  1. From the Resources menu, select Exports.
  2. Select + New export.
  3. In the Create export panel, enter a name for the export. Name is required. Description is optional.
  4. From the Application list, select Microsoft Fabric Warehouse.
  5. From the Connection list, select an existing connection, or select Create connection to add a new one.
  6. In SQL query, enter the SQL statement that returns the data you want to export. Write the table name as table (the schema defaults to dbo), schema.table, or warehouse.schema.table, where the warehouse is the one on your connection. Put square brackets around names with special characters, for example [my schema].[my table].
  7. From the Export type list, select All, Delta, Once, or Limit, and then select Save.

Note: Fabric Warehouse uses a case-sensitive collation by default, so string comparisons in your query are case-sensitive: WHERE Name = 'acme' doesn’t match Acme. The collation is set when the warehouse is created.

Export types

Export type Description
All Exports all data every time the flow runs.
Delta Exports only data that has changed since the last time the flow ran. Your query must compare a column to {{lastExportDateTime}} or {{currentExportDateTime}}, for example SELECT * FROM dbo.Orders WHERE ModifiedDate > {{lastExportDateTime}}. integrator.io inserts {{lastExportDateTime}} as an ISO 8601 UTC timestamp with milliseconds, already in single quotes, for example '2026-11-12T07:30:00.000Z', so don’t add your own quotes.
Once Exports only records that haven’t already been exported. In SQL once query, enter a query that marks each exported record, for example UPDATE dbo.Orders SET exported = 1 WHERE id = {{data.id}}. The query runs once for each exported record, so the service principal needs UPDATE permission on the table that it updates.
Limit Exports a set number of records each time the flow runs. Enter a number from 1 to 100 in How many records would you like to export? The default is 1. Use it to test a flow without exporting a lot of data.

Optional settings

Setting Description
Group records by fields Select the fields to group by, so each group is treated as one record downstream in your flow. Sort the data in your query, or grouping may not work as expected.
Page size The number of records in each page of data. If you leave it blank, the default is 20. A page is capped at 5 MB.
Data URI template A handlebars template that adds a link to the original data on each error in the job dashboard.
Override trace key template A handlebars expression that defines the key integrator.io uses to identify a unique record.

Related articles