TigerGraph Logo Docs
Products
TigerGraph Server
TigerGraph Server
TigerGraph Suite
GraphStudio and Admin Portal TigerGraph Insights GSQL Web Shell
GSQL
GSQL Language Reference
TigerGraph Cloud
TigerGraph Cloud
Graph Data Science
TigerGraph Graph Data Science Library TigerGraph ML Workbench
Connectors and APIs
pyTigerGraph TigerGraph GraphQL Service JDBC Driver
Legacy Documentation
Legacy Documentation
Resources
Developer Site Community Forum Knowledge Base
Start Free
  • 3.9 LTS
  • 3.8
  • 3.7
  • 3.6 LTS
  • 3.5
  • 3.4
  • 3.3
  • 3.2

GSQL Language Reference

    • Overview
    • Tutorials
      • GSQL 101
        • Define a Schema
        • Load Data
        • Run Built-in Queries
        • Parameterized Queries
        • Review
      • Pattern Matching Tutorial
        • Prepare your Environment
        • One-hop patterns
        • Repeating a 1-Hop Pattern
        • Multiple Hop Patterns and Accumulation
        • Example - A Recommender
        • Advanced Features
          • Per Clause (Beta)
          • Conjunctive Pattern Matching (Beta)
          • Data Modification
        • Summary
      • Accumulators Tutorial
    • System & Language Basics
    • Database Definition & Loading
      • Attribute Data Types
      • Defining a Graph Schema
      • Modifying a Graph Schema
      • Creating 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
      • Running a Loading Job
      • Managing and Inspecting a Loading Job
    • Querying
      • Query Language Syntax Versions
      • Queries
      • Query Optimizer
        • Enabling Cost-Based Optimization
        • Statistics REST APIs
      • Distributed Query Mode
      • Data Types
      • Accumulators
      • Operators and Expressions
      • Functions
        • Aggregation Functions
        • Datetime Functions
        • Edge Methods
        • JSON Object Methods
        • JSON Array Methods
        • Mathematical Functions
        • Miscellaneous Functions
        • Query User-Defined Functions
        • String Functions
        • Type Conversion 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
    • Appendix
      • GSQL Style Guide
      • DDL Keywords & Reserved Words
      • Query Language Keywords & Reserved Words
      • Formal Grammar for Query Language
      • Interpreted GSQL Limitations
      • GSQL Start-to-End Process and Data Flow
      • Example Graphs
      • Common Errors and Problems
      • GSQL Cheat Sheets
      • Documentation Notations
GSQL Language Reference 3.9 LTS
  • TigerGraph Cloud
  • TigerGraph Server
    • 3.9 LTS
    • 3.8
    • 3.7
    • 3.6 LTS
    • 3.5
    • 3.4
    • 3.3
    • 3.2
  • GSQL Language Reference
    • 3.9 LTS
    • 3.8
    • 3.7
    • 3.6 LTS
    • 3.5
    • 3.4
    • 3.3
    • 3.2
  • GraphStudio and Admin Portal
    • 3.9 LTS
    • 3.8
    • 3.7
    • 3.6 LTS
    • 3.5
    • 3.4
    • 3.3
    • 3.2
  • TigerGraph Insights
    • 3.9 LTS
    • 3.8
    • 3.7
  • TigerGraph Graph Data Science Library
    • 3.9 LTS
    • 3.8
    • 3.7
  • pyTigerGraph
    • 1.5
    • 1.4
    • 1.3
    • 1.2
    • 1.1
    • 1.0
  • TigerGraph ML Workbench
    • 1.4
    • 1.3
    • 1.2
    • 1.1
  • TigerGraph GraphQL Service
    • 3.9 LTS
    • 3.8
    • 3.7
  • GSQL Language Reference
  • 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 © 2023 TigerGraph

  • Resources

    • Support
    • Community
    • Developer Site
    • Test Drive

  • Social

    • Linkedin
    • Facebook
    • Twitter

  • Legal

    • Privacy Policy
    • Terms of Use
    • Sitemap