Query

id: access_query
namespace: company.team

tasks:
  - id: create_table
    type: io.kestra.plugin.jdbc.access.Query
    url: jdbc:ucanaccess:///myfile.accdb
    outputDbFile: true
    sql: |
      CREATE TABLE IF NOT EXISTS products (
        product_id INTEGER,
        product_name TEXT,
        price DOUBLE,
        available BIT,
        created_date DATETIME
      )
    fetchType: NONE

  - id: select
    type: io.kestra.plugin.jdbc.access.Query
    url: jdbc:ucanaccess:///myfile.accdb
    accessFile: "{{ outputs.create_table.databaseUri }}"
    outputDbFile: true
    sql: SELECT * FROM products
    fetchType: FETCH