Guides

📄️ Execute SQL Commands

Hyper API is a wrapper around Hyper, a full-fledged SQL database.

📄️ Using Hyper with Pandas

If you want to use Hyper API together with pandas, the pantab library has you covered.

📄️ Create and Update Hyper Files

Hyper stores its tables in .hyper files. Using Hyper API, you can create .hyper files and then insert, delete, update, and read data from those files.

📄️ Read Data from Hyper Files

To read data from a .hyper file, open a Connection to the file and

📄️ Insert Data Directly from CSV Files

Comma-separated values (CSV) are a popular file format to import and export tabular data from programs. Hyper is able to directly load data into a Hyper table. Using the PostgreSQL-like COPY FROM command, you can copy the data much faster than you could by iteratively adding the data one row at a time.

📄️ Add Spatial Data to a Hyper File

Tableau supports spatial data (geography) in .hyper files.

📄️ Optimize Hyper File Storage

Hyper files (.hyper) store data in a proprietary, optimized database format.

📄️ Publish to Tableau Cloud / Server

When you are ready to make your Hyper file available to other users, you can publish it to Tableau Server or Tableau Cloud.