Dataiku Documentation
  • Discussions
    • Setup & Configuration
    • Using Dataiku DSS
    • Plugins & Extending Dataiku DSS
    • General Discussion
    • Job Board
    • Community Resources
    • Product Ideas
  • Knowledge
    • Getting Started
    • Knowledge Base
    • Documentation
  • Academy
    • Quick Start Programs
    • Learning Paths
    • Certifications
    • Course Catalog
    • Academy Discussions
  • Community Programs
    • Upcoming User Events
    • Find a User Group
    • Past Events
    • Community Conundrums
    • Dataiku Neurons
    • Banana Data Podcast
  • What's New
  • User's Guide
  • DSS concepts
  • Connecting to data
    • Supported connections
    • SQL databases
    • Amazon S3
    • Azure Blob Storage
    • Google Cloud Storage
    • Upload your files
    • HDFS
    • Cassandra
    • MongoDB
    • Elasticsearch
    • File formats
      • Delimiter-separated values (CSV / TSV)
      • Fixed width
      • Parquet
      • Avro
      • Hive ORCFile
      • XML
      • JSON
      • Excel
      • ESRI Shapefiles
      • Delta Lake
    • Managed folders
    • “Files in folder” dataset
    • Metrics dataset
    • Internal stats dataset
    • “Editable” dataset
    • kdb+
    • FTP
    • SCP / SFTP (aka SSH)
    • HTTP
    • HTTP (with cache)
    • Server filesystem
    • Dataset plugins
    • Making relocatable managed datasets
    • Clearing non-managed Datasets
    • Data ordering
    • PI System / PIWebAPI server
    • Data transfer on Dataiku Cloud
  • Exploring your data
  • Schemas, storage types and meanings
  • Data preparation
  • Charts
  • Interactive statistics
  • Machine learning
  • The Flow
  • Visual recipes
  • Recipes based on code
  • Code notebooks
  • MLOps
  • Webapps
  • Code Studios
  • Code reports
  • Dashboards
  • Workspaces
  • Dataiku Applications
  • Working with partitions
  • DSS and SQL
  • DSS and Python
  • DSS and R
  • DSS and Spark
  • Code environments
  • Collaboration
  • Specific Data Processing
  • Time Series
  • Geographic data
  • Text & Natural Language Processing
  • Images
  • Audio
  • Video
  • Automation & Deployment
  • Automation scenarios, metrics, and checks
  • Production deployments and bundles
  • API Node & API Deployer: Real-time APIs
  • Governance
  • APIs
  • Python APIs
  • R API
  • Public REST API
  • Additional APIs
  • Installation & Administration
  • Installing and setting up
  • Elastic AI computation
  • DSS in the cloud
  • DSS and Hadoop
  • Metastore catalog
  • Operating DSS
  • Security
  • User Isolation
  • Other topics
  • Plugins
  • Streaming data
  • Formula language
  • Custom variables expansion
  • Sampling methods
  • Accessibility
  • Troubleshooting
  • Release notes
  • Other Documentation
  • Third-party acknowledgements
Dataiku DSS
You are viewing the documentation for version 11 of DSS.
  • »
  • Connecting to data »
  • File formats

File formats¶

Datasets based on files require a file input format.

This section contains detailed information on the supported formats and options.

  • Delimiter-separated values (CSV / TSV)
    • Quoting and escaping styles
      • Excel-style
        • Example
      • Unix-style
        • Example
      • Escaping only
        • Example
      • No escaping, no quoting
    • Usage in datasets
    • Usage in recipes
  • Fixed width
  • Parquet
    • Requirements
    • Applicability
    • Limitations and issues
      • Case-sensitivity
      • Related to Hive
      • Related to Impala
      • Misc
  • Avro
    • Applicability
      • Reading Avro files
      • Reading Avro files / multiple versions
      • Writing Avro files
  • Hive ORCFile
    • Compatibility
    • Limitations
  • XML
    • Handling the structure
      • Selection of the data to load
      • JSON representation
        • Example
    • Using XPath to select data
      • Limitations
      • Selecting values explicitly
        • Example
  • JSON
    • Example
  • Excel
  • ESRI Shapefiles
    • Vecmath library
  • Delta Lake
Next Previous

© Copyright 2022, Dataiku

Built with Sphinx using a theme provided by Read the Docs.