ThoughtSpot logo
Software
Cloud Mobile Spotter ThoughtSpot
Embedded SeekWell

Software

    • About this release
      • Release notes
      • Fixed issues
      • Downloads
    • Users
      • Introduction
      • Getting started
        • User onboarding experience
        • Finding your way around
        • ThoughtSpot browser access
        • Information Center
        • Your user preferences
        • Use stickers to organize
        • Privileges
          • Understanding privileges
      • Use search
        • What are searches and answers?
        • Search basics
          • 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
          • Migrate or restore answers
          • Answer TSL specification
          • Ask an expert
          • Manage Ask an Expert requests
          • Retrieve Ask an Expert answers
          • Answer an expert question
        • Results that are tables
        • Use keywords in search
          • Overview of keyword searches
          • Time series analysis
          • Search using growth over time
          • Using the "in" keyword for nested searches
          • Proximity search: "near" and "farther than"
        • Work with filters
          • Understand 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
          • Replay search
      • Work with charts
        • Chart types
          • Column charts
          • Bar charts
          • Line charts
          • Pie charts
          • Area charts
          • Scatter charts
          • Bubble charts
          • Pareto charts
          • Waterfall charts
          • Treemap charts
          • Line column charts
          • Funnel charts
          • Geo charts
          • Pivot table
          • Sankey charts
          • Radar charts
          • Candlestick charts
        • Changing charts
          • Change axes options
          • Configure the columns
          • Rename columns and axes
          • 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
      • Work with formulas
        • Understand formulas
        • Add a formula to search
        • View or edit a formula in a search
        • Aggregate formulas
          • Overview of aggregate formulas
          • Cumulative functions
          • Moving functions
          • Flexible aggregation functions (group aggregate and filters)
          • Grouping functions
          • Filtered aggregation functions
        • Conversion functions
        • Date functions
        • Percent (simple number) calculations
        • Formula operators
        • Nested formulas
        • Formulas for chasm traps
      • Use pinboards
        • Basic pinboard usage
        • Follow a pinboard
        • Edit a pinboard
        • Pinboard filters
        • Answer explorer
        • Schedule a pinboard job
        • Search actions within a pinboard
        • Copy a pinboard
        • Copy a pinboard or visualization link
        • Reset a pinboard or visualization
        • Present a pinboard as a slideshow
        • Download as PDF
        • Migrate or restore pinboards
        • Pinboard TSL specification
      • Use custom R scripts
        • About R in ThoughtSpot
        • Create and share R scripts
        • Run prebuilt R scripts on answers
        • Save and share R visualizations
      • SpotIQ
        • What is SpotIQ
        • Best practices
        • Monitor headlines
        • Comparative analysis
        • Custom SpotIQ analysis
        • Advanced R customizations
        • Insight feedback
        • SpotIQ preferences
      • Work with data
        • Understand data sources
        • Create and load CSV files
        • Append data through the UI
        • View a data profile
        • Set your ThoughtSpot locale
        • Share your work
          • About sharing
          • Share a pinboard
          • Share answers
          • Share uploaded data
          • Request object access
          • Revoke access (unshare)
      • Use SearchIQ
        • About SearchIQ
        • Use SearchIQ for natural searches
        • Teach SearchIQ your language
      • More help and support
    • Administration
      • Introduction to administration
      • Sign-in credentials for administration
      • Understand the architecture
        • Architectural components
        • Data caching
        • Authentication frameworks
        • Data and object security
        • Performance considerations
        • In-memory data compression
      • Admin console
        • Overview
        • Managing users
        • Managing groups
        • Local authentication
        • Authentication through SAML
        • Authentication through Active Directory
        • Configure SSL
        • Configure a reverse SSH tunnel
        • Set the relay host for SMTP (email)
        • Customize ThoughtSpot help
        • Customize actions
        • Style customization
        • Configure NAS for backup storage
        • Manage and create snapshots
        • System overview pinboard
        • System cluster pinboard
        • System alerts pinboard
        • Available cluster updates
      • Installation and setup
        • About installation and upgrades
        • 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
        • Enable SSH through Active Directory
        • Integrate LDAP
          • About LDAP integration
          • Configure authentication through Active Directory
          • Add the SSL certificate for LDAP
          • Test the LDAP configuration
          • Sync users and groups from LDAP
        • Configure NAS file system
        • Set up monitoring
        • Configure support services
        • Network ports
        • Configure load balancing and proxies
        • Customize ThoughtSpot help
        • Customize look and feel
      • Load and manage data
        • Introduction to data management
        • Configure casing
        • Load CSV files with the UI
        • How to view a data schema
        • Plan the schema
          • About schema planning
          • Data types
          • Constraints
          • Sharding
          • Chasm traps
        • Build the schema
          • Schema building overview
          • Connect with TQL and create a schema
          • Create a schema in SQL
          • Examples of schema creation
          • Upload a SQL script
        • Change the schema
          • How to change a schema
          • Convert column data type
        • Load bulk data
          • Import CSV files with tsload
          • Use a script
          • Use the tsload connector
        • Delete a data source
          • Delete a data source (table)
          • Delete or change a table in TQL
      • 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
        • Overview of security features
        • System security
          • Tools and processes
          • About third-party software
          • Installing third-party software
        • Data security
          • Data security
          • Share tables and columns
          • Share worksheets
          • Share views
          • Share pinboards
          • Share answers
          • Revoke access (unshare)
          • Security for SpotIQ functions
        • Row level security (RLS)
          • About row level security (RLS)
          • How rule-based RLS works
          • Set rule-based RLS
        • ThoughtSpot Lifecycle
        • Encryption of data in transit
      • System administration
        • Overview of system administration
        • Send logs when reporting problems
        • Set up recording for Replay Search
        • Upgrade a cluster
      • Backup and restore
        • Understand the backup strategies
        • Understand backup/snapshot schedules
        • Work with snapshots
        • Work with backups
          • Understand backup modes
          • Create a manual backup
          • Configure periodic backups
          • About restore operations
      • Improve search with modeling
        • About data modeling
        • Change a table’s data model
        • Edit the system-wide data model
        • Data model settings
          • Overview of the settings
          • Set column name, description, and type
          • Set additive and aggregate values
          • Hide a column or define a synonym
          • Set columns to exclude from SpotIQ analyses
          • Manage suggestion indexing
          • Add a geographical data setting
          • Set number, date, currency formats
          • Change the attribution dimension setting
          • Add or manage experts
        • Link tables using relationships
          • Link tables using relationships
          • Create a relationship
          • Delete a relationship
          • Use stickers
      • Worksheets: improve search
        • Create and use worksheets
        • Edit a worksheet
        • Create a formula in a worksheet
        • Create worksheet filters
        • How the worksheet join rule works
        • Change 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 TSL specification
      • Work with views
        • Understand views
        • Save a search as a view
        • Create a search from a view
        • View example scenarios
        • About materialized views
        • Materialize a view
        • Dematerialize a view
        • Refresh a view
        • Schedule view refreshes
      • Scriptability
        • Overview
        • Migrate or restore worksheets
        • Worksheet TSL specification
        • Migrate or restore pinboards
        • Pinboard TSL specification
        • Migrate or restore answers
        • Answer TSL specification
        • SpotApps
      • Set up SearchIQ
        • Enable SearchIQ
        • Optimize SearchIQ
        • SearchIQ optimization steps
          • Enabling columns in SearchIQ
          • Add experts for SearchIQ
          • Train SearchIQ
        • Set entity categories for SearchIQ
        • Change SearchIQ mappings
      • Managed scheduled jobs
        • Job management (scheduled pinboards)
        • Scheduled pinboards management
      • Monitoring
        • Introduction to monitoring
        • Overview board
        • Data board
        • Cluster manager board
        • Alerts and events board
        • System worksheets
          • TS:BI Server workhseet
        • System pinboards
        • Falcon monitoring pinboards
      • Troubleshooting
        • About troubleshooting
        • Get logs
        • Upload logs to 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
    • Mobile
      • Overview
      • Deploy
      • Install and set up
      • FAQ
      • Release notes
    • Embedding
      • Introduction to embedding
      • Log in to the Linux shell using SSH
      • Login credentials
      • Use the JavaScript API
      • SAML
        • About SAML
        • Configure SAML
        • Configure CA SiteMinder
        • Configure Active Directory Federated Services
      • REST API
        • About the REST API
        • Calling the REST API
        • REST API pagination
        • Use the data REST API to get data
        • Use the embedded search API
        • Use the data push API
      • Embed ThoughtSpot
        • Understand embedding
        • Embed pinboard or visualization
        • Authentication flow with embed
        • Full application embedding
        • Configure trusted authentication
      • Runtime filters
        • About runtime filters
        • Apply a runtime filter
        • Runtime filter operators
      • Style customization
        • Customize the application style
        • Upload application logos
        • Set chart and table visualization fonts
        • Choose a background color
        • Select chart color palettes
        • Change the footer text
      • API reference
        • Introduction
        • Pinboard data API
        • Metadata API
        • Session API
        • User API
        • Group API
        • Materialization API
        • Search data API
    • Deploy
      • Overview
      • Amazon Linux 2 support
        • Amazon Linux 2 overview
        • 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 support
        • RHEL overview
        • RHEL prerequisites
        • ThoughtSpot deployment artifacts for RHEL
        • Online RHEL install
        • Offline RHEL install
        • RHEL upgrade
        • Add new nodes to clusters on RHEL
        • Packages installed with RHEL
      • Hardware appliance
        • Hardware appliance overview
        • Deploying on the SMC appliance
          • Deploying on the SMC appliance
          • Prerequisites
          • Hardware requirements
          • Connect the appliance
          • Configure nodes
          • Install cluster
        • Deploying on the Dell appliance
          • Deploying on the Dell appliance
          • Prerequisites
          • Hardware requirements
          • Connect the appliance
          • Configure management settings
          • Configure nodes
          • Install cluster
      • Cloud
        • Cloud overview
        • AWS
          • Configuration options
          • 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
        • Azure
          • Configuration options
          • Set up ThoughtSpot in Azure
          • Configure ThoughtSpot nodes in Azure
          • Install ThoughtSpot clusters in Azure
        • GCP
          • Configuration options
          • 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
        • Configuration overview
        • Set up ThoughtSpot in VMware
        • Configure ThoughtSpot nodes in VMware
        • Install ThoughtSpot clusters in VMware
      • Network ports
      • Contact support
    • Embrace
      • Overview
      • Snowflake
        • Overview
        • Add a connection
        • Modify a connection
        • Best practices
        • Reference
        • Snowflake Partner Connect
          • Overview
          • Tutorials
      • Amazon Redshift
        • Overview
        • Add a connection
        • Modify a connection
        • Best practices
        • Reference
      • Google BigQuery
        • Overview
        • Add a connection
        • Modify a connection
        • Reference
      • Azure Synapse
        • Overview
        • Add a connection
        • Modify a connection
        • Reference
      • Teradata
        • Overview
        • Add a connection
        • Modify a connection
        • Reference
      • SAP HANA
        • Overview
        • Add a connection
        • Modify a connection
        • Reference
    • Dataflow
      • Overview
      • Key features
      • How DataFlow works
      • DataFlow home page
      • Requirements and guidelines
      • DataFlow security
        • DataFlow encryption reference
      • Database connections
        • Supported database connections
        • Amazon Aurora
          • Overview
          • Connect
          • Sync
          • Reference
        • Amazon Redshift
          • Overview
          • Connect
          • Sync
          • Reference
        • Azure Synapse
          • Overview
          • Connect
          • Sync
          • Reference
        • Cassandra
          • Overview
          • Connect
          • Sync
          • Reference
        • Google BigQuery
          • Overview
          • Connect
          • Sync
          • Reference
        • Hive
          • Overview
          • Connect
          • Sync
          • Reference
        • IBM Db2
          • Overview
          • Connect
          • Sync
          • Reference
        • MariaDB
          • Overview
          • Connect
          • Sync
          • Reference
        • MongoDB
          • Overview
          • Connect
          • Sync
          • Reference
        • MySQL
          • Overview
          • Connect
          • Sync
          • Reference
        • Netezza
          • Overview
          • Connect
          • Sync
          • Reference
        • Oracle
          • Overview
          • Connect
          • Sync
          • Reference
        • PostgreSQL
          • Overview
          • Connect
          • Sync
          • Reference
        • Presto
          • Overview
          • Connect
          • Sync
          • Reference
        • SAP Adaptive Server Enterprise
          • Overview
          • Connect
          • Sync
          • Reference
        • SAP HANA
          • Overview
          • Connect
          • Sync
          • Reference
        • SAP SQL Anywhere
          • Overview
          • Connect
          • Sync
          • Reference
        • SQL Server
          • Overview
          • Connect
          • Sync
          • Reference
        • Snowflake
          • Overview
          • Connect
          • Sync
          • Reference
        • Splice Machine
          • Overview
          • Connect
          • Sync
          • Reference
        • Teradata
          • Overview
          • Connect
          • Sync
          • Reference
      • File system connections
        • Supported file system connections
        • Amazon S3
          • Overview
          • Connect
          • Sync
          • Reference
        • Azure Blob Storage
          • Overview
          • Connect
          • Sync
          • Reference
        • Flat Files
          • Overview
          • Connect
          • Sync
          • Reference
        • Google Cloud Storage
          • Overview
          • Connect
          • Sync
          • Reference
        • HDFS
          • Overview
          • Connect
          • Sync
          • Reference
      • Application connections
        • Supported application connections
        • Salesforce
          • Overview
          • Connect
          • Sync
          • Reference
      • Administration
        • Administration overview
        • Manage DataFlow users
        • DataFlow mail setup
    • Data integration
      • Introduction to data integration
      • JDBC and ODBC setup prerequisites
      • ODBC driver client
        • ODBC driver overview
        • ODBC on Windows
          • Install the ODBC driver 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
        • JDBC driver overview
        • Use the JDBC driver
      • Set up the JDBC driver for Pentaho
      • Troubleshooting
        • Troubleshooting data integrations
        • Enable ODBC logs
        • Enable JDBC logs
        • Schema not found error with ODBC
        • How to improve throughput
        • ODBC tracing on Windows
      • Reference
        • Supported SQL commands
        • Connection configuration
    • Disaster recovery
      • About disaster recovery
      • Disk failure
      • Node failure
      • HA and resilience
      • Cluster replacement
        • Overview of cluster replacement
        • Mount a NAS file system
        • Configure disaster recovery
    • Reference
      • About this reference
      • Keyword reference
        • Dansk: Danish keyword reference
        • Deutsch: German 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 keyword reference
        • 日本語: Japanese keyword reference
      • TQL reference
      • tsload flag reference
      • tsload connector 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
        • Introduction
        • Reaggregation in practice
        • Pinboard schedule gating conditions in practice
  • 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
  • Dataflow
  • File system connections
  • Flat Files
  • Overview
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

Flat file connections in DataFlow

DataFlow enables you to connect to both local and remote flat files, to use your data in ThoughtSpot.

  • Add a connection

  • Sync data

  • 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