You are viewing content for 5.0 | 4.9 | 4.8 | 4.7 | 4.6 | 4.5 | 4.4 | 4.3 | Previous Releases


Concepts → Query System Variable

About Query System Variables

Query system variables reference information to be used in a query. You use a query system variable when building a query connecting to a data source. Query system variables are available to all users that can conduct queries from data sources.

You can use query system variables to specify a window of time for incremental table loads, from a SQL data source. You can use these variables in the WHERE clause of a SQL query. Query system variables support both Query and Update Query configurations.

Available Query System Variables

Following are the available query system variables within Incorta:

Variable Data Type Description Example
$$jobextractstart_time timestamp Dynamically evaluates to the start time of the query execution. 10/3/20, 5:12:14 PM
$$jobextractreference_time timestamp Dynamically evaluates to the last successful extract time. This 9/15/20, 8:25:12 AM


Example of Query System Variables

The following example shows how you would use query system variables in the edit query panel of a connector:

SELECT
	`ID`,
	`NAME`,
	`OWNDERID`,
	`LOCATION`,
	`CREATIONDATE`,
	`MODIFIERDATE`,
	`MODIFICATIONDATE`,
	`DESCRIPTION`,
	`PARENT`,
	`TYPE`
FROM
	`incorta`, `DATAFILE`
WHERE
	`CREATIONDATE` > $$job_extract_reference_time
	AND
	`CREATIONDATE` < $$job_extract_start_time

© Incorta, Inc. All Rights Reserved.