Data Source Configuration Properties¶

The configuration properties of a JDBC or an ODBC data source, also called source configuration, specify certain characteristics of the underlying source such as the operations they support.

The Execution Engine uses this information to know which operations are supported by the source, in order to push down to the data source as much processing as possible to optimize response times and minimize traffic through the network.

Note

Usually, users do not need to change these settings since Virtual DataPort automatically uses suitable configurations for most common data sources.

You can define them in the “Source configuration” tab of the data source or by adding them to the statement CREATE DATASOURCE.

The table below lists the properties you can configure in the SOURCECONFIGURATION clause of the data sources. On the left column, you have the name of each property; on the right column, the label of this property in the administration tool, in the tab “Source configuration” of the data source. To find the meaning of a property, go to the section Data Source Configuration Properties of the Administration Guide.

Properties of the SOURCECONFIGURATION clause of data sources¶
Property Name in SOURCECONFIGURATION Clause	Property Name in the Administration Tool (Source configuration tab)
ALLOWFORUPDATE	Allow for UPDATE clause
ALLOWLITERALASPARAMETER	Allow literal as parameter
DELEGATEAGGREGATEFUNCTIONS	Delegate aggregate functions list
DELEGATEALLOPERATORS	Delegate all operators
DELEGATEANALYTICFUNCTIONSLIST	Delegate analytic functions list
DELEGATEARRAYLITERAL	Delegate array literal
DELEGATE_BINARY_ORDERBY_COLLATION	Delegate binary ORDER BY collation
DELEGATECOMPOUNDFIELDPROJECTION	Delegate compound field projection
DELEGATEFETCH	Delegate FETCH clause
DELEGATEGROUPBY	Delegate GROUP BY clause
DELEGATEHAVING	Delegate HAVING clause
DELEGATEINNERJOIN	Delegate INNER JOIN
DELEGATEINTERSECTION	Delegate INTERSECT
DELEGATEINVALIDNUMBERLITERALSASNULL	Delegate invalid number literals as NULL
DELEGATEJOIN	Delegate JOIN
DELEGATELEFTFUNCTION	Delegate left function
DELEGATELEFTLITERAL	Delegate left literal
DELEGATELITERALEXPRESSION	Delegate literal expression
DELEGATEMINUS	Delegate MINUS
DELEGATEMIXEDAGGREGATEEXPRESSION	Delegate mixed literal expression
DELEGATENATURALOUTERJOIN	Delegate natural OUTER JOIN
DELEGATENOTCONDITION	Delegate NOT condition
DELEGATEOFFSET	Delegate OFFSET clause
DELEGATE_OFFSET_RESTRICTION	Delegate OFFSET clause restriction
DELEGATEOPERATORSLIST	Delegate operators list
DELEGATEORCONDITION	Delegate OR condition
DELEGATEORDERBY	Delegate ORDER BY
DELEGATE_ORDERBY_COLLATION_MODIFIER	Delegate ORDER BY collation modifier
DELEGATEPROJECTION	Delegate projection
DELEGATEREGISTERLITERAL	Delegate register literal
DELEGATERIGHTFIELD	Delegate right field
DELEGATERIGHTFUNCTION	Delegate right function
DELEGATERIGHTLITERAL	Delegate right literal
DELEGATESCALARFUNCTIONS	Delegate scalar functions list
DELEGATESELECTDISTINCT	Delegate SELECT DISTINCT
DELEGATESELECTION	Delegate selection
DELEGATESUBQUERY	Delegate subquery
DELEGATEUNION	Delegate UNION
DELEGATEWHERESUBQUERY	Delegate WHERE subquery
NESTEDJOINWITHBLOCKSSTRATEGY	Nested join optimization syntax
SUPPORTSAGGREGATEFUNCTIONSOPTIONS	Supports modifier in aggregate function
SUPPORTSBATCHINSERT	Supports batch inserts
SUPPORTSBRANCHOUTERJOIN	Supports branch OUTER JOIN
SUPPORTSCLOBINBATCH	Supports CLOBs in batch inserts
SUPPORTSEQOUTERJOINOPERATOR	Supports Eq OUTER JOIN
SUPPORTSEXPLICITCROSSJOIN	Supports explicit CROSS JOIN
SUPPORTSFULLEQOUTERJOIN	Supports full Eq OUTER JOIN
SUPPORTSFULLNOTEQOUTERJOIN	Supports full NotEq OUTER JOIN
SUPPORTSFUSINGINUSINGANDNATURALJOIN	Supports fusing in USING and natural JOIN
SUPPORTSGROUPBYLITERALASPARAMETER	Supports GROUP BY literals as parameters
SUPPORTSJOINONCONDITION	Supports JOIN ON Condition
SUPPORTSNATURALJOIN	Supports NATURAL JOIN
SUPPORTS_ORDERBY_BINARY_COLLATION	Supports binary ORDER BY collation
SUPPORTSORDERBYEXPRESSION	Supports ORDER BY expressions
SUPPORTSRIGHTDEEPJOIN	Supports right deep n-joins
SUPPORTSPREPAREDSTATEMENT	Supports prepared statements
SUPPORTSUSINGJOIN	Supports USING JOIN

Example: command to change the “source configuration” of a JDBC data source¶

ALTER DATASOURCE JDBC ds_jdbc_athena_prod
SOURCECONFIGURATION (
      SUPPORTSORDERBYEXPRESSION = false
    , DELEGATENATURALOUTERJOIN = false);

USER MANUALS

Data Source Configuration Properties¶