Can I connect Amazon DynamoDB to iDBQuery?
Not as a native connection — iDBQuery is built for SQL and relational data, and DynamoDB is a key-value/document NoSQL store. To analyse DynamoDB data, export a table to S3 or CSV, or read it through an API, and iDBQuery will query that in plain language with cited answers.
iDBQuery natively connects to SQL databases, spreadsheets, files, documents, REST APIs, and SQL data warehouses. Amazon DynamoDB is a NoSQL key-value and document store designed for high-scale transactional access, not analytical SQL — so it isn't a native connection, but there are clean, honest ways to analyse its data with iDBQuery.
Common approaches:
- Export to S3/CSV — DynamoDB can export a table to Amazon S3 (or you can dump it to CSV/Parquet). Point iDBQuery at those files and it will ingest and query them.
- Read through an API — if a service exposes DynamoDB data as JSON over REST, connect iDBQuery to that API as a source.
Once the data is in iDBQuery's model, you get plain-language questions, generated SQL, charts, dashboards, and cited answers that trace every figure back to its source.
The real payoff is combining it: join your DynamoDB exports with a relational database or a spreadsheet in one live model, so you can answer questions that span your operational NoSQL data and your business systems together — something DynamoDB alone can't do with ad-hoc analytics.
If DynamoDB is a primary reporting source, many teams already stream it into S3 or a warehouse; iDBQuery connects to that landing zone directly and you get live, cited analytics over it.
Updated 2026-06-22