SQL Variable

SQL Variables can be used to store data fetched from a database table rather than a MODLR cube.

Common Use Properties

• Query Property The SQL Query to be ran.

• Query Parameters Property Only use if the SQL query entered in the Query Property is paramaterized with ?

  Example: select * from financial_transactions where id = ?

  If so, then add as many items as there are ? parameters and enter the values accordingly (in order of ? appearance).

• Datasource Property The database to execute the query in.