Documentation

No results

Community

  1. Article ThoughtSpot NAT IP Update - FAQ

  2. Article ThoughtSpot NAT IP Update – What You Need to Know

  3. Article ThoughtSpot Community Newsletter: May 2025

  4. Article How to secure your data in ThoughtSpot

  5. Article ThoughtSpot Community Newsletter, April 2025

Training

  1. Course Getting Started with ThoughtSpot Analytics Cloud

  2. Course Introduction to Search and Answers

  3. Course Using Keywords

  4. Course Introduction to Liveboards

  5. Course Working with Filters

More

Cloud

    • About this release
      • Release notes
      • Accessibility
      • Deprecated and removed features
      • Release life cycle
    • Getting started
      • Requirements and support
      • Activate your account using IAMv2
      • User onboarding experience
      • Finding your way around
      • New home page and navigation
      • Web notifications
      • ThoughtSpot browser access
      • Your user preferences
      • Use tags to organize
    • Free Trial
      • What’s new
      • Load CSV files
    • ThoughtSpot for…​
      • Business Users
        • Business user onboarding
        • Home page
        • Search Answers
        • Search Data
        • Using Liveboards and Answers
          • Liveboard experience
          • Answer experience
          • Ask Sage
          • ThoughtSpot Sage
          • Sage Coach
        • Collaborative Liveboards
        • Using Parameters
        • Search Assist
        • AI-suggested searches
        • Sage search
        • Best practices for Sage
        • ThoughtSpot Sync
          • Sync data to Excel
          • Sync data to Gainsight
          • Sync to Google BigQuery
          • Sync data to Google Sheets
          • Sync data to HubSpot
          • Sync data to Microsoft Teams
          • Sync data to Redshift
          • Sync data to Salesforce
          • Sync data to ServiceNow
          • Sync data to Snowflake
          • Sync data to Slack
          • Sync data to Zoho
        • Privileges
        • Google Sheets add-on
        • ThoughtSpot add-in for MS Excel
        • Google Slides add-on
        • ThoughtSpot Dev Slack app
      • Analysts
        • Analyst onboarding
        • Connect to data
        • Join tables
          • Supported join types
        • Create Worksheets in Setup
        • Create Worksheets
        • Create Models
        • Search Assist Coach
        • Sage search
          • Best practices for Sage
          • Sage enablement
          • Worksheet readiness for Sage
          • Sage feedback process
          • Sage Coach
        • Visualize search results
        • Create Answers in Setup
        • Create a Liveboard
        • Liveboard note tiles
        • Collaborative Liveboards
        • Linked Liveboard filters
        • Selective Liveboard filters
        • Mandatory Liveboard filters
        • Liveboard cross filters
        • Personalized Liveboard views
        • Create Parameters
        • Column Sets
        • Query Sets
        • Disable Answer Search for specific Worksheets
        • How Users are searching Answers Liveboard
      • Data Engineers
        • About connections
          • Categorizing connections
          • Share a connection
          • ThoughtSpot query tags
          • Column indexing with OAuth
          • OAuth sign-in for Liveboards
        • Connect to Amazon Athena
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Amazon Athena
        • Connect to Amazon Aurora MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon Aurora MySQL
        • Connect to Amazon Aurora PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon Aurora PostgreSQL
        • Connect to Amazon RDS MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon RDS MySQL
        • Connect to Amazon RDS PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon RDS PostgreSQL
        • Connect to Amazon Redshift
          • Add connection
          • Edit connection
          • Remap connection
          • Query external tables
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure AWS IDC OAuth
          • Configure Azure AD OAuth
          • Best practices
          • Enable a PrivateLink
          • Enable a Redshift-managed PrivateLink
          • Connection reference
          • Redshift Partner Connect overview
          • Passthrough functions for Redshift
        • Connect to Azure Synapse
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Connection reference
          • Passthrough functions for Synapse
        • Connect to Bridge
        • Connect to Databricks
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Configure OAuth with AAD
          • Enable a PrivateLink
          • Connection reference
          • Databricks best practices
          • Databricks Partner Connect overview
          • Passthrough functions for Databricks
        • Connect to Denodo
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Denodo
        • Connect to Dremio
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Dremio
        • Connect to Generic JDBC
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Generic JDBC
        • Connect to Google AlloyDB for PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google AlloyDB for PostgreSQL
        • Connect to Google BigQuery
          • Prerequisites
          • Access levels and ingress rules for Google BigQuery
          • Add connection
          • Edit connection
          • Remap connection
          • Query external tables
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Connection reference
          • Passthrough functions
        • Connect to Google Cloud SQL for MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google Cloud SQL for MySQL
        • Connect to Google Cloud SQL for PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google Cloud SQL for PostgreSQL
        • Connect to Google Cloud SQL for SQL Server
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google Cloud SQL for SQL Server
        • Connect to Looker
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
        • Connect to Mode
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
        • Connect to MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for MySQL
        • Connect to Oracle
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Oracle
        • Connect to PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for PostgreSQL
        • Connect to Presto
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Presto
        • Connect to SAP HANA
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for SAP HANA
        • Connect to SingleStore
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for SingleStore
        • Connect to Snowflake
          • Add connection
          • Edit connection
          • Remap connection
          • Upload CSV
          • Query external tables
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Configure Azure AD OAuth
          • Configure Okta OAuth
          • Configure CSV Upload
          • Best practices
          • Enable a PrivateLink
          • Enable a GCP Private Service Connect between ThoughtSpot Cloud and your Snowflake data warehouse
          • Connection reference
          • Passthrough functions
          • Snowflake Partner Connect overview
          • Snowflake Partner Connect tutorials
        • Connect to SQL Server
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for SQL Server
        • Connect to Starburst
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Starburst
        • Connect to Teradata
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Teradata
        • Connect to Trino
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Trino
        • Custom calendar
          • Create custom calendar
          • Update custom calendar
          • Delete custom calendar
        • AWS PrivateLink
          • Enable a PrivateLink for Amazon Redshift
          • Enable a PrivateLink for Databricks
          • Enable a PrivateLink for Denodo
          • Enable a PrivateLink for Dremio
          • Enable a PrivateLink for Oracle
          • Enable a PrivateLink for PostgreSQL
          • Enable a PrivateLink for SAP HANA
          • Enable a PrivateLink for Snowflake
          • Enable a PrivateLink for SQL Server
          • Enable a PrivateLink for Starburst
          • Enable a PrivateLink for Teradata
        • Query external tables
          • Query external tables from your Amazon Redshift connection
          • Query external tables from your Google BigQuery connection
          • Query external tables from your Snowflake connection
        • Integrate with dbt
          • Metadata tags for dbt
        • Alation catalog integration
        • Atlan catalog integration
        • Collibra catalog integration
      • IT and Ops
        • Managing users
        • Managing groups
        • Understand RBAC and privileges
        • Authentication overview
        • Managing local authentication
        • Identity and Access Management V2
        • Managing authentication with SAML
        • Managing authentication with SAML using IAMv2
        • Configure SAML group mapping
        • Search and SpotIQ settings
        • Email and onboarding settings
        • Scheduled maintenance
        • Style customization
        • Help customization
        • AWS PrivateLink
          • Enable a PrivateLink for Amazon Redshift
          • Enable a PrivateLink for Databricks
          • Enable a PrivateLink for Denodo
          • Enable a PrivateLink for Dremio
          • Enable a PrivateLink for Oracle
          • Enable a PrivateLink for PostgreSQL
          • Enable a PrivateLink for SAP HANA
          • Enable a PrivateLink for Snowflake
          • Enable a PrivateLink for SQL Server
          • Enable a PrivateLink for Starburst
          • Enable a PrivateLink for Teradata
        • OpenVPN for Google BigQuery
        • OpenVPN for Azure Synapse and Snowflake on Azure
        • Configure IPSec VPN for your cloud data connection
        • OIDC authentication
        • OIDC authentication with IAMv2
        • Custom domain configuration
        • Performance Tracking Liveboard
        • User Adoption Liveboard
        • Object Usage Liveboard
        • Billable Query Stats Liveboard
        • Indexing Queries Liveboard
        • Index Statistics Liveboard
        • ThoughtSpot use agreement
      • Developers
    • Search
      • Search Answers
      • Search Data
      • Search basics
        • Choose a data source
        • Search bar features
        • Search suggestions
        • Search results and column types
        • Last data refresh time
        • Work with Answers
        • Results that are tables
      • Use keywords in search
        • Time series analysis
        • Date filters for Answers
        • Search using growth over time
        • Using the keyword in for nested searches
        • Proximity search: near and farther than
      • Work with filters
        • Add a filter to a table
        • Add a filter to a chart
        • Create a bulk filter
        • Delete a filter
        • Filter on null, blank, or empty values
      • Other search actions
        • Change result display options
        • Show underlying data
        • See the search behind a result
        • Apply conditional formatting
        • Download your search
      • ThoughtSpot Sage
      • Query and autocomplete options
    • Spotter
      • When Spotter is enabled
        • Getting started with Spotter
        • Spotter Worksheet/Model readiness
        • Coach Spotter
          • Getting started with Coach Spotter
          • Understanding coaching options for Spotter
          • Steps to coach Spotter
        • Spotter best practices
          • Validate Spotter
          • Unexpected answers in Spotter
      • When Spotter is disabled
        • Sage search
        • Ask Sage
        • Sage Coach
    • Charts
      • Chart types
        • Column charts
        • Stacked column charts
        • Line charts
        • KPI charts
        • Pivot table
        • Donut charts
        • Bar charts
        • Stacked bar charts
        • Line column charts
        • Area charts
        • Stacked area charts
        • Line stacked column charts
        • Scatter charts
        • Bubble charts
        • Waterfall charts
        • Heatmap charts
        • Treemap charts
        • Funnel charts
        • Geo charts
          • Geo bubble charts
          • Geo heatmap charts
          • Geo area charts
        • Sankey charts
        • Radar charts
        • Candlestick charts
        • Pareto charts
      • Changing charts
        • Change axes options
        • Configure the columns
        • Rename columns and axes
        • Customize titles and descriptions with HTML
        • Reorder labels
        • Set the y-axis range
        • Hide and show values
        • Charts with a large number of data values
        • Change chart colors
        • Show data labels
        • Show data markers
        • Null and missing values in charts
        • Add regression lines
        • Display gridlines
        • Zoom into chart
        • Advanced chart customization settings
      • Custom charts
        • VitaraCharts
    • Formulas
      • Add formula to search
      • View or edit formula in search
      • Semi-additive measures with first_value and last_value functions
        • Modeling semi-additive measure data for slowly-changing dimensions
      • Aggregate formulas
        • Cumulative functions
        • Moving functions
        • Flexible aggregation functions
        • Grouping functions
        • Keywords "of", "percentage of"
        • Filtered aggregation functions
        • Aggregate filters
        • Conversion functions
        • Date functions
        • Percent calculations
        • Formula operators
        • Nested formulas
        • Formulas for chasm traps
    • Liveboards
      • Edit Liveboard layouts
      • Liveboard tabs
      • Liveboard filters
      • Personalized Liveboard views
      • Verified Liveboards
      • Answer Explorer
      • AI Highlights
      • Schedule a Liveboard job
      • Search actions within a Liveboard
      • Copy a Liveboard
      • Copy a Liveboard or visualization link
      • Reset a Liveboard visualization
      • Present Liveboard as slideshow
      • Download as PDF
    • Analyst Studio Beta
      • Open Source Code Attributions
        • Supported browsers
      • Navigate and organize content
        • Collections
        • Organizing Reports
        • Collaboration and discovery
      • Connect your database
        • Connecting Analyst Studio to your database
        • Supported databases
        • Managing database connections
      • Query and analyze data
        • Querying data
        • AI Assist
        • Datasets
        • The Notebook
        • Parameters
        • Visualization filters
        • Definitions
      • Visualize data
        • Visualizations
        • Visual Explorer
        • Visual Explorer guides
          • Stacked bars
          • 100% stacked bars
          • Grouped bars
          • Combination: multiple panes
          • Dual axes
          • Faceting/ small multiples
          • Funnel
          • Line
          • Pie
          • Pivot table
          • Conditional formatting
          • Scatter
        • Calculated fields
      • Schedule a Report
        • Report scheduling
      • Integrations
        • dbt data freshness
        • GitHub sync
        • Google Sheets integration
        • Semantic layer integrations
        • Webhooks
      • Administration
        • Access control and permissions
        • Administration permissions
        • API tokens
      • API
        • API reference
        • Discovery API
      • FAQs
    • SpotIQ
      • Monitor KPI
      • Webhooks for Monitor
      • Custom SpotIQ analysis
      • SpotIQ change analysis
      • Forecasting
      • Anomaly detection
      • SpotIQ preferences
      • Insight feedback
      • Best practices for SpotIQ Analyze
    • Mobile
    • Work with data
      • Set your display language (locale)
    • Share your work
      • Share Liveboards
      • Share Answers
      • Request access
      • Revoke access
    • Help and support
      • Contact support
    • Modeling
      • Improve search with data modeling
        • Change a table’s data model
        • Edit system-wide data model
        • Data model settings
          • Set column name, description, and type
          • Set additive and aggregate values
          • Hide a column or define a synonym
          • Manage suggestion indexing
          • Add a geographical data setting
          • Upload custom geo maps
          • Set number, date, and currency formats
          • Change the attribution dimension
          • Exclude from SpotIQ analyses
          • Chasm traps
          • Data types
        • Link tables using relationships
          • Create a relationship
          • Delete a relationship
          • Use tags
      • Content management with ThoughtSpot Modeling Language
        • Import and export TML files
        • Migrate multiple TML files
        • TML for Answers
        • TML for connections
        • TML for joins
        • TML for Liveboards
        • TML for Models
        • TML for Monitor alerts
        • TML for Sets
        • TML for SQL views
        • TML for tables
        • TML for views
        • TML for Worksheets
    • Administration
      • Support Handbook
      • ThoughtSpot editions
        • Administration
        • Usage limits
      • High Availability and resilience
      • Data Protection and Disaster Recovery
      • Multi-tenancy with Orgs
        • Orgs administration
        • Create, edit, or delete a user in a multi-tenant environment
        • Create, edit, or delete a group in a multi-tenant environment
        • Admin Console for Orgs
          • Create, edit, and delete Orgs
          • Managing users in a multi-tenant environment
          • Managing groups in a multi-tenant environment
          • Managing local authentication
          • Managing authentication with SAML
          • User Adoption Liveboard
            • User productivity
          • Performance Tracking Liveboard
          • Managing search and SpotIQ settings
          • Managing email and onboarding settings
          • Style customization
          • Scheduled maintenance
      • Manage data
        • How to view a data schema
        • Delete a data source
      • Manage users and groups
        • Understand groups and privileges
        • Create, edit, or delete a group
        • Create, edit, or delete a user
        • Create, edit, or delete a user using IAMv2
        • Manage user logins and sessions
        • Allow users to sign up
      • Enable Early Access features
      • Version control
      • ThoughtSpot Status page
      • Security
        • System security
        • Data security
          • Data and object security
          • Share tables and columns
          • Share Worksheets
          • Share views
          • Share Liveboards
          • Share Answers
          • Revoke access
        • Row-level security
          • How rule-based RLS works
          • Set rule-based RLS
        • Data masking with system variables
        • ThoughtSpot lifecycle
      • Simplify search with Worksheets
        • Edit a Worksheet
        • Create a formula in a Worksheet
        • Create a Worksheet filter
        • Define a custom sort order for a Worksheet
        • How the Worksheet join rule works
        • Create join rule or RLS for a Worksheet
        • Create a join relationship
        • Modify joins between Worksheet tables
        • Delete Worksheets or tables
        • Migrate or restore Worksheets
        • Worksheet TML specification
      • Work with views
        • SQL-based views
        • Save a search as a view
        • Create a search from a view
        • View example scenarios
      • Manage scheduled jobs
        • Scheduled Liveboards management
      • Monitoring
        • System Worksheets
        • System Liveboards
      • Troubleshooting
        • Generate a HAR file for ThoughtSpot Support
        • Network connectivity issues
        • Clear the browser cache
        • Cannot open a saved Answer that contains a formula
        • Search results contain too many blanks
      • Consumption-based pricing
        • Query-based usage
          • User actions and queries
          • Subscription and rollover
          • Billable Query Stats Liveboard
        • Time-based usage
        • Consumption data storage
      • Contact ThoughtSpot Support
    • Reference
      • Keyword reference
        • Dansk: Danish keyword reference
        • Deutsch: German keyword reference
        • English (American) keyword reference
          • Period to-date keywords
        • Español (España): Spanish keyword reference
        • Español (Latinoamérica): Spanish Latin American keyword reference
        • Français (Canada): French Canadian keyword reference
        • Français (France): French keyword reference
        • Italiano: Italian keyword reference
        • Nederland: Dutch keyword reference
        • Norsk: Norwegian keyword reference
        • Português (Portugal): Portuguese keyword reference
        • Português (Brasil): Portuguese Brazilian keyword reference
        • русский (ограниченный выпуск): Russian (Limited Edition) keyword reference
        • Suomi: Finnish keyword reference
        • Svenska: Swedish keyword reference
        • 中文 (简体): Chinese (Simplified) keyword reference
        • 中文 (繁體): Chinese (Traditional) keyword reference
        • 日本語: Japanese keyword reference
        • 한국어: Korean keyword reference
      • Date and time formats reference
      • Row-level security rules reference
      • Formula function reference
      • Alert codes reference
      • Search data error reference
      • Cluster-level settings
      • User action codes reference
      • Geo map reference
      • REST API reference
      • Glossary
      • Frequently asked questions
    • ThoughtSpot in practice
      • Reaggregation in practice
      • Liveboard schedule gating conditions in practice
      • Add a hyperlink to a search
  • Cloud
    • 10.8.1.cl
    • 10.8.0.cl
    • 10.6.0.cl
    • 10.5.0.cl
    • 10.4.0.cl
  • Home
    • main
  • Cloud
  • ThoughtSpot for…​
  • Data Engineers
  • Connect to Google BigQuery
Was this page helpful?

Give us feedback!
×

Google BigQuery overview

You can connect to a Google BigQuery database in ThoughtSpot Cloud, and perform live queries to create Answers and Liveboards.

  • BigQuery prerequisites

  • Access levels and ingress rules for Google BigQuery

  • Add a BigQuery connection

  • Edit a BigQuery connection

  • Remap a BigQuery connection

  • Query external tables from your BigQuery connection

  • Delete a table from a BigQuery connection

  • Delete a table with dependent objects

  • Delete a BigQuery connection

  • Configure OAuth for a BigQuery connection

  • Connection reference for BigQuery

  • Passthrough functions for Google BigQuery