ThoughtSpot logo
Cloud
Software ThoughtSpot
Everywhere
SeekWell

Cloud

    • About this release
      • Release notes
      • Fixed issues
      • Known issues
      • 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
      • ThoughtSpot browser access
      • Your user preferences
      • Use tags to organize
      • Privileges
        • Granular access to Liveboards
    • Free Trial
      • What’s new
      • Load CSV files
    • ThoughtSpot for…​
      • Business Users
        • Business user onboarding
        • Home page
        • Search Answers
        • Search Data
        • New answer experience
        • New Liveboard experience
        • Using Liveboards and Answers
        • Using parameters
        • Search Assist
        • ThoughtSpot Sync
          • Sync data to Google Sheets
          • Sync data to HubSpot
          • Sync data to Microsoft Teams
          • Sync data to Salesforce
          • Sync data to ServiceNow
          • Sync data to Slack
      • Analysts
        • Analyst onboarding
        • Connect to data
        • Join tables
        • Create Worksheets in Setup
        • Create Worksheets
        • Search Assist Coach
        • Visualize search results
        • Create Answers in Setup
        • Compose Liveboards from Answers
        • Linked Liveboard filters
        • Selective Liveboard filters
        • Mandatory Liveboard filters
        • Creating parameters
        • Import and export TML files
        • Migrate multiple TML files
        • ThoughtSpot Modeling Language
        • SpotApps
          • Deploying SpotApps
          • Databricks Storage and Performance SpotApp
          • DEI Workforce Diversity SpotApp
          • Facebook Ads SpotApp
          • GBQ Performance and Consumption SpotApp
          • Google Ad Analysis SpotApp
          • Google Analytics SpotApp
          • HubSpot Email Marketing SpotApp
          • Jira Issue Management SpotApp
          • Jira Sprint Management SpotApp
          • LinkedIn Ads SpotApp
          • Okta Application Management SpotApp
          • Redshift Performance and Consumption SpotApp
          • Salesforce Pipeline Analysis SpotApp
          • Procurement Vulnerability Analysis for SAP SpotApp
          • ServiceNow Incident Management SpotApp
          • Snowflake Performance and Consumption SpotApp
        • Disable Answer Search for specific Worksheets
        • How users are searching Answers Liveboard
      • Data Engineers
        • About connections
          • Share a connection
          • ThoughtSpot query tags
        • Connect to Amazon Redshift
          • Add connection
          • Edit connection
          • Remap connection
          • Query external tables
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Best practices
          • Enable a PrivateLink
          • Connection reference
          • Redshift Partner Connect overview
        • Connect to Azure Synapse
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Connection reference
        • Connect to Databricks
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Databricks Partner Connect overview
        • Connect to Denodo
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
        • Connect to Dremio
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
        • 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 Oracle
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
        • Connect to PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
        • Connect to Presto
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
        • Connect to SAP HANA
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
        • 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
          • Connection reference
          • Passthrough functions
          • Snowflake Partner Connect overview
          • Snowflake Partner Connect tutorials
        • Connect to Starburst
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
        • Connect to Teradata
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
        • Connect to Trino
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
        • 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 PostgreSQL
          • Enable a PrivateLink for Oracle
          • Enable a PrivateLink for SAP HANA
          • Enable a PrivateLink for Snowflake
          • 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
      • IT and Ops
        • Managing users
        • Managing groups
        • Authentication overview
        • Identity and Access Management V2
        • Managing local authentication
        • 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 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
        • Custom domain configuration
        • Performance tracking Liveboard
        • User adoption Liveboard
        • Object usage Liveboard
        • Query stats Liveboard
        • ThoughtSpot use agreement
      • Developers
        • Embedded analytics
        • Integration guidelines
        • ThoughtSpot Developer Portal
        • Authentication and security
        • Visual Embed SDK
        • Custom actions
        • Customization and rebranding
        • REST APIs
        • Runtime filters
    • 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
        • 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
    • Charts
      • Chart types
        • Column charts
        • Stacked column charts
        • Line charts
        • KPI charts
        • Pivot table
        • Pie 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
        • Add regression lines
        • Display gridlines
        • Disable automatic selection of chart type
        • Zoom into chart
    • Formulas
      • Add formula to search
      • View or edit formula in search
      • Aggregate formulas
        • Cumulative functions
        • Moving functions
        • Flexible aggregation functions
        • Grouping functions
        • 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
      • Answer Explorer
      • 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
    • SpotIQ
      • Best practices
      • Monitor KPI
      • Custom SpotIQ analysis
      • SpotIQ change analysis
      • SpotIQ preferences
      • Insight feedback
    • Mobile
      • Deploy
      • Install and set up
      • FAQ
      • Release notes
    • Work with data
      • Set your display language (locale)
    • Share your work
      • Share Liveboards
      • Share Answers
      • Request access
      • Revoke access
    • Help and support
      • Contact support
    • Administration
      • Support Handbook
      • High Availability and resilience
      • Data protection and business continuity
      • 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
          • 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
      • Security
        • System security
        • Data 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
        • ThoughtSpot lifecycle
      • Improve search with 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
      • Simplify search with Worksheets
        • Edit a Worksheet
        • Create a formula in a Worksheet
        • Create a Worksheet filter
        • 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
          • Query stats Liveboard
        • Time-based usage
        • Consumption data storage
      • Contact ThoughtSpot Support
    • Reference
      • Keyword reference
      • Date and time formats reference
      • Row-level security rules reference
      • Formula function reference
      • Alert codes reference
      • 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
    • 9.0.0.cl
    • 8.10.0.cl
  • Home
    • master
  • SeekWell
    • latest
  • Software
    • 8.8.sw
    • 8.4.sw
    • 7.2
    • 7.1
    • 7.0
    • 6.3
    • 6.2
    • 6.1
    • 6.0
  • Cloud
  • ThoughtSpot for…​
  • Data Engineers
  • Connect to Azure Synapse
9.0.0.cl 8.10.0.cl
Was this page helpful?

Give us feedback!
×

Azure Synapse overview

You can connect to an Azure Synapse database in ThoughtSpot Cloud, and perform live queries to create Answers and Liveboards.

  • Add a Synapse connection

  • Edit a Synapse connection

  • Remap a Synapse connection

  • Delete a table from a Synapse connection

  • Delete a table with dependent objects

  • Delete a Synapse connection

  • Configure OAuth

  • Connection reference for Synapse

  • ThoughtSpot query tags in Synapse

ThoughtSpot is the Modern Analytics Cloud company. Our Live Analytics services deliver personalized, actionable insights at the point of impact for every user, at every level.

Product
  • Product
  • Auto Analyze
  • Visualize
  • Connect
  • Operationalize
  • Embed
  • Mobile
  • Govern & Secure
  • New features
  • Pricing
By Role
  • Business Leader
  • Data Leader
  • Analyst
  • Product Leader
  • Developer
By Department
  • Marketing
  • Sales
  • ServiceNow Analytics
Solutions
  • Banking
  • Financial Services
  • Retail & E-commerce
  • Manufacturing & Logistics
  • Healthcare & Life Sciences
  • Media & Communications
  • Procurement
  • Public Sector
About Us
  • Team
  • Customers
  • Atlas Marketplace
  • Partner Directory
  • Events
  • News
  • Careers
  • Blog
  • Legal
  • Trust
Connect
  • Free Trial
  • Resources
  • Request Demo
  • Professional Services
  • Community
  • Support
  • Contact Us

(800) 508-7008

©2023 ThoughtSpot Inc. All Rights Reserved
Terms of Use Privacy Statement Cookie Policy