1. Latest Release Home
  2. Guides
  3. Concepts
    1. Aggregate filter
    2. Alias
    3. Apache Avro™
    4. Apache Kafka™
    5. Applied filter
    6. Base table
    7. Bookmark
    8. Business schema
    9. Business schema view
    10. Business schema view column
    11. Business schema view formula column
    12. Column
    13. Connector
    14. Dashboard filter
    15. Dashboard folder
    16. Dashboard runtime filter
    17. Data agent
    18. Data alert
    19. Data destination
    20. Data purge
    21. Data retention
    22. Date system variable
    23. Direct query
    24. Distinct filter
    25. Dynamic field
    26. Expression
    27. External data source
    28. External session variable
    29. External table
    30. Filter expression
    31. Filter expression session variable
    32. Filter option
    33. Formula column
    34. Formula expression
    35. Full load
    36. Global variable
    37. Incorta Analyzer Table
    38. Incorta Analyzer Table column
    39. Incorta Analyzer Table formula column
    40. Incorta Analyzer View
    41. Incorta Analyzer View formula column
    42. Incorta Spark SQL View
    43. Incorta SQL Table
    44. Individual filter
    45. Insight filter
    46. Internal query expression
    47. Internal session variable
    48. Join
    49. Join condition
    50. Join condition column
    51. Join filter
    52. Join filter column
    53. Level-based measure
    54. Load filter
    55. Local data file
    56. Local data folder
    57. Log-based incremental load
    58. Materialized View
    59. Materialized View column
    60. Materialized View formula column
    61. Measure filter
    62. Miscellaneous system variable
    63. Multi-source table
    64. Physical schema
    65. Physical schema table
    66. Physical schema table column
    67. Physical schema table formula column
    68. Physical schema table runtime security filter
    69. PostgreSQL (Incorta SQL) View
    70. Presentation variable
    71. Prompt
    72. Query system variable
    73. Remote table
    74. Runtime business view
    75. Runtime business view formula column
    76. Runtime security filter
    77. Schema evolution
    78. Service Status Observability
    79. Session variable
    80. Shared Storage
    81. Upgrade Readiness
    82. Variable
    83. Visualization
  4. Tools
  5. References
  6. Integrations
  7. Data applications
  8. Data Governance
  9. Release Notes
  10. Incorta Premium
  11. Release Support Policy
  12. Release Model

Concepts → Direct Query

Overview

In 2026.3.0, Incorta introduced the Direct Query Integration feature, a significant capability that enables you to query live data directly from source systems and visualize results instantly within Incorta. This feature provides real-time access to source data, drastically reducing your time-to-insight and simplifying data exploration by eliminating traditional data modeling and ingestion steps.

Prerequisites

  • As of 2026.3.0, Direct Query is a preview feature available on Incorta Cloud only and requires a Premium cluster.
  • The feature is disabled by default. To enable it, contact your Account Executive.
  • Afterward, you can configure the feature from the Cluster Management Console (CMC) > Clusters > <yourCluster> > Tenants > <yourTenant> > Configure > Direct Queries Integration.
Important
  • This feature currently supports Snowflake as the exclusive data source, with plans to support additional data sources in future releases.
  • It is recommended to use aggregated queries to improve performance.

How it works

After configuring the feature, you can create a Snowflake result set or view to execute SQL queries against the Snowflake data, and then visualize results directly in Incorta's insights interface, bypassing traditional schema creation and data-loading workflows. Query results reflect real-time source data, ensuring analysis accuracy without refresh delays.

Caching direct queries

To balance real-time data needs with system performance and resource efficiency, Incorta supports caching the direct query results. When a user opens an insight created via a direct query, the system checks the cache validity. If the cache has expired, the system automatically retrieves fresh data from the source, ensuring optimal performance without compromising data freshness.

You can specify the Cache Validity Duration globally in the CMC or at the result set and business view to override the global CMC setting, providing flexible control over caching behavior for different workloads.