ExecuteSqlDateTime

Description

Execute a SQL query that returns a scalar datetime value. If the query returns a dataset, the value of the first column in the first row is returned.

MySQL, PostgreSQL, Microsoft SQL Server and Amazon Redshift connections:

Syntax

ExecuteSqlDateTime(connection_id, sql_query[, param1] [,…paramN])

Arguments

  connection_id (string) - The unique identifier of the connection to use to execute the query. You can find it in the connection's page. 

  sql_query  - String expression that evaluates to a query that returns a scalar value.

  param11 ... paramN - optional parameters to pass to the query. Use ? as placeholder in the query.

Google BigQuery connections:

Syntax

ExecuteSqlDateTime(connection_id, sql_query[, configuration_json])

Arguments

  connection_id (string) - The unique identifier of the connection to use to execute the query. You can find it in the connection's page. 

  sql_query  - String expression that evaluates to a query that returns a scalar value.

  configuration_json - optional string:


{
  "useQueryCache" : boolean
 ,"useLegacySql" : boolean
}
  • useQueryCache (optional) - boolean expression. Specifies whether to look for the result in the query cache (default value is true).
  • useLegacySql (optional) - boolean expression. Specifies whether to use BigQuery's legacy SQL dialect for the query (default value is false).

Examples

ExecuteSqlDateTime('mysql_55','SELECT MAX(updated_at) FROM events')

ExecuteSqlDateTime('mysql_55','SELECT birthdate FROM customers WHERE id = ?',user_id)

ExecuteSqlDateTime('bq_58', 'SELECT MAX(updated_at) FROM events','{"useQueryCache" : false}')

Notes

This function only executes in job runtime. When validating a package with variables that use the function or in X-console, the function returns null.

Return value datatype

DateTime

Impact of null value

If the connection_id or sql_query are null, null is returned.