
## Create a Snowflake User

Once you create a 30-day trial account, the role should be able to create a new user, but just for learning, you can logged on to the trial account, under the admin - Users & Roles and click the **_User_** to create a new user.

![create snowflake user](/images/snowflake-how-to-use-snowsql-to-interact-with-snowflake/img1.png)

The sample data here is using from snowflake documentation's data.

## Install SnowSQL

Follow by the official document to download the `SnowSQL`, this blog's tutorial is running at MacOS, you can choose different OS per your environments at here.
https://docs.snowflake.com/en/user-guide/snowsql-install-config#installing-snowsql-on-macos-using-the-installer

Once snowsql installed, try run below steps to connect to SnowFlake with SnowSQL.

```
snowsql -a <account_name> -u <login_name>
```

In case you have issue to run `snowsql` at MacOS, after install the `snowsql`, try below command at terminal.

```
/Applications/SnowSQL.app/Contents/MacOs/snowsql
```

If this still doesn't work, maybe try to update brew, or reinstall brew to see. Once brew got updated, try again with this command to install `snowsql` via brew

```
brew install --cask snowflake-snowsql
```

## Log in with SnowSQL

Start connect with Snowflake with snowsql by type below command, **_account_identifier_** is the one you received at email, the **\* part, https://\*\***.snowflakecomputing.com.

```
snowsql -a <account_identifier> -u <user_name>
```

Once successful start terminal window with snowsql, you can start to type SQL command for DML or DDL now.

This command will create database `sf_test`, by default this will create under the `public` schema.

```
CREATE or REPLACE DATABASE sf_test;
```

![create snowflake database](/images/snowflake-how-to-use-snowsql-to-interact-with-snowflake/img2.png)

This command then will create table called `emp_basic`.

```
create or replace table emp_basic (
first_name STRING ,
last_name STRING ,
email STRING ,
streetaddress STRING ,
city STRING ,
start_date DATE
);

```

This command will create a warehouse.

```
CREATE OR REPLACE WAREHOUSE sf_test_wh WITH
   WAREHOUSE_SIZE='X-SMALL'
   AUTO_SUSPEND = 180
   AUTO_RESUME = TRUE
   INITIALLY_SUSPENDED=TRUE;
```

## Import data into Snowflake by using snowsql

below is command to upload the `employees01.csv` file into the snowflake table,

```
PUT file:///Users/employees01.csv @sf_test.public.%emp_basic;
```

you can also type this to check the upload files

```
LIST @sf_test.public.%emp_basic;
```

## Copy data into the snowflake table

```SQL
COPY INTO emp_basic
  FROM @%emp_basic
  FILE_FORMAT = (type = csv field_optionally_enclosed_by='"')
  PATTERN = '.*employees0[1-5].csv.gz'
  ON_ERROR = 'skip_file';
```

## Query data via Snowsql

Now we can just run regular SQL syntax to query data.

```SQL
select * from emp_basic;
-- or
select count(*) from emp_basic;
-- or
select city, count(*) from EMP_BASIC group by city order by city;
-- or
insert into EMP_BASIC values ('dd', 'yy', 'ddyy@ddyy.com', 'street', 'll', '2022-02-01');

```

## Remove Database and Dataware Hourse

Once finish our tutorial, we can run below command to remove the database and warehouse.

```SQL
drop database if exists sf_test;
drop WAREHOUSE if exists sf_test_wh;
```

## Exit

To exit snowsql, type `!exit` to exit the terminal.

## Conclusion

Now if you back to the snowflake console, you shouldn't see the snowflake database or warehouse. Use snowsql is very strictforward way to interact with snowflake by type SQL syntax from your terminal.


Snowflake is designed for scalability with big data, this blog shows how to get start with snowflake with snowsql.

How to use SnowSQL to interact with Snowflake


### Get Free Trial Account

- Use personal email or company email.
- If is personal, just enter personal email.
- Choose Snowflake edition as Standard, choose cloud provider, AWS or Azure or Google.
- Once choose few preferences and you should get an email.
- Click the email to setup the trial user id and password.

### What Snowflake can do?

- Use Snowflake as data warehouse and datalake
- Run data analysis and build visualizations
- Load data, build data pipeline or migrate an existing warehouse
- Build or train a machine learning model
- Build or distribute an application with Snowflake

### What Language Snowflake support

- SQL
- Python
- Java
- Scala

### Try Snowflake

- Explore sample data
- Load data into Snowflake

### For starter, list of things to try for snowflake

- How to load Data
- How to scale compute
- How to work with semi-structured data
- How to use Snowflake Data Marketplace
- How to create data visualizations
- How to build and share dashboards
- How to use SnowSLQ to connect with Snowflake via CLI
- Check snowflake demo, https://www.snowflake.com/live-demo/

### List of Term

- SnowSQL - command line toolf ro testing queries, loading/unloading bulk data.
- Snowsight - next-generation SQL worksheet for advanced query development, data analysis and visualization
- Snowpipe - data import & export, use snowpipe for continuous micro-batch loading.
- SnowCD - command line diagnostic tool for identifying and fixing client connectivity issues.
- Snowflake SQL API - REST API for accessing and updating data in snowflake database.
- Snowpark - use Python, Java and Scala for process.
- Streamlit in Snowflake - building, deploying and sharing Streamlit apps on Snowflake data cloud.

### Other Useful tools

- Snowflake Extension for Visual Studio Code
  - https://docs.snowflake.com/en/user-guide/vscode-ext


Snowflake is designed for scalability with big data, this blog shows how to get start with snowflake, list of resources can get use to get started.

Category snowflake

How to use SnowSQL to interact with Snowflake

How to get start with Snowflake