Start

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Transformation for this command is pending

Description

The START command runs the SQL*Plus statements in the specified script. The script can be called from the local file system or from a web server. (Oracle SQL Plus User's Guide and Reference)

Oracle Syntax

STA[RT] {url | file_name[.ext] } [arg...]

SnowSQL (CLI Client) !load

!(load | source) {url | file_name[.ext] }

The Snowflake !source and !load commands are equivalent.

1. Simple start

The START command is replaced by the !load command.

This case is functionally equivalent.

Oracle

Command

START C:\Users\My_User\Desktop\My\Path\insert_script.sql

SnowSQL (CLI Client)

Command

!load C:\Users\My_User\Desktop\My\Path\insert_script.sql

2. Start with arguments

Oracle

Command

START C:\Users\My_User\Desktop\My\Path\insert_script.sql 123 456 789

SnowSQL (CLI Client)

Query

!load C:\Users\My_User\Desktop\My\Path\insert_script.sql

Script arguments are currently not supported for SnowSQL (CLI Client).

Known Issues

1. Arguments are not supported in the SnowSQL CLI Client

Oracle can pass down multiple arguments to a script and can be accessed with &1, &2, and so on, but this cannot be done in the SnowSQL CLI Client. You can simulate arguments by declaring variables with the !define command. Keep in mind that these values are defined globally for all the scripts so the behavior may not be equivalent.

This workaround would look something like this:

!set variable_substitution=true
!define 1=123
!define 2=456
!define 3=789
!load C:\Users\My_User\Desktop\My\Path\insert_script.sql

Related EWIs

No related EWIs.