SnowSQL packaged by Data Science Dojo

Data Science Dojo

SnowSQL packaged by Data Science Dojo

Data Science Dojo

A Snowflake command line tool to connect and perform data manipulations.

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:

  • Type snowsql to check the available commands and options
  • Type snowsql -a account-name -u username. Your account-name would look something like this: 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