User guide

The User’s guide describes all regular activities performed by Querona users.

Please navigate to a subsection of your interest.

• 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
  • Configure the client to use Strict connection encryption
• Connections
• Databases overview
  • Create a virtual database
  • Managing the database
• Schemas
  • Add schema
  • Edit schema
  • Delete schema
  • Tables & views
  • Access rights
  • Tags
• Tables
  • Adding tables
  • Managing tables
• Primary and Foreign Keys
  • Primary Keys
  • Foreign Keys
  • Removing Columns with Constraints
• Views
  • Adding a view
  • Union view
  • Join view
  • Managing views
• Materialization
  • Basic usage
  • Materialization strategies
  • Partitioning
  • Advanced configuration
• Search
  • Search bar
  • Results
  • Filters
  • Results
• Tags
  • Assign a tag
  • Tag details
  • Remove a tag
• Management Tasks
  • Refresh statistics
  • Evict from Spark in-memory cache
  • Rebuild persistent cache
  • Refresh row count statistics
• Indexes
  • Managing indexes
• Query editor
  • Databases
  • Query editor
  • Results
• Data masking
• Overview of Query Retargeting
  • Objectives of Query Retargeting
  • How Query Retargeting works
  • Query retargeting in action
• Bulk operations
  • Bulk delete
  • Management tasks
  • Caching
  • Tags
• How-to guides
  • How-to connect to text data using Microsoft ODBC