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
    • System components
    • Requirements and compatibility
    • Installation prerequisites
    • Installation procedure
    • Installation troubleshooting
    • Post-installation configuration
    • 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
      • Configuration parameters
      • Logging configuration
    • Instance configuration
    • Configure the server to force encrypted connections
    • Monitoring
      • Statement history
      • Active statements
      • Client connections
      • Execution plan cache
      • Running jobs
      • Alerts
      • Audit logs
      • Debug logs
      • General logs
    • Job and Schedule management
    • Spark connection and management
    • SQL Dialects
    • Tags
    • Users and roles
    • Querona-specific views
      • qua_functions
      • qua_materialized_views
      • qua_provider_tables
      • qua_recent_statements
    • Low-level logging
  • 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

Views

Views#

This chapter describes how to create and manage views.

  • Adding a view
    • View name and type
    • Custom SQL
  • Union view
    • Choosing the JOIN object
    • Working with the editor
  • Join view
    • Choosing the JOIN object
    • JOIN editor
    • Object editor
    • View SQL
    • Columns
  • Managing views
    • Summary
    • Preview data
    • Columns
    • Union view
    • Join view
    • Dependency graph
    • Dependent views
    • Primary and Foreign keys
    • Access rights
    • Statistics
    • Materialization
    • Management tasks
    • Tags

previous

Primary and Foreign Keys

next

Adding a view

© Copyright 2015-2023, YouNeedIT.