SQL Commands for Tableau Hyper API

Applies to: ❌ Data Cloud SQL ✅ Tableau Hyper API

Check out these SQL commands that perform write operations.

For more information about write operations in Tableau Hyper API, see Execute SQL Commands.

The Hyper API SQL commands can be grouped into these categories:

  1. Data modification commands: Using INSERT, UPDATE, DELETE, and TRUNCATE, one can change the data stored inside a table. Furthermore, COPY FROM copies data directly from an external file (e.g., a CSV or Parquet file) into a table. When combined with SELECT queries, one can also use those commands to, e.g., materialize the results of complex analytical computations.
  2. Data definition commands: Data Cloud SQL supports commands to create databases, tables and modify ("alter") and delete ("drop") them.
  3. Support statements for prepared statements: PREPARE can pre-compile a query, including placeholder parameters. A prepared query can later on be executed through EXECUTE, giving specific values for the parameters. DEALLOCATE deallocates a given query.