logo

Product documentation

  • Quickstart
    • Getting started
    • Connect to a data source
    • Integrate the data
    • Next steps
  • Concepts
    • Overview of Data Virtualization
    • Technology and Features
    • Virtual tables and views
    • Data Security
  • Installation guide
    • Components
    • Requirements and compatibility
    • Installation prerequisites
    • Installation procedure
    • Installation troubleshooting
    • Configuration Settings and Security
    • How to upgrade Querona
    • Installation of SQL Server Engine
    • Installing Querona driver on Cloudera
  • Data sources
    • Accounting
      • Blackbaud FE NXT
      • Exact Online
      • FreshBooks Accounting
      • Microsoft Dynamics GP
      • QuickBooks Desktop
      • QuickBooks Online
      • QuickBooks POS
      • Reckon
      • SAGE Intacct
      • SAGE 50 UK
      • Xero Accounting
    • Collaboration
      • Alfresco
      • Amazon Marketplace
      • AWS Data Management
      • Basecamp
      • BOX
      • BugZilla
      • DigitalOcean
      • DropBox
      • Email
      • EverNote
      • FTP
      • GMail
      • Google Calendar
      • Google Contacts
      • Google Directory
      • Google Sheets
      • JIRA
      • Kintone
      • Microsoft Azure Data Management
      • Microsoft Azure DevOps
      • Microsoft Exchange
      • Microsoft Office365
      • Microsoft SharePoint
      • SalesForce Chatter
      • ServiceNow
      • Slack
      • SmartSheet
      • Splunk
      • SurveyMonkey
      • Veeva Vault
      • WordPress
      • Zendesk
    • CRM and Marketing
      • ACT! CRM
      • Act-On
      • Adobe Analytics
      • Google Ad Manager (DoubleClick For Publishers)
      • Google Ads (AdWords)
      • Google Analytics
      • Google Campaign Manager (DoubleClick CM)
      • HighRise CRM
      • HubSpot
      • Magento
      • MailChimp
      • Marketo
      • Microsoft Bing Ads
      • Microsoft Dynamics CRM
      • Microsoft Dynamics CRM
      • Microsoft Dynamics365 Sales
      • Oracle Marketing Cloud (Eloqua)
      • Oracle Sales Cloud
      • SalesForce & Force.com
      • Salesforce Marketing Cloud
      • SendGrid
      • Sugar CRM
      • Suite CRM
      • Twilio
      • Veeva CRM
      • YouTube
      • YouTube Analytics
      • Zoho CRM
    • Data services and Files
      • CSV/TSV, PDF, MSG, Text
      • Microsoft Excel
      • Google Drive
      • JSON
      • LDAP Directory Services
      • Microsoft Excel
      • Microsoft Excel Online
      • Microsoft SharePoint Excel Services
      • OData Services
      • REST
      • RSS
      • SFTP
      • XML
    • Relational Databases, NoSql, and BigData
      • Actian Matrix
      • Actian Vector
      • Amazon Athena
      • Amazon Aurora
      • Amazon DynamoDb
      • Amazon Redshift
      • Apache Cassandra
      • Apache Drill
      • Apache HBase
      • Apache HIVE
      • Apache Kafka
      • Apache Spark
      • Aster Database
      • ClickHouse
      • Cloudera
      • Couchbase
      • DataStax
      • dBase
      • Denodo
      • ElasticSearch
      • Exasol
      • Firebird
      • Google BigQuery
      • Google Cloud SQL for MySQL
      • Google Spanner
      • Hortonworks Data Platform
      • HPCC
      • IBM Cloud SQL Query
      • IBM Cloudant
      • IBM DB2
      • MariaDb
      • MarkLogic
      • Microsoft Access
      • Microsoft Azure CosmosDb
      • Microsoft Azure HDInsight
      • Azure Database for MySQL
      • Microsoft Azure Table Storage
      • Microsoft SQL Analysis Services
      • Microsoft SQL Server
      • MongoDb
      • MySql
      • Oracle
      • Percona Server
      • Pervasive SQL (Btrieve)
      • Pivotal GreenPlum
      • PostgreSQL
      • REDIS
      • SAP HANA
      • Snowflake
      • Sybase
      • Teradata
      • Vertica
      • XBase
    • ERP
      • Acumatica ERP
      • Epicor ERP
      • NetSuite CRM & ERP
      • Odoo ERP
      • SAP Business One
      • SAP ERP
    • Financial and E-Commerce
      • Authorize.Net
      • EBay
      • E*Trade
      • FedEx
      • Microsoft Dynamics NAV
      • Microsoft Dynamics365 Business Central
      • Microsoft Dynamics365 Finance and Operations
      • OFX
      • Open Exchange Rates
      • PayPal
      • Quandl
      • SAP Concur
      • SAP Hybris C4C
      • SAS
      • Shopify
      • Square
      • Stripe
      • UPS
    • Generic data interfaces
      • ADO.Net
      • JDBC
      • ODBC
      • OLE-DB
    • Miscellaneous
      • Amazon S3
      • Datarobot
      • Google Search
      • Microsoft Active Directory
      • Microsoft Bing Search
      • Microsoft Project
      • SalesForce Einstein Analytics
      • Wasabi Object Storage
    • Social networks
      • Facebook
      • Instagram
      • LinkedIn
      • Twitter
  • User guide
    • 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
    • Connections
      • Create a connection
      • Managing connections
    • Databases overview
      • Create a virtual database
      • Managing the database
    • Schemas
    • Tables
      • Adding tables
      • Managing tables
    • Primary and Foreign Keys
    • Views
      • Adding a view
      • Managing views
    • Materialization
    • Search
    • Tags
    • Management Tasks
    • Indexes
    • Query editor
    • Data masking
    • Overview of Query Retargeting
    • Bulk operations
    • How-to guides
      • How-to connect to text data using Microsoft ODBC
  • SQL Guide
    • Data types
      • Date and time data types
      • Numeric data types
      • Other data types
      • String data types
    • 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
      • Date and time
        • CONVERT_TZ
        • DATEADD
        • DATEDIFF
        • DATEFROMPARTS
        • DATENAME
        • DATEPART
        • DATETIME2FROMPARTS
        • DATETIMEFROMPARTS
        • DAY
        • EOMONTH
        • GETDATE
        • GETUTCDATE
        • ISDATE
        • MONTH
        • SMALLDATETIMEFROMPARTS
        • SYSDATETIME
        • SYSUTCDATETIME
        • TIMEFROMPARTS
        • YEAR
      • Expression
        • COALESCE
        • IIF
        • ISNULL
        • NULLIF
      • 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
      • 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
    • Language Elements
      • Expressions
      • Identifiers
      • Keywords
      • Literals
      • Operators
    • Queries
      • SELECT
        • SELECT statement
        • SELECT Clause
        • SELECT Examples
        • SELECT - GROUP BY
        • SELECT - HAVING
        • SELECT - ORDER BY
        • SELECT - OVER
      • FROM
      • WHERE
      • Hints
      • OPTION clause
      • Predicates
      • TOP
    • Statements
      • DDL
        • CREATE DATABASE
        • CREATE INDEX
        • CREATE ROLE
        • CREATE SCHEMA
        • DROP DATABASE
        • DROP INDEX
        • DROP SCHEMA
      • SET Statements
        • SET ANSI_NULLS
        • SET ANSI_PADDING
        • SET ARITHABORT
        • SET ARITHIGNORE
        • SET CONCAT_NULL_YIELDS_NULL
        • SET CURSOR_CLOSE_ON_COMMIT
        • SET DATEFIRST
        • SET DATEFORMAT
        • SET DEADLOCK_PRIORITY
        • SET FMTONLY
        • SET IMPLICIT_TRANSACTIONS
        • SET LANGUAGE
        • SET LOCK_TIMEOUT
        • SET NOCOUNT
        • SET NOEXEC
        • SET NUMERIC_ROUNDABORT
        • SET PARSEONLY
        • SET QUERY_GOVERNOR_COST_LIMIT
        • SET QUOTED_IDENTIFIER
        • SET ROWCOUNT
        • SET SHOWPLAN_ALL
        • SET SHOWPLAN_TEXT
        • SET SHOWPLAN_XML
        • SET STATISTICS IO
        • SET STATISTICS PROFILE
        • SET STATISTICS TIME
        • SET STATISTICS XML
        • SET TEXTSIZE
        • SET TRANSACTION ISOLATION LEVEL
    • Stored procedures
      • qua_flush_plan_cache
      • qua_run_garbage_collection
      • qua_set_default_federator
      • 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
      • qua_get_oauth_access_token_d365
      • qua_get_oauth_authorization_url_d365
      • sp_addlinkedserver
      • sp_addlinkedsrvlogin
      • sp_dropserver
      • sp_linkedservers
      • sp_testlinkedserver
      • sp_updatelinkedserver
      • qua_help_jobs
      • qua_set_logging_level
      • 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
      • qua_analyze_table
      • qua_execute_provider_sql_on_connection
      • qua_generate_deep_refresh_job
      • qua_update_object_statistics
      • qua_update_row_count_object_statistics
      • qua_get_partitioning_schema
      • qua_set_partitioning_schema
      • sp_describe_first_result_set
      • sp_generate_views
      • sp_import_metadata
      • 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
    • Views
      • sys.configurations
      • sys.time_zone_info
      • syscategories
      • sysjobhistory
      • sysjobs
      • sysschedules
  • Administration Guide
    • Access rights
    • Engine configuration options
    • Monitoring overview
      • Statement history
      • Active statements
      • Client connections
      • Execution plan cache
      • Running jobs
      • Alerts
    • Job and Schedule management
    • Spark connection and management
    • Spark default database migration guide
    • SQL Dialects
    • Tags
    • Users and roles
    • Querona-specific views
      • qua_functions
      • qua_materialized_views
      • qua_provider_tables
      • qua_recent_statements
    • Logging overview
  • 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
