I’m already using the view AdInsight by AdAccount using the following statement.
create or replace table myAdInsights@inmemorystorage as select t.* from myadaccounts act join AdInsightsByAdAccount(act.id) t select /*+ ods(true) */ * from myAdInsights@inmemorystorage
Now I would like to use the same view but only by Ad. I know I need to use the parameter “ad_id”
Can someone help me with this?