DBT Learning -2 - snowflake with data

 

You need to have a Snowflake Data platform for it . If not please create one as below:

You can start by signing up for a free trial on Snowflake:

Sign up for a free trial by following link https://signup.snowflake.com/ and completing the sign-up form.

Select the Enterprise edition, choose a cloud provider and region, and agree to the terms of service.

Click GET STARTED.

After submitting the sign-up form, you should receive an email asking you to activate your account. Click the link in the email and a new tab will open up where you’ll create your username and password. Complete the form and click Get started.

Congrats! Your workspace is ready for some data.  Now to load sample data use below queries.

#creating Warehouse, Database and schemas

create warehouse transforming;

create database raw;

create database analytics;

create schema raw.jaffle_shop;

create schema raw.stripe;

#creating customer table and loading Data

create table raw.jaffle_shop.customers 

( id integer,

  first_name varchar,

  last_name varchar

);

copy into raw.jaffle_shop.customers (id, first_name, last_name)

from 's3://dbt-tutorial-public/jaffle_shop_customers.csv'

file_format = (

  type = 'CSV'

  field_delimiter = ','

  skip_header = 1

  );

#creating orders table and loading data

create table raw.jaffle_shop.orders

( id integer,

  user_id integer,

  order_date date,

  status varchar,

  _etl_loaded_at timestamp default current_timestamp

);

copy into raw.jaffle_shop.orders (id, user_id, order_date, status)

from 's3://dbt-tutorial-public/jaffle_shop_orders.csv'

file_format = (

  type = 'CSV'

  field_delimiter = ','

  skip_header = 1

  );

#creaing payments table and loading data

create table raw.stripe.payment 

( id integer,

  orderid integer,

  paymentmethod varchar,

  status varchar,

  amount integer,

  created date,

  _batched_at timestamp default current_timestamp

);

copy into raw.stripe.payment (id, orderid, paymentmethod, status, amount, created)

from 's3://dbt-tutorial-public/stripe_payments.csv'

file_format = (

  type = 'CSV'

  field_delimiter = ','

  skip_header = 1

  );

#validating the loaded data

select * from raw.jaffle_shop.customers;
select * from raw.jaffle_shop.orders;
select * from raw.stripe.payment;