How to Check if a Column Supports Native Filtering in Skyvia

How to Check if a Column Supports Native Filtering in Skyvia

Filtering helps make your integrations and backups faster and lighter by reducing the amount of data Skyvia pulls from your source.

However, not all objects and fields support native filtering. If a column doesn’t support native filters, applying a filter to it will not speed up data retrieval. In fact, it may even slow it down because the filtering happens after all data is fetched.

To make sure your filters actually help optimize performance, you can easily check whether a column supports native filtering directly in Skyvia Query.

How to Check Native Filtering Support
1. Go to +Create New → Query → SQL in your Skyvia workspace.
2. Select the connection you want to use.
3. Choose the object (for example, Invoices).
4. Click the small info icon next to any column name, this opens the column properties.
5. Look for the Filterable attribute:
      - If it’s set to true, the column supports native filtering.
      - If it’s false, filtering by that column won’t reduce API load.

The best practice is to use only filterable fields in your filters when building integrations, backups, or queries - this ensures Skyvia applies filtering on the source side, not after all data is retrieved.
Checking this before running large backups or data flows can help you avoid API limits, speed up data extraction, and reduce unnecessary load on your connected app.


    • Related Articles

    • Skyvia Query: Easily Verify Data in Your Connection!

      Please follow the steps below to query your data in Skyvia Query: Log in to Skyvia and navigate to + Create New → Query. Select an existing connection or establish a new one for your data source. Choose the desired table or object from the Connection ...

    • Skyvia Query: You have reached the limit of queries

      If you encounter the message "You have reached the limit of queries," it indicates that you have exceeded the maximum number of queries allowed for your Free plan on Skyvia Query. The Free Query plan is designed for basic testing purposes and allows ...

    • A Quick Guide to Importing and Updating Audience Members in Mailchimp

      If your integration involves importing data into Mailchimp Audiences, this information might be helpful. To start, let’s take a quick look at how the UPSERT operation works: If the Id is specified, the integration attempts an Update operation even if ...

    • Understanding Records in Skyvia Data Integration

      1.1 Understanding Records in Skyvia Data Integration A record in Data Integration represents a single row in a database table. Every integration process (Import, Replication, Export, Synchronization, etc.) handles individual records. Records also ...

    • Skyvia Backup Errors Caused by Salesforce API Requirements

      Skyvia interacts with Salesforce via its API. During a backup operation, you may encounter errors due to certain limitations or behaviors specific to the Salesforce API. For example, when Skyvia performs a backup or replication, it queries all the ...