Documentation

Extraction orders

Learn how to see the list of your extraction orders and their settings

You can find your extraction orders grouped by connections or by data tables.

To see the list of extraction orders related to one of your connections, you need to:

  • Select the Connections item in the left menu
  • Choose the required connection from the connected sources list.

To see the extraction orders list related to one data table, you need to:

  • Select the Data explorer item in the left menu
  • Choose the required data table from the list.
  • ~In this case, above the list of extraction orders, you may see a list of load orders related to the same data table.

After this, you will see the overview tab. This tab shows the list of extraction orders for the current connection.

Use the search field to find the necessary extraction order by:

  • Extraction order
  • Data source (because of extraction order name formation rule)
  • Extraction template (because of extraction order name formation rule)
  • Account (because of extraction order name formation rule)

Also, you can sort the data ascending or descending in every column except Action.

The extraction orders list includes eight columns. Let's look at each of them in more detail.

Extraction order name

The extraction order name is formed according to the Data Source — Extraction Template — Account rule. Extraction orders created via auto-extract have the Automated label next to their names. You can click the extraction order name to dive into its settings.

Created by

Here you see the email of the user who created the extraction order.

Extraction template

This column shows which extraction template you’ve selected when setting up data extraction.

Account

This column shows the account on the data source for which you created this extraction order.

Extraction order status:

  • Data is synced - data syncing process is completed successfully
  • Syncing - data syncing is in process
  • Paused - the extraction order is paused. No data will be extracted according to the schedule

{%docs-informer info%}

Extraction orders will be automatically paused in the following cases:

  1. The corresponding connection is deleted from the Improvado platform.
  2. Any error occurs with the corresponding connection.
  3. Your account is not available under the corresponding connection.

{%docs-informer-end%}

  • Error - something wrong happened, and data was not extracted successfully

To see the description of an issue, you need to click the "plus" icon near the extraction order name.

Last update

Here you can see when the last data sync was completed.

Create date

Here you can see when this extraction order was created.

Action column

There are two icons in this column:

  • Run button
  • Start/Pause button

You can run extraction order, pause or start data extraction using them.

Please note that you can also use Bulk Actions for multiple selected orders. Learn more.

Note: There is no option to delete the extraction order or your extracted data. You can use Pause instead to pause an extraction. You can always start it again if necessary.

The success message means that the sync process has been successfully initiated, not completed! Until the sync of each extraction order is completed, the error message "Some of Data Table extracts are already running" will appear on repeated click.

Also, you can not run data synchronization while the extraction order is paused. You will see the following error message "Data syncronization was not started, please unpause your extraction order".

Run Extraction button

Click this button to run the Extraction order for the selected date range.

Frequently asked questions

How to check the freshness of my data?

To check the freshness of your data, you can refer to the Last update column in the Data Table. This column displays the timestamp of the last data sync.

  • The last update date of the Extraction order shows the freshness of the data extracted from your connected Data source to the Internal Improvado storage
  • The last update date of the Load order shows the freshness of the data loaded from Internal Improvado Storage to your Data Warehouse

You can also manually trigger a data sync by clicking the Sync data now button from the Data Table page. This will update the data with the latest information.

You can check out a more in-depth guide for Data Tables here.

How to make sure that the schema of the data table will not be changed? (How to freeze data schema?)

If you want to keep a fixed data schema of the Data Table, then follow these simple steps:

  1. Click on the Load settings tab on your Data Table page.
  2. Enable Add new fields after extraction to use the fixed data schema (to freeze data schema). In this case, no matter which dimensions and metrics were selected on the extraction order configuration page, they will not be added to the data table.

Learn more here.

How to connect a Destination?

You can connect any destination in two simple steps:

  1. Select a Destination on this page
  2. Set up the connection by filling in all required fields specific to each Destination

The created connection will appear at the top of the Connected destinations list.

You can check out a more in-depth guide here or find a setup guide for the specific Destination here.

How quickly does an order start extraction after the manual trigger?

When an order is manually triggered, it enters a download queue on our side before synchronization begins. The extraction process starts once the order reaches the front of the queue. The wait time can vary depending on how busy the download queue is at that moment.

This queuing mechanism ensures orderly processing and optimal system performance, so your extraction will start as soon as possible based on queue availability.

Related articles

Related articles

Related articles

☶ On this page
Description

Questions?

Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.