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.

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.

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

• 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

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

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