BigQuery Connector

To connect TextQL with Google BigQuery, you will need to set up a service account with appropriate permissions. The service account requires the following roles:

• BigQuery Data Viewer: For accessing and reading data
• BigQuery Job User: For executing queries

​

Creating a Service Account

1. Navigate to the Google Cloud Console to create a service account.
2. Grant the required roles (BigQuery Data Viewer and BigQuery Job User).
3. Create and download the service account key file (JSON format).

​

Creating the Connector in TextQL

Navigate to the TextQL Connectors Page and click Create New Connector. Select BigQuery from the available connectors to open the configuration form.

The form requires the following information:

• Connector Name: A descriptive name to identify this specific BigQuery connection in TextQL.
• Project ID: Your Google Cloud project identifier.
• Dataset ID: The specific BigQuery dataset to connect to (optional).
• Service Account Key: The JSON key file contents for authentication.
• Region Qualifier: The geographic location of your BigQuery resources.

​

Testing the Connection

After entering your credentials, click Create to establish the connection. TextQL will validate your service account permissions and create the connector. If the connection fails, verify your service account key and ensure all required permissions are granted.

​

Next Steps

Once connected, you can use TextQL to query your BigQuery datasets. For optimal performance and security:

• Use a dedicated service account for TextQL connections
• Apply principle of least privilege when assigning roles
• Consider setting up dataset-level access controls
• Monitor query costs through BigQuery’s pricing calculator