TigerGraph Logo Docs
Products
TigerGraph Server
TigerGraph DB
TigerGraph Suite
GraphStudio and Admin Portal Insights GSQL Web Shell
GSQL
GSQL Language Reference
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 JDBC Driver
Legacy Documentation
Legacy Documentation
Resources
Developer Site Community Forum Knowledge Base
Download
TG Cloud

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 (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
      • 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.8
  • TigerGraph Cloud
  • TigerGraph Cloud 4.0
  • TigerGraph DB
    • 4.1 Pre
    • 3.10
    • 3.9
    • 3.8
    • 3.7
    • 3.6
    • 3.5
    • 3.4
    • 3.3
    • 3.2
  • GSQL Language Reference
    • 4.1 Pre
    • 3.10
    • 3.9
    • 3.8
    • 3.7
    • 3.6
    • 3.5
    • 3.4
    • 3.3
    • 3.2
  • GraphStudio and Admin Portal
    • 4.1 Pre
    • 3.10
    • 3.9
    • 3.8
    • 3.7
    • 3.6
    • 3.5
    • 3.4
    • 3.3
    • 3.2
  • Insights
    • 4.1 Pre
    • 3.10
    • 3.9
    • 3.8
    • 3.7
  • TigerGraph Graph Data Science Library
    • 3.9 LTS
    • 3.8
    • 3.7
  • pyTigerGraph
    • 1.6
    • 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
    • 3.8
    • 3.7
  • TigerGraph CoPilot
    • main
  • GSQL Language Reference
  • Database Definition & Loading
Edit this Page

Database Definition & Loading

GSQL Database Definition & Loading (DDL) Language allows you to create graphs, modify graph schemas, and load data into graphs.

The statements and clauses of the DDL language are organized into four topics, which describe the typical workflow for working with data definition and loading:

  1. Defining a graph schema

  2. Modifying a graph schema

  3. Creating a loading job

  4. Running a loading job

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