Verify Data in Any Connector Using Skyvia Query

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

Steps

  1. Log in to Skyvia and navigate to + Create New → Query.
  2. Select an existing connection or establish a new one for your data source.
  3. Choose the desired table or object from the Connection Object List.
  4. Use the Builder view to visually select columns, apply filters, sort, and aggregate data — or switch to SQL view to write custom SQL statements.
  5. Run your query and review the results.

Info

The Free Skyvia Plan allows up to 5 queries per day. Check out the full pricing details here.

    • Related Articles

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

    • SQL Server: Execution Timeout Expired

      Overview The error Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding occurs when a SQL Server command takes longer to execute than the configured timeout limit allows. This is ...

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

    • Integration Failure Types in Skyvia Data Integration

      Overview When using Skyvia Data Integration, you may encounter two distinct types of integration failures: 1. Record-Level Errors These occur when one or more individual records fail to process during an integration task. For example, in operations ...

    • Backing Up Association Data with Skyvia

      Overview Association data refers to the relationships between records in a data source. For example, in a CRM system, association data might include the connections between customers, contacts, and accounts. Losing this data can lead to data ...