Check Native Filter Support for Columns in Skyvia

How to Check if a Column Supports Native Filtering in Skyvia

Overview

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 does not 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 is set to true, the column supports native filtering.
    • If it is false, filtering by that column will not reduce API load.

Best Practices

  • 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: Verify Data in Your Connection

      Overview Skyvia Query allows you to browse and verify data in any connected data source directly from the Skyvia interface, without writing complex scripts or using third-party tools. You can use the visual Builder view or write custom SQL ...

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

      Overview This article explains how to configure an UPSERT operation for the Mailchimp ListMembers object in Skyvia. This is the recommended approach for importing and updating Audience members without creating duplicates. How UPSERT Works for ...

    • Skyvia Backup Errors Caused by Salesforce API Requirements

      Overview Skyvia interacts with Salesforce via its API. During a backup or replication operation, you may encounter errors caused by certain limitations or behaviors specific to the Salesforce API. Why This Happens When Skyvia performs a backup or ...

    • HubSpot: 414 Request-URI Too Large / 400 Request Header or Cookie Too Large

      Overview The errors 414 Request-URI Too Large and 400 Request Header or Cookie Too Large are returned by the HubSpot API when a single API request exceeds the maximum allowed size. This typically occurs when querying HubSpot objects that have a large ...

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