Contents
  • Search bar
  • Results
  • Filters
  • Results

Search

Contents

  • Search bar
  • Results
  • Filters
  • Results

Search#

Search screen allows users to find an object by filtering the list of objects by name, tags, types and statistics.

Search screen can be accessed by selecting SEARCH from the main menu.

Search screen

Search bar#

Input field on the top of the screen that lets the user enter a phrase to be searched for.

Note

Tables in the specific schema can be found by typing schema name and table name.

Search bar

The range of result can be changed with two check boxes:

  • Include children - will also include children objects of matching results. For example, when schema dbo will be matched to a phrase, its tables and columns will also be matched

  • Include parents - will also include parent objects of matching results. For example, when table will be matched to a phrase, its schema and database will also be matched

Results#

The central position of search screen is occupied by results list. Each result contains icon representing its type, full name, comment and, in the right corner, tagss that are assigned to object.

Clicking on result name will open a panel with detailed information about selected objects.

Search results

Above the results, there is a summary with a number of objects that meet the search criteria. Also, this is a place where are displayed tags which were selected from filters side menu.

Below results are buttons that allow navigating on the result list if there are more results than can be displayed on a single page. A number of results on a single page can be controlled by “Results per page” combo box. Available options are 10, 25 and 50 results per page.

Filters#

Results can be filtered by:

  • Specific tag

  • Object type

  • Statistics

It’s possible to select several filters at the same time. For example, it’s possible to show only tables that contain specific tags and have a number of rows between 10 000 and 100 000.

Search results

A number of objects that meet specific filter’s condition is displayed in round brackets next to the filter’s name. If there are no objects that meet the filter’s condition, then this filter becomes grayed out (or if it is a tag is not displayed) and cannot be turned on.

Results#

Clicking on any result will bring new panel with its details. Kind of information in this panel varies by type of object.

Result details

previous

Materialization

next

Tags

© Copyright 2015-2022, YouNeedIT.