📄️ 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.