ThoughtSpot logo
Software
Cloud Mobile Spotter ThoughtSpot
Embedded SeekWell

Software

    • About our releases
      • Release notes
      • Mobile release notes
      • Fixed issues
      • Accessibility
      • Deprecated and removed features
      • Downloads for ThoughtSpot
      • More help and support
      • ThoughtSpot Support
        • Contact ThoughtSpot Support
        • Configure support services
        • ThoughtSpot Support Handbook
        • Support Handbook PDF
      • EOS and EOL announcements
        • Release end-of-service
      • Users and workflows
        • Business User
        • Analyst
          • Analyst onboarding
          • Create worksheets in Setup
          • Create answers in Setup
        • Data Engineer
        • IT and Ops
        • Developer
      • Getting started
        • User onboarding experience
        • Search Assist
        • Finding your way around
        • ThoughtSpot browser access
        • Your user preferences
        • Use tags to organize
        • Privileges
          • Granular access to Liveboards
      • Third-party software
        • Full list CSV
    • Search
      • Start a new search
      • Choose a data source
      • Search bar features
      • Search suggestions
      • Search results and column types
      • Last data refresh time
      • Work with answers
      • Model, migrate, or restore answers
      • Results that are tables
      • Keyword searches
        • Time series analysis
        • Search using growth over time
        • Subquery search (in keyword)
        • 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 to a table
        • Download your search
    • Answers and Liveboards
      • New answer experience
      • Charts
        • Chart types
          • Column charts
          • Stacked column charts
          • Bar charts
          • Stacked bar charts
          • Line charts
          • KPI charts
          • Pie charts
          • Area charts
          • Stacked area charts
          • Scatter charts
          • Bubble charts
          • Pareto charts
          • Waterfall charts
          • Treemap charts
          • Heatmap charts
          • Line column charts
          • Line stacked column charts
          • Funnel charts
          • Geo charts
            • Geo area charts
            • Geo bubble charts
            • Geo heatmap charts
          • Pivot table
          • Sankey charts
          • Radar charts
          • Candlestick charts
      • Changing charts
        • Change axes options
        • Configure the columns
        • Rename columns and axes
        • Customize titles and descriptions with HTML
        • Reorder the labels
        • Set the y-axis range
        • Hide and show values
        • Charts and tables with a very 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 a chart
      • Liveboards
        • Edit a Liveboard
        • Liveboard filters
        • Linked Liveboard filters
        • Selective Liveboard filters
        • Answer Explorer
        • Schedule a Liveboard job
        • Search actions within a Liveboard
        • Delete a visualization
        • Copy a Liveboard
        • Copy a Liveboard or visualization link
        • Reset a Liveboard or visualization
        • Present a Liveboard as a slideshow
        • Download as PDF
        • Model, migrate, or restore Liveboards
      • Formulas
        • Add a formula to search
        • View or edit a formula in a search
        • Aggregate formulas
          • Cumulative functions
          • Moving functions
          • Flexible aggregation functions
          • Grouping functions
          • Filtered aggregation functions
        • Conversion functions
        • Date functions
        • Simple number calculations
        • Percent calculations
        • Formula operators
        • Nested formulas
        • Formulas for chasm traps
      • Custom R in ThoughtSpot
        • Create and share R scripts
        • Run prebuilt R scripts on answers
        • Save and share R visualizations
      • SpotIQ
        • Best practices
        • Comparative analysis
        • Custom SpotIQ analysis
        • Advanced R customizations
        • Insight feedback
        • SpotIQ preferences
    • Work with data
      • Data workspace
        • Append data through the UI
        • View a data profile
        • Set your ThoughtSpot locale
        • Share your work
          • Share a Liveboard
          • Share answers
          • Share uploaded data
          • Request object access
          • Revoke access (unshare)
      • Improve search with modeling
        • Change a table’s data model
        • Edit the system-wide data model
        • Data modeling settings
          • Set column name, description, and type
          • Set additive and aggregate values
          • Hide a column
          • Define a synonym
          • Exclude columns from SpotIQ analyses
          • Manage suggestion indexing
          • Add a geographical data setting
          • Set number, date, currency formats
          • Change the attribution dimension setting
        • Link tables using relationships
          • Create a relationship
          • Delete a relationship
      • Work with worksheets
        • Creating worksheets
        • Editing or renaming worksheets
        • Create a formula in a worksheet
        • Add a filter to a worksheet
        • How the worksheet join rule works
        • Change join rule or RLS for a worksheet
        • Create a join relationship
        • Modify joins within a worksheet
        • Create worksheet onboarding lessons with Search Assist Coach
        • Delete a worksheet or table
        • Model, migrate, or a restore a worksheet
        • Worksheet TML specification
      • Work with views
        • SQL views
        • Save a search as a view
        • Create a search from a view
        • View example scenarios
        • Materialized views
        • Materialize a view
        • Dematerialize a view
        • Refresh a materialized view
        • Model, migrate, or restore views
        • Schedule view refreshes
      • Load and manage data
        • Integrate with dbt
        • Configure casing
        • Load CSV files with the UI
        • How to view a data schema
        • Plan the schema
          • Data types
          • Constraints
          • Sharding
          • Chasm traps
        • Build the schema
          • Connect with TQL and create a schema
          • Create a schema in SQL
          • Schema creation examples
          • Upload and run a SQL script
        • Change the schema
          • Convert column data type
        • Import CSV files with tsload
        • Load data with a script
        • Load data with the tsload connector
        • Delete a data source (table)
        • Delete or change a table in TQL
    • Administration
      • Log in credentials
      • Admin console
        • Managing users
        • Managing groups
        • Local authentication
        • Authentication through SAML
        • Authentication through Active Directory
        • Managing search and SpotIQ settings
        • Managing email and onboarding settings
        • Configure SSL
        • Configure a reverse SSH tunnel
        • Set the relay host for SMTP (email)
        • Customize ThoughtSpot help
        • Style customization
        • Configure NAS for backup storage
        • Manage and create snapshots
        • System cluster Liveboard
        • System alerts Liveboard
        • System information and usage Liveboard
        • Table status Liveboard
        • User adoption Liveboard
        • Performance tracking Liveboard
      • Style customization
        • Upload application logos
        • Set chart and table visualization fonts
        • Choose a background color
        • Select chart color palettes
        • Change the footer text
      • System administration
        • Send logs when reporting problems
        • Upgrade a cluster
      • Choose the backup strategy
        • Understand backup/snapshot schedules
        • Work with snapshots
        • Backup modes
          • Create a manual backup
          • Configure periodic backups
          • About restore operations
      • Liveboard schedule management
      • System monitoring
        • System information and usage Liveboard
        • Table status Liveboard
        • Cluster manager board
        • Alerts and events board
        • System worksheets
          • TS:BI Server worksheet
        • System Liveboards
        • Falcon monitoring Liveboards
        • Object usage Liveboard
      • Troubleshooting
        • Get logs
        • Upload logs to ThoughtSpot Support
        • Generate a HAR file for ThoughtSpot Support
        • Network connectivity issues
        • Check the timezone
        • Browser untrusted connection error
        • Characters not displaying correctly
        • Clear the browser cache
        • Cannot open a saved answer that contains a formula
        • Data loading too slowly
        • Search results contain too many blanks
      • Disaster recovery
        • Disk failure
        • Node failure
        • HA and resilience
        • Cluster replacement
        • Mount a NAS file system
        • Configure disaster recovery
      • Architectural components
        • Data caching
        • Authentication
        • Data and object security
        • Performance considerations
        • In-memory data compression
      • Installation and setup
        • Set your locale
        • Test connectivity between nodes
        • ThoughtSpot use agreement
        • Allow users to request access
        • Set the relay host for SMTP
        • Set up custom calendars
        • Configure internal authentication
        • Configure SSL
        • Configure SAML
        • Configure SAML group mapping
        • Enable SSH through Active Directory
        • Integrate LDAP
          • Configure authentication through Active Directory
          • Add the SSL certificate for LDAP
          • Test the LDAP configuration
          • Sync users and groups from LDAP
        • OpenID Connect authentication
        • Configure NAS file system
        • Set up monitoring
        • Configure support services
        • Network ports
        • Configure load balancing and proxies
        • Customize look and feel
      • Manage users and groups
        • Onboarding users
        • Understand groups and privileges
        • Create, edit, or delete a group
        • Create, edit, or delete a user
        • Allow users to sign up
      • Security
        • ThoughtSpot lifecycle
        • System security
          • Tools and processes
            • Collect security logs
          • Third-party security software
            • Installing third-party software
        • Data security
          • Share tables and columns
          • Share worksheets
          • Share views
          • Share Liveboards
          • Share answers
          • Revoke access (unshare)
          • Security for SpotIQ functions
        • Row-level security (RLS)
          • How rule-based RLS works
          • Set rule-based RLS
        • Encryption of data in transit
      • Migration
        • Import and export TML files
        • TML: ThoughtSpot Modeling Language
        • Migrate multiple TML files
    • Mobile
      • Deploy
      • Install and set up
      • FAQ
      • Release notes
    • Embed ThoughtSpot
      • Embedding
      • Log in to the Linux shell using SSH
      • Use the JavaScript API
      • SAML
        • Configure SAML
        • Configure CA SiteMinder
        • Configure Active Directory Federated Services
      • Understand embedding
        • Embed Liveboard or visualization
        • Authentication flow with embed
        • Full application embedding
        • Configure trusted authentication
    • Runtime filters
      • Apply a runtime filter
      • Runtime filter operators
    • REST APIs
      • Get started
      • Calling the REST API
      • REST API pagination
      • Use the Data REST API to get data
      • Use the Embedded Search API
    • Deployment
      • Amazon Linux 2 deployments
        • Amazon Linux 2 prerequisites
        • ThoughtSpot deployment artifacts for Amazon Linux 2
        • Online Amazon Linux 2 install
        • Offline Amazon Linux 2 install
        • Amazon Linux 2 upgrade
        • Adding new nodes to clusters in Amazon Linux 2
        • Packages installed with Amazon Linux 2
      • RHEL and OEL support
        • RHEL and OEL prerequisites
        • ThoughtSpot deployment artifacts for RHEL and OEL
        • Online RHEL and OEL install
        • Offline RHEL and OEL install
        • RHEL and OEL upgrade
        • Add new nodes to clusters on RHEL or OEL
        • Packages installed with RHEL and OEL
      • Hardware appliance
        • Deploying on the SMC appliance
          • Prerequisites
          • Hardware requirements
          • Connect the appliance
          • Configure nodes
          • Install cluster
        • Deploying on the Dell appliance
          • Prerequisites
          • Hardware requirements
          • Connect the appliance
          • Configure management settings
          • Configure nodes
          • Install cluster
      • Cloud deployment
        • Cloud deployment on AWS
          • Set up AWS resources for ThoughtSpot
          • Prepare AWS VMs for ThoughtSpot
          • Configure ThoughtSpot nodes in AWS
          • Install ThoughtSpot clusters in AWS
          • Set up high availability
          • Back up and restore using S3
        • Cloud deployment on Microsoft Azure
          • Set up ThoughtSpot in Azure
          • Configure ThoughtSpot nodes in Azure
          • Install ThoughtSpot clusters in Azure
        • Cloud deployment on GCP
          • Set up ThoughtSpot in GCP
          • Configure ThoughtSpot nodes in GCP
          • Install ThoughtSpot clusters in GCP
          • Back up and restore a GCP cluster using GCS
      • VMware deployment
        • Set up ThoughtSpot in VMware
        • Configure ThoughtSpot nodes in VMware
        • Install ThoughtSpot clusters in VMware
      • Network ports
      • Upgrade your Python version
      • Consumption-based pricing
        • Query-based usage
          • User actions and queries
          • Subscription and rollover
        • Time-based usage
        • Consumption data storage
    • Connections
      • ThoughtSpot query tags
      • Amazon Redshift
        • Add a connection
        • Edit the connection
        • Remap the connection
        • Query external tables
        • Delete a table
        • Delete a table with dependencies
        • Delete the connection
        • Configure OAuth
        • Configure AWS Secrets Manager
        • Best practices
        • Reference
      • Azure Synapse
        • Add a connection
        • Edit the connection
        • Remap the connection
        • Delete a table
        • Delete a table with dependencies
        • Delete the connection
        • Configure OAuth
        • Reference
      • Databricks
        • Add a connection
        • Edit the connection
        • Remap the connection
        • Delete a table
        • Delete a table with dependencies
        • Delete the connection
        • Configure OAuth
        • Reference
      • Dremio
        • Add a connection
        • Edit the connection
        • Remap the connection
        • Delete a table
        • Delete a table with dependencies
        • Delete the connection
        • Configure OAuth
        • Reference
      • Google BigQuery
        • Prerequisites
        • Access levels and ingress rules for Google BigQuery
        • Add a connection
        • Edit the connection
        • Remap the connection
        • Query external tables
        • Delete a table
        • Delete a table with dependencies
        • Delete the connection
        • Reference
      • Oracle
        • Add a connection
        • Edit the connection
        • Remap the connection
        • Delete a table
        • Delete a table with dependencies
        • Delete the connection
        • Reference
      • SAP HANA
        • Add a connection
        • Edit the connection
        • Remap the connection
        • Delete a table
        • Delete a table with dependencies
        • Delete the connection
        • Reference
      • Snowflake
        • Add a connection
        • Edit the connection
        • Remap the connection
        • Query external tables
        • Delete a table
        • Delete a table with dependencies
        • Delete the connection
        • Configure OAuth
        • Configure Azure AD OAuth
        • Configure Okta OAuth
        • Best practices
        • Reference
        • Snowflake Partner Connect
          • Tutorials
      • Starburst
        • Add a connection
        • Edit the connection
        • Remap the connection
        • Delete a table
        • Delete a table with dependencies
        • Delete the connection
        • Reference
      • Teradata
        • Add a connection
        • Edit the connection
        • Remap the connection
        • Delete a table
        • Delete a table with dependencies
        • Delete the connection
        • Reference
      • Passthrough functions
      • Custom calendar
        • Create a custom calendar
        • Update a custom calendar
        • Delete a custom calendar
      • 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
    • DataFlow
      • Key features
        • Database connections
        • File System connections
        • Application connections
      • How DataFlow works
      • DataFlow home page
      • Requirements and guidelines
      • DataFlow security
        • DataFlow security reference
      • DataFlow tips
      • Administration of DataFlow
        • Manage DataFlow users with SSO
        • DataFlow mail setup
        • Other global properties
      • Amazon Aurora in DataFlow
        • Connect
        • Sync
        • Reference
      • Amazon Redshift in DataFlow
        • Connect
        • Sync
        • Reference
      • Amazon S3 in DataFlow
        • Connect
        • Sync
        • Reference
      • Azure Blob Storage in DataFlow
        • Connect
        • Sync
        • Reference
      • Azure Synapse in DataFlow
        • Connect
        • Sync
        • Reference
      • Cassandra in DataFlow
        • Connect
        • Sync
        • Reference
      • Databricks Delta Lake in DataFlow
        • Connect
        • Sync
        • Reference
      • Denodo in DataFlow
        • Connect
        • Sync
        • Reference
      • Dremio in DataFlow
        • Connect
        • Sync
        • Reference
      • Exadata in DataFlow
        • Connect
        • Sync
        • Reference
      • Flat Files in DataFlow
        • Connect
        • Sync
        • Reference
      • Google BigQuery in DataFlow
        • Connect
        • Sync
        • Reference
      • Google Cloud Storage in DataFlow
        • Connect
        • Sync
        • Reference
      • Google Sheets in DataFlow
        • Connect
        • Sync
        • Reference
      • Greenplum in DataFlow
        • Connect
        • Sync data
        • Reference
        • Utilities
      • HDFS in DataFlow
        • Connect
        • Sync
        • Reference
      • Hive in DataFlow
        • Connect
        • Sync
        • Reference
      • IBM Db2 in DataFlow
        • Connect
        • Sync
        • Reference
      • Impala in DataFlow
        • Connect
        • Sync
        • Reference
      • JDBC in DataFlow
        • Connect
        • Sync
        • Reference
      • MariaDB in DataFlow
        • Connect
        • Sync
        • Reference
      • MongoDB in DataFlow
        • Connect
        • Sync
        • Reference
      • MySQL in DataFlow
        • Connect
        • Sync
        • Reference
      • Memsql in DataFlow
        • Connect
        • Sync data
        • Reference
      • Netezza in DataFlow
        • Connect
        • Sync
        • Reference
      • Oracle in DataFlow
        • Connect
        • Sync
        • Reference
      • PostgreSQL in DataFlow
        • Connect
        • Sync
        • Reference
      • Presto in DataFlow
        • Connect
        • Sync
        • Reference
      • REST APIs in DataFlow
        • Connect
        • Sync
        • Reference
      • Salesforce in DataFlow
        • Connect
        • Sync
        • Reference
      • SAS in DataFlow
        • Connect
        • Sync
        • Reference
      • SAP Adaptive Server Enterprise in DataFlow
        • Connect
        • Sync
        • Reference
      • SAP HANA in DataFlow
        • Connect
        • Sync
        • Reference
      • SAP SQL Anywhere in DataFlow
        • Connect
        • Sync
        • Reference
      • SQL Server in DataFlow
        • Connect
        • Sync
        • Reference
      • Snowflake in DataFlow
        • Connect
        • Sync
        • Reference
      • Splice Machine in DataFlow
        • Connect
        • Sync
        • Reference
      • Splunk in DataFlow
        • Connect
        • Sync data
        • Reference
      • Teradata in DataFlow
        • Connect
        • Sync
        • Reference
      • Vertica in DataFlow
        • Connect
        • Sync
        • Reference
    • Data integration
      • JDBC and ODBC setup prerequisites
      • ODBC driver client
        • ODBC on Windows
          • Configure multiple connections on Windows
          • Deploy SSL with ODBC on Windows
          • Set up the ODBC Driver for SSIS
        • Install the ODBC Driver on Linux
        • Best practices for using ODBC
      • JDBC driver client
        • Use the JDBC driver
      • Set up the JDBC driver for Pentaho
      • Troubleshooting data integrations
        • Enable ODBC logs
        • Enable JDBC logs
        • Schema not found error with ODBC
        • How to improve throughput
        • ODBC tracing on Windows
        • SQL commands in ODBC and JDBC
        • Connection configuration for ODBC and JDBC
    • Reference
      • REST API reference
      • Keyword reference
        • Dansk: Danish keyword reference
        • Deutsch: German keyword reference
        • English (American) keyword reference
        • 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
        • Suomi: Finnish keyword reference
        • Svenska: Swedish keyword reference
        • 中文 (简体): Chinese (Simplified) keyword reference
        • 日本語: Japanese keyword reference
      • Data types
      • TQL reference
        • TQL service reference
      • tsload reference
        • tsload connector API reference
        • tsload flag reference
      • tscli command reference
      • Date and time formats reference
      • Row level security rules reference
      • Formula function reference
      • Alerts code reference
      • User action code reference
      • Stop word reference
      • Geo map reference
      • Glossary
      • Frequently asked questions
      • Deployment reference
        • Cable reference
        • Network ports
        • The nodes.config file
        • Parameters of the nodes.config file
        • Using the tscli cluster create command
        • Parameters of the tscli cluster create command
        • Site survey PDF
      • ThoughtSpot in practice
        • Reaggregation in practice
          • S1: Supplier tendering by job
          • S2: Average rates of exchange
          • S3: Average period for semi-additives I
          • S4: Average period for semi-additives II
        • Liveboard schedule gating conditions in practice
        • Add a hyperlink to a search
  • Cloud
    • 10.3.0.cl
    • 10.1.0.cl
    • 10.0.0.cl
    • 9.12.5.cl
  • Home
    • master
  • Mobile
    • 3.0.0
  • SeekWell
    • latest
  • Software
    • 9.8.0.sw
    • 9.5.0.sw
    • 9.0.1.sw
    • 8.8.sw
    • 8.4.sw
    • 7.2
    • 7.1
    • 7.0
    • 6.3
    • 6.2
    • 6.1
    • 6.0
  • Spotter
    • 10.4.0.cl
  • Software
  • Reference
  • tsload reference
9.8.0.sw 9.5.0.sw 9.0.1.sw 8.8.sw 8.4.sw 7.2 7.1 7.0 6.3 6.2 6.1 6.0

tsload reference

The tsload approach for data load has two primary references:

  • tsload connector API refrence

  • tsload flag reference

Was this page helpful?Give us feedback!
×

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

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