kestra-io / plugin-cloudquery

Apache License 2.0
0 stars 1 forks source link

SQLite cloudquery plugin does not work #3

Open moadibfr opened 1 year ago

moadibfr commented 1 year ago

Expected Behavior

The plugin will fail with an error saying the sqlite plugin is not found.

Actual Behaviour

No response

Steps To Reproduce

No response

Environment Information

Example flow

❯ cat aws.yml spec: path: cloudquery/aws tables:

moadibfr commented 1 year ago

cloudquery bug report submitted here: https://github.com/cloudquery/cloudquery/issues/14465

aitoehigie commented 7 months ago

Is this issue related to this error while trying to use sqlite destination plugin? Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub

Ben8t commented 2 months ago

https://github.com/cloudquery/cloudquery/issues/14465 is fixed

@moadibfr are you still facing the issue ?

the-raja commented 1 month ago

Here is the possible solution that might work.

  1. Ensure the Plugins are Installed Correctly cloudquery plugins list

  2. If the sqlite plugin isn’t listed, install it cloudquery plugins install cloudquery/sqlite

  3. Check if the aws plugin is installed cloudquery plugins install cloudquery/aws

  4. Verify YAML Configuration

  5. aws.yml

spec:
  path: cloudquery/aws

  tables:

    - aws_cloudtrail_events
    - 
  destinations:

    - sqlite
  name: aws

  version: v22.13.2

  spec:

    custom_endpoint_url: http://127.0.0.1:32835

    custom_endpoint_hostname_immutable: "true"

    max_retries: 0

    custom_endpoint_partition_id: aws

    custom_endpoint_signing_region: us-east-1

  kind: source
  1. sqlite.yml
spec:

  version: v2.3.0

  name: sqlite

  spec:

  connection_string: ./db.sqlite

  path: cloudquery/sqlite

  kind: destination