Language structures support
This section provides information on the support for dependencies mapping for Snowflake SQL commands (DDL, DML, and query syntax).
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.
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.
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.
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.
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]
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]
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.
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