...

• Point directly to the provided views

• Use custom queries

Use provided ready-to-use data views directly

This would be the option you probably use in the most cases. We provide several ready-to-use data views in the public dataset i19s-insights:insights where facts are already joined with the dimension data and can be used directly in your reports. If you decide to do something more (i.E. combining of the data from different views in one source) check out the section Use custom query of this document.

...

Most of views are partitioned by date and require filter by a date column. You have to use data range according to the partitioning key in your report.

Use custom query (advanced)

In the article https://ingenioustechnologies.atlassian.net/l/c/rda0qBTW you have learned how to create a custom query. Now we will show how to use this custom query to create a data source in the Google Data Studio.

Parametrize the Custom Query

Google Data Studio supports the concept of parametrized custom queries. Parametrized queries have the advantage that they are more efficient than general queries, since only the data that is really necessary is queried. In an SQL query, placeholders are set which are then filled with values at runtime. A parameter could be a date field, for example. If the user changes a date filter in a report, the correct values are inserted into the query when the query is run.

...