SQL Commands for Tableau Hyper API

Applies to: ❌ Data 360 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.

Data 360 REST API Reference
Data 360 SQL Reference
Data 360 SQL and Tableau Hyper API
Data 360 SQL Syntax
Data Types
Scalar Functions
Aggregate Functions
Window Functions
Set Returning Functions
SQL Commands for Tableau Hyper API
External File Support
INSERT
UPDATE
DELETE
TRUNCATE
COPY FROM
COPY TO
CREATE DATABASE
CREATE SCHEMA
CREATE TABLE
CREATE TABLE AS
CREATE EXTERNAL TABLE
ALTER SCHEMA
ALTER TABLE
DROP TABLE
DROP SCHEMA
DROP DATABASE
EXPLAIN
PREPARE
EXECUTE
DEALLOCATE

DID THIS ARTICLE SOLVE YOUR ISSUE?
Let us know so we can improve!