TigerGraph Logo Docs
Products
TigerGraph Savanna
TigerGraph Savanna (TigerGraph Cloud Classic)
TigerGraph Server
TigerGraph DB
TigerGraph Suite
GraphStudio and Admin Portal Insights GSQL Web Shell
Query Languages
GSQL Language Reference GSQL Web Shell OpenCypher
AI & Graph Intelligence
Graph Data Science Library Hybrid Graph+Vector Search
Connectors and APIs
Data Connectors pyTigerGraph TigerGraph GraphQL Service JDBC Driver
Resources
Developer Site Community Forum Knowledge Base
Download
TG Savanna

GSQL Language Reference

    • Overview
    • What sets GSQL apart
    • GSQL Tutorials
      • GSQL V3 Tutorial
      • Accumulators Tutorial
    • System & Language Basics
    • Attribute Data Types
    • Schema Definition
      • Define a Graph Schema
      • Modify a Graph Schema
    • Loading Jobs
      • Create a Loading Job
        • Functions
          • Token Functions
            • flatten()
            • flatten_json_array()
            • gsql_concat()
            • gsql_current_time_epoch()
            • gsql_day()
            • gsql_day_epoch()
            • gsql_find()
            • gsql_length()
            • gsql_lower()
            • gsql_ltrim()
            • gsql_month()
            • gsql_month_epoch()
            • gsql_regex_match()
            • gsql_regex_replace()
            • gsql_reverse()
            • gsql_rtrim()
            • gsql_substring()
            • gsql_to_bool()
            • gsql_to_int()
            • gsql_to_uint()
            • gsql_trim()
            • gsql_ts_to_epoch_seconds()
            • gsql_upper()
            • gsql_uuid_v4()
            • gsql_year()
            • gsql_year_epoch()
            • split()
          • Token Functions in WHERE Clause
            • concat()
            • gsql_is_false()
            • gsql_is_not_empty()
            • gsql_is_true()
            • gsql_token_equal()
            • gsql_token_ignore_case_equal()
            • to_float()
            • to_int()
            • token_len()
          • Reducer functions
            • add()
            • and()
            • ignore_if_exists()
            • max()
            • min()
            • or()
        • Add a User-defined Token Function
      • Run a Loading Job
      • Manage Loading Jobs
    • Querying
      • Query Language Syntax Versions
      • Queries
      • Query Optimizer (Preview Feature)
        • Enabling Cost-Based Optimization (Preview Feature)
        • Statistics REST APIs (Preview Feature)
      • Distributed Query Mode
      • Data Types
      • Accumulators
      • Operators and Expressions
      • Functions
        • Aggregation Functions
        • Context Functions
        • Datetime Functions
        • Edge Methods
        • JSON Object Methods
        • JSON Array Methods
        • List Functions
        • Mathematical Functions
        • Miscellaneous Functions
        • Query User-Defined Functions
        • String Functions
        • Type Conversion Functions
        • Vector Functions
        • Vertex Functions
      • Declaration and Assignment Statements
      • SELECT Statement
        • SELECT Statement (Syntax V1)
        • SQL-like SELECT statement
      • Control Flow Statements
      • Data Modification Statements
      • Output Statements and FILE Objects
      • Exception Statements
      • Comments
      • Write Query Output to Cloud
    • openCypher
      • OpenCypher Tutorial (on GitHub)
      • openCypher in GSQL
      • Writing and Running openCypher in GSQL Shell
      • openCypher Pattern Support in GSQL
    • Appendix
      • GSQL Style Guide
      • DDL Keywords & Reserved Words
      • Query Language Keywords & Reserved Words
      • Interpreted GSQL Limitations
      • GSQL Start-to-End Process and Data Flow
      • Example Graphs
      • Common Errors and Problems
      • GSQL Cheat Sheets
      • Documentation Notations
    • Legacy Version Documentation
GSQL Language Reference 4.1
    Fully-Managed: Savanna

    Self-Managed: TigerGraph DB
    Install Manage


    Tutorials & Guides
    GSQL OpenCypher in GSQL Hybrid Vector Search

    Reference Manuals
    GSQL OpenCypher Vector REST APIs Configuration Parameters

    Visual Tools
    Develop: GraphStudio Administer: Admin Portal Visualize: Insights

    AI & Data Science
    Graph Algorithms pyTigerGraph TigerGraphX ML Workbench AI Toolkit

  • TigerGraph DB
    • 4.2 Pre
    • 4.1
    • 3.11
    • 3.10
    • 3.9
    • 3.6
  • GSQL Language Reference
    • 4.2 Pre
    • 4.1
    • 3.11
    • 3.10
    • 3.9
    • 3.6
  • TigerGraph Savanna
  • GraphStudio and Admin Portal
    • 4.2 Pre
    • 4.1
    • 3.11
    • 3.10
    • 3.9
    • 3.6
  • Insights
    • 4.2 Pre
    • 4.1
    • 3.11
    • 3.10
    • 3.9
  • Graph Data Science Library
    • 3.10
  • pyTigerGraph
    • 1.8
    • 1.7
    • 1.6
  • TigerGraph ML Workbench
    • 1.4
  • TigerGraph GraphQL Service
    • 3.9
  • TigerGraph CoPilot
    • main
  • TigerGraph Cloud Classic
  • GSQL Language Reference 4.1
  • Appendix
  • GSQL Cheat Sheets
Edit this Page

GSQL Cheat Sheets

This page provides two cheat sheets for GSQL:

  • Database Definition & Loading

  • Querying

The cheat sheets are updated for TigerGraph v3.1.

3 Twin Dolphin Drive, Ste 225
Redwood City, CA 94065

Copyright © 2025 TigerGraph

  • Resources

    • Support
    • Community
    • Developer Site
    • Test Drive
  • Social

    • Linkedin
    • Facebook
    • Twitter
  • Legal

    • Privacy Policy
    • Terms of Use
    • Sitemap