Скачать или смотреть How to open snowflake account?

How to create Free SNOWFLAKE account??

Snowflake is a cloud data warehouse that can store and analyze all your data records in one place.
It can automatically scale up/down its compute resources to load, integrate, and analyze data.

Link: https://www.snowflake.com/en/


----give required input

----account created

----here we see some practice worksheets

----we just create our snowflake account and login

--now need to create database, user, warehouse

----first we will create a warehouse......

----here we see that our login role is ACCOUNTADMIN

this role can grant or revoke user access.

for creating database object we need to login SYSADMIN user role

---we can change the role after login

-----we will create all required object from a new worksheet

create warehouse dba_cave_wh;
create database dba_database;

create warehouse dba_cave_wh;
create database dba_database;
---now we will create schema
create schema dba_database.dba_cave; ----here we need identify the database name

---now we will create table under dba_cave schema

create table test_tbl(id number(10,2), name varchar(10));

---lets check from object browser
--now insert data

insert into dba_cave.test_tbl values(1,'test_man');

select * from dba_cave.test_tbl; ----here we need to provide the schema.table name

---there is another way

use database dba_database;
use schema dba_cave;
select * from test_tbl; ---because we are connected to snowflake database in the above
---still not working because of we just setup the database name not the schema
--here we see the selected schema name is PUBLIC

----we can set database, schema from drop down menu
--or we can set the default database,schema to the user
----so today we learned how to open snowflake user
---how to create object and so on
\
----next I will create some access role and functional role to maintain user access to database


-----------take care bye bye