11 lines
781 B
Markdown
11 lines
781 B
Markdown
To make handling the dashboard easier its good practice to create views that make the underlying data more accessible. Since data does not get updated that frequently we can also use materialized views to speed up query performance at the cost of storage.
|
|
|
|
## Schemas
|
|
|
|
public: Contains the data from the meta_api_grabber application. All ad accounts.
|
|
|
|
meta: Contains data from airbyte meta api connector. Unfortunatly somewhat bugged for insights on campaign and adset level. Aggregating data from the ads level is possible but much more cumbersome and error prone then querying the stuff directly. Thats why for now I'm continuing to use the meta_api_grabber
|
|
|
|
google: Will contain the data from google from the airbyte connector assuming we get access and the connector is good.
|
|
|