Connect SQL views to GraphQL
We built GraphQL APIs that made data from SQL views available for Power BI reporting. This connected the existing database views to the reporting workflow.
NextEra Energy · Data engineering
Faster SQL data access for Power BI reporting
Spadasoft built GraphQL APIs with AWS Lambda functions and cache management to make data from large SQL datasets available to Power BI. The work focused on reducing query time in a reporting workflow built on SQL views.
Reporting workflow- 01
SQL views
Data from large SQL datasets
- 02
GraphQL APIs
AWS Lambda functions + cache management
- 03
Power BI
Data for reporting
01 / The challenge
Make large SQL datasets faster to query
NextEra Energy needed to use data from SQL views in Power BI. Query time was the problem to solve: the reporting workflow needed a faster way to retrieve and process that data.
02 / What we built
A faster path from SQL views to reporting
Process data with AWS Lambda
AWS Lambda functions formed part of the backend, processing data from the SQL views for use through the GraphQL APIs.
Manage cached data
We implemented cache management as part of the data retrieval workflow, with the aim of reducing query time when working with large SQL datasets.
Technology
- GraphQL
- AWS Lambda
- SQL views
- Cache management
- Microsoft Power BI
03 / The outcome
Less time waiting on queries
The GraphQL APIs, Lambda functions, and cache management reduced query time for NextEra Energy’s reporting workflow. Power BI could use the data exposed through those APIs, connecting large SQL datasets to the reports that needed them.
Need faster access to your reporting data?
Tell us where your reporting workflow slows down. In a free 20-minute call, we’ll help you decide what to improve first and what can wait.
Request a free 20-minute callExplore more success stories