Skip to main content

Ctrl+K

Get started

Quickstart
Querona for SQL Server users
Querona for analysts and self-service
Installation
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
How-to guides
- How-to connect to text data using Microsoft ODBC

Serve and query data

Client Connectivity
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
Service Management
- Start, Stop, and Restart services
Managing Apache Spark
Jobs and Schedules
Monitoring
Logging & diagnostics
SQL Dialects
Manage tags

Reference

Transact-SQL reference
Reference
Knowledge base
- Administration
- Errors
  - Exception when executing a query that requires data push-down to SQL Server
Glossary

Query Store

Query Store#

Stored procedures for managing the Query Store.

Stored procedure name	Description
sp_query_store_flush_db	Flushes the in-memory portion of the Query Store data to disk.

previous

sp_import_metadata

next

sp_query_store_flush_db

© Copyright 2026, YouNeedIT.