Question:
I’ve created an external collection connected to BigQuery and the table contains the required fields
- _id
- _createdDate
- _updatedDate
- _owner
The permissions on the connector are as permissive as possible currently allowing OWNER, MEMBER, and VISITOR read/write.
Still the + Add Item button is greyed out with an info box appearing “You can’t add items to this external collection. Learn how to use external collections” and the link it provides is broken.
Product:
Wix Studio Editor
What are you trying to achieve:
I want to do external reporting via BigQuery for users interacting with the site.
I’m using the following connector GitHub - wix/velo-external-db and the information page for the running app shows that it’s working and the permissions are correct. Even manual tests to the api endpoint show that read/write permissions for the table are enabled. From what I can tell it’s just WIX’s interface that doesn’t think it can.