User Tools

Site Tools


database_caching

Database for caching purposes

General Overview

If you have timeouts in your BI tool (Data Studio, Power BI), it makes sense to store the data into a database first. Reasons for this behaviour include that your data is growing or that you hit limits in how often you access the connectors.

By storing the data into a database first you cache the data from the connector to the

You can then directly stream the data in a CSV or JSON format to your BI tool.


Sample query to get data from Salesforce

http://charts.windsor.ai/r/6462?api_key=[Your API Key]

Sample connector query used

https://connectors.windsor.ai/facebook_organic?api_key=[your API key]&date_preset=last_30d&fields=date,page_impressions_unique,page_engaged_users,media_type,page_id,page_name

Google Data Studio JSON connector

Google Sheets function used

=IMPORTDATA("http://charts.windsor.ai/r/6462?api_key=[Your API Key]")
database_caching.txt · Last modified: 2021/07/28 09:16 by windsor_ai