Skip to main content
Ctrl+K
Product documentation - Home Product documentation - Home

Get started

  • Quickstart
  • Querona for SQL Server users
  • Querona for analysts and self-service
  • Installation
    • Requirements and compatibility
    • Installation prerequisites
    • Install Querona
    • Installation troubleshooting
    • Post-installation configuration
    • Upgrade Querona
    • Special installation scenarios
      • Installation of SQL Server Engine
      • Installing driver on Cloudera
  • Build data solutions
    • Tutorials
      • Query a REST API with SQL
      • Connect an AI agent to live data (MCP)

Concepts

  • Overview
  • General architecture
  • SQL Server compatibility
  • Governance
  • Querona for AI
  • Data virtualization
    • Federation
  • Virtual tables and views
  • Querona use cases

Connect to data

  • Connections
    • Create a connection
    • Managing connections
  • Data sources
    • Relational databases, NoSQL & big data
      • Actian Matrix
      • Actian Vector
      • Amazon Athena
      • Amazon Aurora
      • Amazon Redshift
      • Apache Cassandra
      • Apache Drill
      • Apache HIVE
      • Apache Kafka
      • Apache Spark
      • Aster Database
      • ClickHouse
      • Cloudera
      • DataStax
      • dBase
      • Denodo
      • Exasol
      • Firebird
      • Google BigQuery
      • Google Cloud SQL for MySQL
      • Hortonworks Data Platform
      • IBM DB2
      • MariaDb
      • Microsoft Access
      • Microsoft Azure HDInsight
      • Azure Database for MySQL
      • Microsoft SQL Server
      • MySql
      • Oracle
      • Percona Server
      • PostgreSQL
      • SAP HANA
      • Sybase
      • Teradata
      • Vertica
    • Data services & files
      • CSV/TSV, PDF, MSG, Text
      • JSON
      • Microsoft Excel
      • REST
      • XML
    • Generic data interfaces
      • ADO.Net and third-party drivers
      • JDBC
      • ODBC
      • OLEDB
    • Collaboration
      • JIRA
      • Microsoft Azure DevOps
    • ERP
      • SAP ERP
    • Financial & e-commerce
      • SAS
    • How to connect to Dynamics 365 service
  • How-to guides
    • How-to connect to text data using Microsoft ODBC

Serve and query data

  • Client Connectivity
    • Connecting from Excel
    • Connecting from PowerBI
    • Connecting from Tableau
    • Connecting from SQL Server using Linked Server
    • Connecting from Python
    • Connecting from Rtools and RStudio
  • Open data endpoints
    • Managing Data API
  • Query editor
  • Data catalog
    • Search
    • Assign tags

Database design

  • Databases overview
    • Create a virtual database
    • Managing the database
  • Tables
    • Adding tables
    • Managing tables
  • Views
    • Adding a view
    • Managing views
  • Schemas
  • Indexes
  • Primary and Foreign Keys
  • Materialization
  • Query Retargeting
  • Management Tasks
  • Bulk operations

Security

  • Data Security
  • Users and roles
  • Access rights
  • Data masking
  • Encrypt incoming connections

Administer

  • Administration
  • Instance configuration
  • Engine configuration
    • Entra Authentication settings
    • Engine settings
    • Job history settings
    • Logging settings
    • Query Store settings
  • Service Management
    • Start, Stop, and Restart services
  • Managing Apache Spark
    • Instance configuration
    • Connection configuration
    • External Spark cluster
  • Jobs and Schedules
  • Monitoring
    • Active statements
    • Client connections
    • Running jobs
    • Alerts
  • Logging & diagnostics
    • Low-level logging
    • Audit logs
    • General logs
    • Debug logs
    • Statement history
    • Execution plan cache
  • SQL Dialects
  • Manage tags

