Awesome!
That worked.
Thanks

from cloudquery.

Glad you got it working! I am going to close this issue. If you run into any other problems feel free to open a new issue

from cloudquery.

@aitoehigie What version of the sqlite plugin are you using?

from cloudquery.

@bbernays v2.8.2 (The latest version)

from cloudquery.

Can you share some more information about the OS and or container you are running this in so we can troubleshoot the issue?

from cloudquery.

Linux Mint 21.1
Kernel 6.5.7-060507-generic x86_64 x86_64 x86_64 GNU/Linux
go version go1.21.5 linux/amd64

Running directly on host and not in a container.

from cloudquery.

OK! can you also share the config file you are using as well?

from cloudquery.

Stripe
kind: source

Common source-plugin configuration

spec:
name: stripe
path: cloudquery/stripe
registry: cloudquery
version: "v3.2.12"
tables: [""]
destinations: ["sqlite"]
skip_tables:
- stripe_issuing # Needs sign-up at https://stripe.com/issuing
- stripe_treasury* # Needs sign-up at https://stripe.com/treasury
- stripe_sigma_scheduled_query_runs # Live keys only
backend_options:
table_name: "cq_state_stripe"
connection: "@@plugins.sqlite.connection"

Stripe specific configuration

spec:
# required
api_key: "${STRIPE_API_KEY}"

Sqlite
kind: destination
spec:
name: sqlite
path: cloudquery/sqlite
registry: cloudquery
version: "v2.8.0"
spec:
connection_string: ./db.sql

from cloudquery.

@aitoehigie - We had an issue earlier today where v2.8.0 of the sqlite plugin was being compiled without cgo enabled. Which is the error you were seeing. If you upgrade to v2.8.2 you should have no issues

from cloudquery.

I had the understanding that installing the latest cloudquery installed the latest plugins?
If this assumption is incorrect, how do I upgrade the sqlite plugin to the latest version?

from cloudquery.

@bbernays
cloudquery -v
cloudquery version 5.15.2
which comes with cloudquery/[email protected] not v2.8.2

Excuse my many questions, I just started using Cloudquery today.

from cloudquery.

Welcome to CloudQuery sorry you had issues on your first day, but I am glad we can get them sorted out! In your spec files there is a version of each plugin you are using.
For stripe:

version: "v3.2.12"

For sqlite:

version: "v2.8.0"

The CLI is versioned separately from all of the other plugins to enable better interoperability

Here is a config using the newest sqlite version:

kind: source
spec:
  name: stripe
  path: cloudquery/stripe
  registry: cloudquery
  version: "v3.2.12"
  tables: ["*"]
  destinations: ["sqlite"]
  skip_tables:
    - stripe_issuing*  # Needs sign-up at https://stripe.com/issuing
    - stripe_treasury* # Needs sign-up at https://stripe.com/treasury
    - stripe_sigma_scheduled_query_runs # Live keys only
  backend_options:
    table_name: "cq_state_stripe"
    connection: "@@plugins.sqlite.connection"
  # Stripe specific configuration
  spec:
    # required
    api_key: "${STRIPE_API_KEY}"
---
kind: destination
spec:
  name: sqlite
  path: cloudquery/sqlite
  registry: cloudquery
  version: "v2.8.2"
  spec:
    connection_string: ./db.sql

from cloudquery.