Queries

id: send_multiple_queries
namespace: test.queries
tasks:
  - id: test_queries_insert
    type: io.kestra.plugin.jdbc.mariadb.Queries
    fetchType: FETCH
    url: jdbc:mariadb://mariadb:3306/kestra
    username: "${{secret('MARIADB_USERNAME')}}"
    password: "${{secret('MARIADB_PASSWORD')}}"
    sql: "{{ read('populate.sql') }}"

  - id: test_queries_select
    type: io.kestra.plugin.jdbc.mariadb.Queries
    fetchType: FETCH
    url: jdbc:mariadb://mariadb:3306/kestra
    username: root
    password: mariadb_passwd
    sql: |
      SELECT firstName, lastName FROM employee;
      SELECT brand FROM laptop;