OpenVPN for Google BigQuery

Learn how to configure secure access from ThoughtSpot Cloud to your data in Google BigQuery, through your OpenVPN server.

You can make your data in Google BigQuery even more secure by connecting to your OpenVPN server. This feature is also available for data in Azure Synapse or Snowflake on Azure.

VPN is not supported for ThoughtSpot on GCP.

Your company may have a policy that prohibits exposing your cloud data to the internet. In this case, you can set up a VPN connection between your ThoughtSpot Cloud cluster and your data warehouse, either Google BigQuery or Azure Synapse.

ThoughtSpot supports the following 3 OpenVPN servers:

Set up an OpenVPN connection

You must perform several preliminary steps before asking ThoughtSpot Support to connect your OpenVPN server to your ThoughtSpot cluster(s).

  1. Set up an OpenVPN server, on OpenVPN Community Edition, Azure VPN, or AWS Client VPN.

  2. Create your OpenVPN configuration file in .ovpn form. The configuration file must be one file, in .ovpn form. To generate your configuration file, refer to these articles:

Google BigQuery does not support OpenVPN as a managed service. You must run a VM with OpenVPN.

Send the configuration file to ThoughtSpot Support

Send the OpenVPN configuration file to ThoughtSpot Support.

ThoughtSpot Support then configures the VPN on your ThoughtSpot Cloud cluster(s).

Connect your ThoughtSpot cluster(s) to your data warehouse

Configure Connections for GBQ.