Stephie EDWIGE

Ok I'll do the request. This definitely looks like the best option to share the connectors in a safe way. I don't like either to embed the connection in the dashboard because if the custom query needs to be modify, I will have to update each dashboards ... Thanks a lot for your help ! I'll mark your post as solution as soon as I completed the test as custom query author.

From what I understand, to trust a custom query, it needs to be verified before being stored in the library. I did this, but it didn't solve the issue for users who do not have modification permission on the connectors. Regarding the custom query author group, I am not sure if I am part of it. I will need to check with an admin. What is really confusing for me, is that it works for users who have modification permission on the connector. If I'm not a custom query author or my custom query is not verified, shouldn't it not work for anyone?

Dear Spotfire Community User, I’m currently working with BigQuery connectors stored in the library for our dashboards. I’ve encountered an issue that I hope to get some insights on. I created a data source and multiple connectors stored in the library. Analysts are using these connectors in their dashboards and sharing them with collaborators. However, it appears that even if collaborators have access to the BigQuery datasets, the data source and the connectors in the library, they can only retrieve data if they have modification permission on the connectors. This seems inconsistent with how information links operate. When collaborators lack modification permission on the connector, they receive the error: "The customQuery was not allowed to execute because it is not trusted" (see screenshot attached). This behavior is a little bit confusing, and I’m trying to understand why it differs from information links. Additionally, I don't want to allow everyone to modify the connectors. Spotfire version: 11.4.6 LTS Any insights or guidance on this issue would be greatly appreciated. Thank you for your time! Best regards, SE

I am trying to import french csv file from a sharepoint (semi-colon instead of comma and comma as a decimal separator instead of dot in standard csv). When I specify semicolon as a column separator in the sharepoint connector, it will process the comma as a thousand separator but not as a decimal separator. This works correctly while importing the same csv throught local directory (see picture attached). How to solve the sharepoint import format ?