[OLD] SnowConvert - LIMITED ACCESS

SnowConvert Translation Reference
Licensing
Download and Access
For Teradata
- Translation Reference
For Oracle
- Translation Reference
For SQL Server
- Translation Reference
ANSI SQL
- Translation Reference
  - Data Types
    Interval
  - Statements
    CREATE TABLE
    Basic Table
    Table Scope
    Column Definition
    Character Set
    Identity Column Specification
    Column Constraint Definition
    Collate Clause
    Table Content Source
    Like Table
    As SubQuery
    Table Options
    Cluster By
    On Commit
    With System Versioning
    INSERT
    FROM SUBQUERY
    CREATE VIEW
    Basic View
    Recursive Clause
    As Select
    Type Casts
For PostgreSQL
- Translation Reference
For IBM DB2
- Translation Reference
  - Statements
    CREATE VIEW
    OF type-name
    WITH CHECK OPTION
    WITH ROW MOVEMENT
    SELECT
    fullselect & subselect
    From Clause
    SINGLE TABLE REFERENCE
    SINGLE VIEW REFERENCE
    Single Nickname Reference
    ONLY TABLE REFERENCE
    OUTER TABLE REFERENCE
    Analyze Table Expression
    Nested Table Expression
    Data Change Table Reference
    Table Function Reference
    Collection Derived Table
    Xml table expression
    Joined Table
    External Table Reference
    Values Clause
    Having Clause
    Order by Clause
    Read only Clause
    Update Clause
    Optimize for Clause
    Isolation Clause
    Concurrent access resolution Clause
    Offset Clause
    Fetch Clause
    INSERT STATEMENT
    UPDATE STATEMENT
    Update Target
    Period Clause
    Correlation Clause
    Include Columns
    Assignment Clause
    From and Where Clause
    Order By
    Offset
    Fetch
    With Clause
    Skip Locked
    Wait Option
    DELETE STATEMENT
    Delete Target
    Common Table Expresion
    Period Clause
    Correlation Clause
    Include Columns
    Assignment Clause
    Where Clause
    Order By
    Offset
    Fetch
    With Clause
    Wait Option
    Skip Locked
    CREATE TABLE
    Content Source
    Element List
    Column Definition
    Data Type
    Column Options
    NOT NULL
    LOB OPTIONS
    SCOPE
    CONSTRAINT
    D/G CLAUSE
    Default Clause
    Generated Clause
    INLINE LENGTH
    COMPRESS
    SECURED
    HIDDEN
    Period Definition
    Unique Constraint
    ENFORCED
    QUERY OPTIMIZATION
    WITHOUT OVERLAPS
    Referential Constraint
    Check Constraint
    Of Type
    Like Table
    As Result Table
    Materialized Query Definition
    Staging Table Definition
    Table Options
    Organize By
    Data Capture
    Tablespace Clause
    In Tablespace
    Index In
    Long In
    Distribution Clause
    Partitioning Clause
    Compression Options
    With Restrict on Drop
    Not Logged Initially
    CCSID
    Security Policy
    Options
  - Predicates
    XMLEXISTS Predicate
    VALIDATED Predicate
    TYPE Predicate
    Basic Predicate
    Boolean Predicate
    Quantified Predicate
    JSON_EXISTS
    OVERLAPS
    LIKE Predicate
    Null Predicate
    REGEXP_LIKE Predicate
For Greenplum
- Translation Reference
For Amazon Redshift
- Translation Reference
For Apache Hive
- Translation Reference
For Vertica
- Translation Reference
For Google BigQuery
- Translation Reference
FOR SPARK (SCALA)
- Translation Reference
FOR SPARK SQL
- Translation Reference
  - SQL Translation Reference
    DDL
    Create Table
    Using
    DML
    Merge
    Select Statement
    Distinct
    Values
    Join
    Where
    Group By
    Union
    Data Types
FOR PYSPARK (PYTHON)
- Translation Reference
General
- Extensibility in SnowConvert
  - Additional Translation Rules
    Technical Details
    Working with ASTs
    Extensibility API
    SqlFunctionExprExtensions
    BaseTranslationRule'2
    BaseTranslationRule'3
    Example
Assessment Properties

Powered by GitBook

On this page

Was this helpful?

For Google BigQuery

Translation Reference

Statements

CREATE TABLE

TABLE OPTIONS

DEFAULT COLLATE PARTITION BY CLUSTER BY OPTIONS CLAUSE AS query_statement

PreviousCONSTRAINT DEFINITION NextDEFAULT COLLATE

Was this helpful?