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

Tables

Tables#

This chapter covers creating and managing tables in a virtual database.

Task	Description
Adding tables	Create a table in a virtual database.
Managing tables	Edit or remove an existing table.

previous

Managing the database

next

Adding tables

© Copyright 2026, YouNeedIT.