Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • SQL statements are stored as part of the query instance for the object. If the same query is being made across multiple users using private connections, the SQL must be shared and entered by individual users.

    Info

    NOTE: If a dataset created from custom SQL is shared, collaborators are not permitted to edit the custom SQL.


  • SQL statements must be valid for the syntax of the target relational system. Syntax examples are provided below.

  • If you modify the custom SQL statement when reading from a source, all samples generated based on the previous SQL are invalidated.
  • Declared variables are not supported. 

  • Common Table Expressions (CTEs) are not supported.
  • For each SQL statement, all columns must have an explicit name. Example:
    • Function references such as: 

      Code Block
      UPPER(col)


    • Must be specified as:

      Code Block
      UPPER(col) as col_name


...