Data Science and Data Engineering Blog

DATA SCIENCE WARRIOR

“It always seems impossible until it’s done.”

NELSON MANDELA

Snowflake Large Files Upload

With leading-edge technologies such as these which are massively dependant upon and producers of data, the need for data architecture and data system design becomes even more important.

The Role of Data Architecture

  • Plays a guiding role for organizations in executing business models and strategies
  • Provides factual, punctual, & qualitative data support for decisions
  • Similar to blood flow through the body, data can flow throughout the enterprise to all departments. Just as blood is vital to the organs, data is vital to the departments. This data flow can be limited by the silos we mentioned earlier in the lesson.

Great data warehouse solution

Link to install snowSQL on MacOS

If you are getting snowsql: command not found error try to switch to root using the following command sudo -i.

Notes on SnowSQL on local computer

In the terminal on your local computer, you will need to enter the correct information in order to connect correctly and verify the installation.

You will need 3 things to continue 

  • account name
    • You will find this in the URL of your browser while logged into Snowflake. It is the part between https:// and .snowflakecomputing.com
    • see screenshot below
  • username
  • password

The complete command you will enter in your terminal is

snowsql -u xxxxxx -a jz49064.us-central1.gcp

You will be prompted for your password

After successful login, the system will respond with

* SnowSQL * v1.2.10

Scroll to Top