SingleStore DB

Configuring Components and Running the Job
  1. Add the MemSQLTableNameInput to the workspace and double click it.

  2. Fill in the required details under the Component tab.

    16083b5776bf1f.png
  3. Check and verify that the connection is successful.

  4. Click on the tableName and in the pop up, select the required table from the list of tables available in the database. Click OK.

  5. Click on Guess Schema, verify the inputs in the schema pop up, and click OK.

  6. Add the MemSQLQueryInput to the workspace and double click it.

  7. Fill in the required details under the Component tab.

    16083b5777432f.png
  8. Check verify that the connection is successful.

  9. In the Query box, enter the Select query for the tables to be imported.

  10. Click on Guess Schema, verify the inputs in the schema pop up, and click OK.

  11. In the workspace area, right click on the MemSQLQueryInput component, select Row->Main, and connect it with the MemSQLOutput component.

  12. Double click on MemSQLOutput and provide the details in the Component tab as shown.

    16083b5777ba1c.png
  13. Click on the tableName box, select the table name where the data is to be inserted. For a new table, click Custom and provide the name of the new table. Click OK.

  14. In Action, check the action that is to be performed on the target table.

  15. Check the box Create table if not exists if the target table is not created.

  16. Click on the Sync columns.

  17. Go to the Run Job Tab and Click on Run.

  18. After the Job is completed, verify the data loaded in the database table from the MemSQL prompt. This can also be verified on the Talend Job window.