Check Native Filter Support for Columns 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 ...

    • 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 ...

    • 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 ...

    • Skyvia Query: You have reached the limit of queries

      Overview The error message "You have reached the limit of queries" indicates that your Skyvia account has exceeded the maximum number of queries allowed under the Free plan for the current day. No additional queries can be executed until the limit ...

    • A Comprehensive Guide on Backing Up Association Data with Skyvia

      Are you looking for a way to back up association data of your data source? Perhaps you're concerned about losing important relationships between records in case of data loss or migration. In this article, we'll explore the process of backing up ...