Quick links
Getting data into other tools
Advanced features
Advanced transformations
Datasource specific
Sidebar
database_caching
This is an old revision of the document!
Table of Contents
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.1627460126.txt.gz · Last modified: 2021/07/28 09:15 by windsor_ai
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
