Looker action using pub sub trigger , for triggering the cloud funtion through pub sub to update BQ

[SachinS]

There will be table look present in the dashboard and currently I am using looker data action and mentioned the cloud function url inside the dimension of of that table look and since we cant make cloud function permission to all user , our workflow is not working for this permission issue , is there though cloud pub sub we can do this more securely and in data action we use cloud function url if we use pub sub how that should be mentioned in the lookml code 

[Zach_A]

Hi @SachinS - using the action parameter like this will limit your ability to connect to functions that are not public. For more advanced functionality w/ actions, you might want to consider developing an action through looker's Action Hub. This will allow you to have more control over how the action is authenticated and will allow looker to connect to services like authenticated cloud functions. 

[SachinS]

@Zach_A  can you please share some reference how we can create it using action hub, I did not got much helpful articles on this on internet

[Zach_A]

Looker's developer portal is a great place to start. We also have Looker partners who specialize in data action development. If you need support - please reach out through your Looker account manager. 

[SachinS]

@Zach_A  does the looker action hub supports field level operation , like we have table look where on last three column clinet will put the data and we need to send that back to bigquery for table updatation