This article describes how to add your own custom query in a data connection

1. Open your Analyst client.
2. Go to File - Add data tables.
3. Click  the "Add" button, go to the section "Connection to" and add your preferred data connection.
4. Logon to your data source.
5. In the "Views in Connection" window, click the "Custom query" button.
6. Add your query.
7. Click the "Verify" button to verify the query is correct.
8. Click OK.

Using TIBCO Spotfire Analyst version 10.0 and higher:

1. Open your Analyst client.
2. Go to the Files and data flyout, click "Connect to" and mark your preferred data connection.
3. Click the "New connection" button and logon your data source.
4. In the "Views in Connection" window, click the "Custom query" button.
5. Add your query.
6. Click the "Verify" button to verify the query is correct.
7. Click OK.

• https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=connect%2Fconnect_writing_custom_queries.htm&rhsearch=trust%20custom%20query&rhhlterm=trust%20custom%20query&rhsyns=%20

• https://support.tibco.com/s/article/How-to-edit-an-existing-custom-query-in-a-data-connection