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

Language Elements

Language Elements#

This chapter presents detailed descriptions of the SQL language elements.

Control-of-flow
Expressions
Identifiers
Keywords
Literals
Operators
Variables

previous

Remove Square Brackets from JSON with the WITHOUT_ARRAY_WRAPPER Option

next

Control-of-flow

© Copyright 2026, YouNeedIT.