Reference

  • Transact-SQL reference
    • Syntax conventions
    • Feature support
    • Collations
    • Data types
      • Exact numerics
      • Approximate numerics
      • Date and time
      • Character strings
      • Unicode character strings
      • Binary strings
      • Other data types
      • Spatial Geometry
    • Functions
      • Aggregate
        • APPROX_COUNT_DISTINCT
        • AVG
        • CHECKSUM_AGG
        • COUNT
        • COUNT_BIG
        • GROUPING
        • GROUPING_ID
        • KURTOSIS
        • MAX
        • MIN
        • SKEWNESS
        • STDEV
        • STDEVP
        • STRING_AGG
        • SUM
        • VAR
        • VARP
      • Analytical
        • CUME_DIST
        • FIRST_VALUE
        • LAG
        • LAST_VALUE
        • LEAD
        • PERCENT_RANK
        • PERCENTILE_CONT
        • PERCENTILE_DISC
      • Azure
        • DETECT_FACES
        • USER_TO_ITEM_RECOMMENDATION
      • Conversion
        • CAST
        • CONVERT
      • Date and time
        • CONVERT_TZ
        • DATEADD
        • DATEDIFF
        • DATEFROMPARTS
        • DATENAME
        • DATEPART
        • DATETIME2FROMPARTS
        • DATETIMEFROMPARTS
        • DAY
        • EOMONTH
        • GETDATE
        • GETUTCDATE
        • ISDATE
        • MONTH
        • SMALLDATETIMEFROMPARTS
        • SYSDATETIME
        • SYSUTCDATETIME
        • TIMEFROMPARTS
        • TODATETIMEOFFSET
        • YEAR
      • Expression
        • COALESCE
        • IIF
        • ISNULL
        • NULLIF
      • Json
        • ISJSON
        • JSON_QUERY
        • JSON_VALUE
      • Math
        • ABS
        • ACOS
        • ASIN
        • ATAN
        • ATN2
        • CEILING
        • COS
        • COT
        • DEGREES
        • EXP
        • FLOOR
        • LOG
        • LOG10
        • PI
        • POWER
        • RADIANS
        • RAND
        • ROUND
        • SIGN
        • SIN
        • SQRT
        • SQUARE
        • TAN
      • Metadata
        • QUA_PARTITION_HINT
      • Pseudonymization
        • QUA_CONNECTIONSHUFFLEKEY
        • QUA_DESHUFFLE
        • QUA_SHUFFLE
      • Ranking
        • DENSE_RANK
        • NTILE
        • RANK
        • ROW_NUMBER
      • Regular expressions
        • REGEXP_SUBSTR
      • String
        • ASCII
        • CHAR
        • CHARINDEX
        • CONCAT
        • FORMAT
        • LEFT
        • LEN
        • LEVENSHTEIN
        • LOWER
        • LTRIM
        • NCHAR
        • PATINDEX
        • QUOTENAME
        • REGEX_EXTRACT
        • REGEX_REPLACE
        • REGEX_SPLIT
        • REPLACE
        • REPLICATE
        • REVERSE
        • RIGHT
        • RTRIM
        • SPACE
        • SPLIT
        • STR
        • STUFF
        • SUBSTRING
        • UNICODE
        • UPPER
      • System
        • @@DATEFIRST
        • @@MAX_PRECISION
        • @@MICROSOFTVERSION
        • @@OPTIONS
        • @@SERVICENAME
        • @@SPID
        • @@TRANCOUNT
        • @@VERSION
        • APP_NAME
        • ASSEMBLYPROPERTY
        • COL_LENGTH
        • COL_NAME
        • COLLATIONNAME
        • COLLATIONPROPERTY
        • COLLATIONPROPERTYFROMID
        • COLUMNPROPERTY
        • CURRENT_USER
        • DATABASE_PRINCIPAL_ID
        • DATABASEPROPERTYEX
        • DB_ID
        • DB_NAME
        • FULLTEXTCATALOGPROPERTY
        • FULLTEXTSERVICEPROPERTY
        • HAS_DBACCESS
        • HAS_PERMS_BY_NAME
        • HASHBYTES
        • INDEXPROPERTY
        • IS_MEMBER
        • IS_ROLEMEMBER
        • IS_SRVROLEMEMBER
        • JSON_PATH
        • LOAD_FILE
        • NEWID
        • OBJECT_ID
        • OBJECT_NAME
        • OBJECT_SCHEMA_NAME
        • OBJECTPROPERTY
        • OBJECTPROPERTYEX
        • PARSENAME
        • QUA_GET_INCREMENTAL_MARKER
        • SCHEMA_ID
        • SCHEMA_NAME
        • SERVERPROPERTY
        • SESSIONPROPERTY
        • SUSER_SNAME
        • SYSTEM_USER
        • TYPE_ID
        • TYPE_NAME
        • TYPEPROPERTY
        • USER_NAME
      • Tabular
        • fn_builtin_permissions
        • fn_helpcollations
        • fn_listextendedproperty
        • OPENJSON
        • OPENQUERY
        • OPENROWSET
    • JSON
      • Format query results as JSON
        • Add a Root Node to JSON Output with the ROOT Option
        • Format Nested JSON Output with PATH Mode
        • Format results as JSON with FOR JSON
        • Format with AUTO Mode
        • Include Null Values in JSON with the INCLUDE_NULL_VALUES Option
        • Remove Square Brackets from JSON with the WITHOUT_ARRAY_WRAPPER Option
    • Language Elements
      • Control-of-flow
      • Expressions
      • Identifiers
      • Keywords
      • Literals
      • Operators
      • Variables
    • Queries
      • SELECT
        • SELECT statement
        • SELECT Clause
        • SELECT Examples
        • SELECT - GROUP BY
        • SELECT - HAVING
        • SELECT - ORDER BY
        • SELECT - OVER
        • SELECT - FOR
      • FROM
      • WHERE
      • Hints
      • OPTION clause
      • Predicates
      • TOP
    • Spatial Types
      • Geometry type
        • Geometry instance OGC methods
        • Geometry instance extended methods
        • Geometry static OGC methods
        • Geometry static extended OGC methods
    • Statements
      • Data Definition Language (DDL)
        • CREATE DATABASE
        • CREATE SCHEMA
        • CREATE TABLE
        • CREATE VIRTUAL TABLE
        • CREATE VIEW
        • CREATE INDEX
        • CREATE FUNCTION
        • CREATE ROLE
        • ALTER TABLE
        • ALTER VIEW
        • ALTER INDEX
        • DROP DATABASE
        • DROP SCHEMA
        • DROP INDEX
        • DROP FUNCTION
      • Data Manipulation Language (DML)
        • INSERT
        • UPDATE
        • DELETE
        • MERGE
        • TRUNCATE TABLE
      • Data Control Language (DCL)
        • GRANT
        • DENY
        • REVOKE
      • Transactions
      • USE
      • Statistics
      • XML SCHEMA COLLECTION
      • SET Statements
        • SET ANSI_NULLS
        • SET ANSI_PADDING
        • SET ARITHABORT
        • SET ARITHIGNORE
        • SET CONCAT_NULL_YIELDS_NULL
        • SET CONSTANT_FOLDING
        • SET CURSOR_CLOSE_ON_COMMIT
        • SET DATEFIRST
        • SET DATEFORMAT
        • SET DEADLOCK_PRIORITY
        • SET EXECUTE_SELECT_EXPRESSION_IN_MEMORY
        • SET EXTERNAL_FEDERATION
        • SET EXTRACT_VARIABLE
        • SET FMTONLY
        • SET FORCE_SPARK_ITERATIVE_COLLECTION
        • SET IMPLICIT_TRANSACTIONS
        • SET IN_MEMORY_FEDERATION
        • SET LANGUAGE
        • SET LOCK_TIMEOUT
        • SET NO_BROWSETABLE
        • SET NOCOUNT
        • SET NOEXEC
        • SET NUMERIC_ROUNDABORT
        • SET PARSEONLY
        • SET PREDICATE_PUSH_DOWN
        • SET QUERY_GOVERNOR_COST_LIMIT
        • SET QUOTED_IDENTIFIER
        • SET ROWCOUNT
        • SET SHOWPLAN_ALL
        • SET SHOWPLAN_TEXT
        • SET SHOWPLAN_XML
        • SET SINGLE_SOURCE_FEDERATION
        • SET STATISTICS IO
        • SET STATISTICS PROFILE
        • SET STATISTICS TIME
        • SET STATISTICS XML
        • SET TEXTSIZE
        • SET TRANSACTION ISOLATION LEVEL
    • User-defined functions
    • XML
  • Reference
    • Dynamic Management Views
      • sys.dm_exec_sessions
    • Error codes
      • Error 102
    • Errors and events
    • System functions
    • System information schema views
    • System stored procedures
      • Administrative
        • qua_flush_plan_cache
        • qua_process_expired_logs
        • qua_run_garbage_collection
        • qua_set_default_federator
      • Cache management
        • qua_create_view_copy
        • qua_evict_spark_inmem_cached_table
        • qua_full_load_cached_view_copy
        • qua_full_load_view_copy
        • qua_incremental_insert
        • qua_incremental_load_cached_view_copy
        • qua_invalidate_spark_cached_table
        • qua_populate_cached_table
        • qua_refresh_persistent_cache
        • qua_refresh_view
        • qua_set_incremental_marker
        • qua_set_incremental_marker_column
        • qua_set_reload_mode
        • qua_set_view_cache_mode
        • qua_set_view_copy_status
        • qua_switch_view_copy
        • qua_trim_view_copy
      • Connection management
        • sp_addlinkedserver
        • sp_addlinkedsrvlogin
        • sp_dropserver
        • sp_linkedservers
        • sp_testlinkedserver
        • sp_updatelinkedserver
      • Diagnostics
        • qua_help_jobs
        • qua_set_logging_level
      • Extended properties
        • sp_addextendedproperty
        • sp_dropextendedproperty
        • sp_updateextendedproperty
      • Job management
        • sp_add_job
        • sp_add_jobstep
        • sp_add_schedule
        • sp_attach_schedule
        • sp_delete_job
        • sp_delete_jobstep
        • sp_delete_schedule
        • sp_detach_schedule
        • sp_help_job
        • sp_help_jobstep
        • sp_start_job
        • sp_stop_job
        • sp_update_job
        • sp_update_jobstep
        • sp_update_schedule
      • Metadata management
        • qua_get_partitioning_schema
        • qua_set_partitioning_schema
        • sp_describe_first_result_set
        • sp_generate_views
        • sp_import_metadata
      • Query Store
        • sp_query_store_flush_db
      • Spark management
        • qua_spark_force_become_active
        • qua_spark_force_become_standby
        • qua_spark_instance_kill
        • qua_spark_instance_start
        • qua_spark_instance_stop
        • qua_spark_release
        • qua_spark_stop_driver
      • Utility
        • qua_analyze_table
        • qua_execute_provider_sql_on_connection
        • qua_generate_deep_refresh_job
        • qua_process_expired_logs
        • qua_update_object_statistics
        • qua_update_row_count_object_statistics
    • System tables
    • System views
      • sys.configurations
      • sys.time_zone_info
      • syscategories
      • sysjobhistory
      • sysjobs
      • sysjobschedules
      • sysschedules
      • sys.extended_properties
      • qua_data_api_instances
      • qua_dm_memory_object_pools
      • qua_functions
      • qua_materialized_views
      • qua_provider_tables
      • qua_recent_statements
    • XQuery
  • Knowledge base
    • Administration
      • How to create and use a new Spark database for the materialization
      • How to manually edit metabase deployed on SQLite
      • How to migrate Spark’s default database with metabase on Derby
      • How to manually re-sync HI-LO identifiers in metabase deployed on SQLite
    • Errors
      • Exception when executing a query that requires data push-down to SQL Server
  • Glossary

System tables

System tables#

previous

qua_update_row_count_object_statistics

next

System views

© Copyright 2026, YouNeedIT.