TigerGraph Logo Docs
Products
TigerGraph Server
TigerGraph DB 4.1 Preview
TigerGraph Suite
GraphStudio and Admin Portal 4.1 Insights GSQL Web Shell
GSQL
GSQL Language Reference 4.1
TigerGraph Cloud
TigerGraph Cloud TigerGraph Cloud 4.0 New
Graph Data Science
TigerGraph Graph Data Science Library TigerGraph ML Workbench TigerGraph CoPilot
Connectors and APIs
pyTigerGraph TigerGraph GraphQL Service 3.9 JDBC Driver
Legacy Documentation
Legacy Documentation
Resources
Developer Site Community Forum Knowledge Base
Download
TG Cloud

GSQL Language Reference 3.11

    • Overview
    • What sets GSQL apart
    • 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
    • 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
        • 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
        • Context 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
    • openCypher
      • 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
      • 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
    • Legacy Version Documentation
GSQL Language Reference 4.1 3.11 Pre
  • TigerGraph DB 4.1 Preview
    • 4.1 Pre
    • 3.11 Pre
    • 3.10
    • 3.9
    • 3.6
  • GSQL Language Reference 4.1
    • 4.1 Pre
    • 3.11 Pre
    • 3.10
    • 3.9
    • 3.6
  • TigerGraph Cloud
  • TigerGraph Cloud 4.0
  • GraphStudio and Admin Portal 4.1
    • 4.1 Pre
    • 3.11 Pre
    • 3.10
    • 3.9
    • 3.6
  • Insights
    • 4.1 Pre
    • 3.11 Pre
    • 3.10
    • 3.9
  • TigerGraph Graph Data Science Library
    • 3.10
  • pyTigerGraph
    • 1.7
    • 1.6
    • 1.5
  • TigerGraph ML Workbench
    • 1.4
  • TigerGraph GraphQL Service 3.9
    • 3.9
  • TigerGraph CoPilot
    • main
  • GSQL Language Reference 3.11
  • 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 © 2024 TigerGraph

  • Resources

    • Support
    • Community
    • Developer Site
    • Test Drive

  • Social

    • Linkedin
    • Facebook
    • Twitter

  • Legal

    • Privacy Policy
    • Terms of Use
    • Sitemap