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
  • DataFlow
  • Flat Files in DataFlow
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