User Tools

Site Tools


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[Your API Key]

Sample connector query used[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

database_caching.txt · Last modified: 2021/07/28 09:16 by windsor_ai