search

kestra-io / plugin-jdbc

https://kestra.io/plugins/
Apache License 2.0
11 stars 11 forks source link

Can't query using MotherDuck connection #395

Open Ben8t opened 6 days ago

Ben8t commented 6 days ago

Expected Behavior

Following the documentation and blueprint, the MotherDuck doesn't seem to work anymore.

image

access to MotherDuck https://app.motherduck.com/

id: myflow
namespace: company.team

tasks:
  - id: query
    type: io.kestra.plugin.jdbc.duckdb.Query
    url: "jdbc:duckdb:md:test?motherduck_token=<TOKEN>"
    sql: |
      SELECT by, COUNT(*) as nr_comments 
      FROM sample_data.hn.hacker_news
      GROUP BY by
      ORDER BY nr_comments DESC;
    store: true

Actual Behaviour

No response

Steps To Reproduce

No response

Environment Information

Example flow

No response

loicmathieu commented 5 days ago

This is caused by https://github.com/kestra-io/plugin-jdbc/issues/165

Ben8t commented 5 days ago

Oh right... again... I raised again there to hopefully get an update