Data Science Dojo delivers data science education, consulting, and technical services to harvest the power of data.

Trademarks: This software listing is packaged by Data Science Dojo. The respective trademarks mentioned in the offering are owned by the respective companies, and use of them does not imply any affiliation or endorsement.

About the offer:

Snowflake is a data cloud platform. It is a user-friendly data warehousing product that supports both ETL and ELT functionalities. As the name of this offer suggests, SnowSQL is a CLI-based tool provided by Snowflake to connect to your Snowflake account and configure your databases, schemas, and warehouses using simple SQL. With SQL at hand, users can import existing databases of the data cloud into local machines and then perform various DDL and DML operations. It also allows you to unload or dump your transformed data back into the database containers. It is produced with increased protection standards and has strong integration with Snowflake core architecture.

Who benefits from this offer:

Following can benefit from SnowSQL:

Students who want to gain hands-on training with data warehousing
Team of developers who operate on databases
DevOps Engineers
Enterprises who want to pursue a cloud-native environment having storage, compute, and data sharing in real-time on their CLI
SnowSQL is also a good fit for Data Engineers who can create their own sub-warehouses on snowflake cloud and perform other functionalities as well

What is included in this offer:

A Command Line Interface (CLI) installed with SnowSQL which can be connected to your Snowflake account
Support for standard SQL
Robust integrations
Ability load and unload data having CSV, XML, JSON, Avro etc formats
Includes syntax highlighting and auto-complete

Technical Specifications:

SnowSQL throughput improves with more CPU cores, more RAM, and faster disks

Minimum memory: 8GB RAM
Minimum vCPU: 2 vCPUs
Operating System: Ubuntu 20.04

Instructions to get started:

You must have a Snowflake account in place. You can create a new trial-based or an on-demand account from: https://www.snowflake.com/pricing/

Type snowsql to check the available commands and options
Type snowsql -a account-name -u username. Your account-name would look something like this: ub86808.east-us-2.azure which you can extract from URL. Your username will be on the top right in caps like this: USERNAME. Click on the Classic Web UI first in order to view these both credentials.
After prompting for password and connecting, type show DATABASES to check the available dbs

SnowSQL packaged by Data Science DojoData Science Dojo

SnowSQL packaged by Data Science Dojo

Data Science Dojo

SnowSQL packaged by Data Science Dojo

Data Science Dojo

SnowSQL packaged by Data Science Dojo
Data Science Dojo