Methods of running load queries

You can use these methods to run load queries.
  • Use the Load button on the Load Queries tab. When you run a load query manually, you can add missing columns to a table as well as load data.
  • Use a non-SQL script. For example: 
    --<<NON-SQL>> 

ExecuteLoadQuery(string tableName, string queryName, bool clearData);
  • Use anApplication Engine process with the function ModelingExecuteTableDataLoadQuery For example: 
    void ModelingExecuteTableDataLoadQuery(string applicationName, string tableName, string queryName, bool clearData)
  • Use API Gateway or ION API. For example: 
    void ModelingExecuteTableDataLoadQuery(string applicationName, string tableName, string queryName, bool clearData)