The Omnata QuestDB Plugin ingests time-series data from QuestDB directly into Snowflake. Running as a Native App inside your Snowflake account, on a schedule you control, with no external infrastructure and no data passing through Omnata's servers.

Connect to self-hosted or platforms like Inductive Automation Ignition

QuestDB is a high-performance time-series database purpose-built for ingesting and querying large volumes of timestamped data. It's the backend of choice for industrial monitoring platforms, IoT telemetry, financial market data, and application metrics.

Platforms like Inductive Automation Ignition, the leading SCADA and industrial monitoring platform use QuestDB as the historian backend, storing millions of data points from PLCs, sensors, and industrial equipment. That operational data in QuestDB is used for real-time monitoring and control. However, for analytics, you need a platform like Snowflake, where you can combine it with ERP data, production schedules, maintenance records, or financial data.

The Omnata plugin is the easiest native way to connect to QuestDB.

Built for time-series data volumes and characteristics

Time-series data has properties that make standard database integrations unreliable — high row counts, late-arriving records, and the need for efficient incremental windows rather than full table scans.

The plugin handles these natively. Every table and view in your QuestDB instance is automatically discoverable as an inbound stream. Incremental syncs use a timestamp cursor field to fetch only what's changed, chunking queries into manageable batches — up to one million records per query by default, configurable up to five million — so large time windows don't overwhelm either system.

A configurable lookback window (default five minutes) steps back at the start of each sync run to catch late-arriving records that may have landed after the previous run's cut-off. For industrial and IoT data where sensor readings can arrive out of order, this makes incremental sync reliable without requiring a full refresh.

Up to 64 streams can be processed concurrently, so syncing a QuestDB instance with many tables — typical in monitoring environments — runs efficiently without serialising each table one at a time.

Three connectivity options

As a native app, Omnata's installation and config is super easy and can be completed in minutes.

QuestDB is frequently deployed on-premises or inside a private VPC, particularly in industrial and manufacturing environments where the data originates from plant-floor systems that never touch the public internet.

Omnata supports the usual database connection modes:

• Direct connection - where you can make QuestDB accessible over the internet, with standard TLS encryption.

• Ngrok - secure private tunnels for any cloud or on-premises combination.

• Snowflake PrivateLink - cloud native private network path between Snowflake and QuestDB without exposing the database to the public internet. Requires Snowflake Business Critical edition with matching cloud providers; AWS-AWS, Azure-Azure, etc.

See it in action

Get started

Available on the Snowflake Marketplace with a 30-day free trial. Requires Omnata Sync (free core listing) and a QuestDB instance with network access configured for one of the three connectivity options above.

You can pay for Omnata using Snowflake Credits (if in an eligible region).

Documentation · Marketplace listing