Language structures support

This section provides information on the support for dependencies mapping for Snowflake SQL commands (DDL, DML, and query syntax).

The list of commands is not 100% complete, and we are constantly expanding the capabilities of our analysis.

Glossary

Script: used as a synonym for the source file.

Relationships

A relationship is the simplest relationship between objects, it represents a connection between them, there are different kinds of relationships

  • Script relationship: (Script)−action→(Object)

    The script relationship represents an "action" that is being executed inside the script towards an object.

    E.g.:

    UPDATE DB.SCH.T1 SET value1 = newValue;

    (file.sql)−UPDATE→(DB.SCH.T1)

  • Contains relationship: (Script)−contains→(Object)

    The contains relationship is defined by CREATE commands. This will generate elements known as Objects otherwise the Objects found are called Missing Objects.

    E.g.:

    CREATE TABLE DB.SCH.T1 (...

    (file.sql)−CONTAINS→(DB.SCH.T1)

Dependencies

A dependency is a strong link between two objects. Most of the time the dependent object needs that dependency relationship so it can work.

  • Reference: (Object1)−REFERENCES→(Object2)

    The reference relationship is defined by the use of an Object inside a command, each object that has a "parent" identified will have this relationship. The Missing Object type will be used when the usage of an object is found, but the creation statement for the object was not.

    E.g.:

    CREATE VIEW DB.SCH.V1 AS SELECT * FROM DB.SCH.T1;

    (DB.SCH.V1)−REFERENCES→(DB.SCH.T1)

DDL Commands

Most DDL commands generate dependencies (or simple relationships). The CREATE command is pretty unique given its nature of generating objects, so we will be adding a specific block for it.

Command
Type
Support Status

ALTER <object>

Script relationship

Not supported

COMMENT

Script relationship

Not supported

DESCRIBE <object>

Script relationship

Not supported

DROP <object>

Script relationship

Not supported

SHOW <object>

Script relationship

Not supported

USE <object>

Script relationship

Not supported

CREATE <object>

This command can be used with Account and Database objects, which in turn gives it a lot of different variations, each with a specific syntax. Usually, the more complex syntax will be less likely that the scanner will identify it.

Create [Account objects]

Command
Type
Support Status

CREATE CONNECTION

Contains relationship

Not supported

CREATE NETWORK POLICY

Contains relationship

Not supported

CREATE RESOURCE MONITOR

Contains relationship

Not supported

CREATE SHARE

Contains relationship

Not supported

CREATE ROLE

Contains relationship

Not supported

CREATE USER

Contains relationship

Not supported

CREATE WAREHOUSE

Contains relationship

Not supported

CREATE DATABASE

Contains relationship

Supported

CREATE DATABASE … CLONE

Contains relationship

Supported

CREATE NOTIFICATION INTEGRATION

Contains relationship

Not supported

CREATE SECURITY INTEGRATION

Contains relationship

Not supported

CREATE SESSION POLICY

Contains relationship

Not supported

CREATE STORAGE INTEGRATION

Contains relationship

Not supported

Create [Database objects]

Command
Type
Support Status

CREATE SCHEMA

Contains relationship

Supported

CREATE SCHEMA … CLONE

Contains relationship

Supported

CREATE TABLE

Contains relationship

Supported

CREATE TABLE … CLONE

Contains relationship

Not supported

CREATE EXTERNAL TABLE

Contains relationship

Not supported

CREATE VIEW

Contains relationship

Supported

CREATE MATERIALIZED VIEW

Contains relationship

Supported

CREATE MASKING POLICY

Contains relationship

Not supported

CREATE ROW ACCESS POLICY

Contains relationship

Not supported

CREATE SEQUENCE

Contains relationship

Supported

CREATE SEQUENCE … CLONE

Contains relationship

Not supported

CREATE TAG

Contains relationship

Not supported

CREATE FILE FORMAT

Contains relationship

Not supported

CREATE FILE FORMAT … CLONE

Contains relationship

Not supported

CREATE STAGE

Contains relationship

Not supported

CREATE STAGE … CLONE

Contains relationship

Not supported

CREATE PIPE

Contains relationship

Not supported

CREATE STREAM

Contains relationship

Supported

CREATE STREAM … CLONE

Contains relationship

Not supported

CREATE TASK

Contains relationship

Not supported

CREATE TASK … CLONE

Contains relationship

Not supported

CREATE FUNCTION

Contains relationship

Not supported

CREATE EXTERNAL FUNCTION

Contains relationship

Not supported

CREATE PROCEDURE

Contains relationship

Supported

DML

Currently, the DML commands alone are not generating any kind of dependencies.

Type
Support Status

INSERT

Script relationship

Not supported

INSERT (multi-table)

Script relationship

Not supported

MERGE

Script relationship

Not supported

UPDATE

Script relationship

Not supported

DELETE

Script relationship

Not supported

TRUNCATE TABLE

Script relationship

Not supported

Last updated