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
Legacy Documentation
Legacy Documentation
Resources
Developer Site Community Forum Knowledge Base
Download
TG Savanna

GSQL Language Reference

    • Query Language Tutorials
      • What sets GSQL apart
      • GSQL V3 Tutorial
      • Accumulators Tutorial
      • TigerGraph OpenCypher
      • Hybrid Vector Search
    • Running GSQL
    • Defining a Schema
      • Data Types
      • Define a Graph Schema
      • Modify a Graph Schema
    • Loading Data
      • 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 Choices
    • Create and Run Queries
      • Distributed Query Mode
    • GSQL Language
      • GSQL Syntax Versions
      • Data Types
      • Accumulators
      • SELECT Statement
        • SELECT Statement (Syntax V1)
        • SQL-like SELECT statement
      • 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
      • Control Flow
      • Updating Data
      • Writing Output
        • Write Output to Cloud
      • Exception Statements
      • Comments
    • Profile and Optimize
      • Query Plan Cache
      • Query Profiling
      • Query Optimizer (Preview)
        • Enable Query Optimizer
        • Statistics REST APIs
    • openCypher in GSQL
      • Writing and Running openCypher in GSQL Shell
      • openCypher Pattern Support in GSQL
    • Vector Searches
    • Appendix
      • Common Errors and Problems
      • DLL Keywords & Reserved Words
      • Documentation Notation
      • Example Graphs
      • GSQL Cheat Sheets
      • GSQL Start-to-End Process and Data Flow
      • GSQL Style Guide
      • Interpreted GSQL Limitations
      • Legacy Version Documentation
      • Query Language Keywords & Reserved Words
GSQL Language Reference 4.2 Pre
    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 CoPilot

  • 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.2 Pre
  • 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