►
From YouTube: dagster + airbyte + dbt + snowflake - parte 7
Description
Practica de Data engineer usando tecnologias open source
A
B
A
A
Installed
dbt
in
my
python
virtual
environment,
for
example,
I
added
these
these
dependencies
in
my
local.
Previously,
we
had
put
them
in
the
docker
here
with
this
command.
They
were
installing
here,
but
this
was
installing
the
in
the
in
the
image
and
when
we
ran
the
container
they
were
already
installed,
but
here
I
am
installing
it
on
my
local
machine
in
a
virtual
environment.
So
I
added
these
three
of
dependencies.
My
memories
and
I
only
ran
pint,
install
The
Command.
What
is
this
Command
called?
A
A
There
I
have
it
local.
Now
we
are
going
to
the
second
part
that
another
part
that
something
else
says
in
the
dvt
in
my
doctor,
fire
had
these
three
lines
that
I
was
installing
the
thing.
So
what
I
did
was
delete
it
and
pass
That
that
dependency
through
a
recuayerments
that
is
here
so
those
three
dependencies
that
I
deleted.
A
I
added
to
an
XT
count
and
I'm
copying
those
files
to
the
DVD
folder
and
I'm
installing
it
just
like
that,,
nothing
more
And,
that's
practically
the
same
as
what
we
did
in
daxter
Remember,
the
duster.
The
doctor
is
the
same.
We
pass
all
the
dependencies
here
and
we
are
using.
The
install
Another
thing.
I
did
is
that
now
we
are
going
to
to
do
this
step.
Was
the
project
I
already
added
one
here
as
a
test,
but
I
am
going
to
do
all
the
steps
again
So.
A
If
you
remember
I
told
you
that
we
had
DVD
installed,
but
from
bts
to
be
able
to
run
a
project,
you
need
a
dt
project
which
are
the
files
then
to
to
be
able
to
create
a
bt
project.
We
are
going
to
go
to
the
folder,
we
are
going
to
see
folder
de
and
here
in
this
folder.
It
should
be
this.
We
can
initialize
a
project.
A
A
B
A
A
Important
about
a
bts
project
that
needs
a
profile
and
file
normally
it
is,
as
it
says,
in
the
documentation.
It
is
outside
your
project
where
tbt,
because
that
is
where
the
credentials
used
to
connect
to
the
werehouse
are,.
For
example,
the
one
I
am
using
would
be
in
this
directory
in
Windows
I,
don't
know
where
it
would
be,
but
you
could
look
for
it
there
in
internet,
but
usually
it
is
a
project
that
is
at
this
address
and
that
has
all
all
all
these
files.
A
To
go
back,
So
I
can
go
back
so
right
now,
I
just
open
the
file
in
this
path.
What
do
you
have
here,
right?
What?
Is
this
one
doing
here?
Then,
in
that
file,?
If
you
look,,
there
is
the
name
of
the
project,
two
that
I
just
created,
and
there
are
all
the
values
that
I
saw
at
the
beginning
when
I
asked
them
here
since
then,
in
theory,,
you
have
to
replace
all
those
values
with
the
Warehouse
that
is
going
to
be
connected
in
this
case,
It
should
be
snowflake.
True.
A
These
credentials
do
not
matter.
I
am
going
to
change
this
step
later
and
I
am
going
to
delete
this
database
So.
It
does
not
matter
in
the
video
if
they
want
to
use
it
But.
These
are
the
credentials
that
I
I
would
use
it
to
connect
to
a
snowflake
Warehouse.
That
has
been
this
one.
That
I
had
already
used
when
I
tried
airbit
right,
then
Those
are
the
credentials
And.
I
click
save
right
So.
How
do
we
test
this?
A
A
A
Right
So
now,
let's
do
something
else.
Let
me
move
this
again
to
for
little
ones.
So
now
we're
going
to
work
with
with
I
can
delete
this
project
because
practically
what
I
did
with
this
project?
One
is
what
I
did
here
right
So?
How
do
we
test
But
before
doing
it,
I'm
going
to
run,
for
example,
right
now?
This
project
2
has
some
models
that
are
stockholm.
This
one
is
connecting
So.
He
is
going
to
create
those
models
in
snowflake.
If
I
run
it,
it
will
be
dbt.
It.
A
Is
running
and
how
were
they
to
see
their
sex
their
sex?
If
I
go
to
snowflake,
you
will
see
that
here
now,
I
have
these
tables,
as
you
can
see,
I
already
have
My
First
Mobile
my
sink
DVD.
These
were
created
through
the
model.
The
btc
project
that
we
created
earlier
Let
me
Delete
this
to
start
over.
They
are
already
deleted
Ok.
So
practically
here
we
have
a
vt
project,
fully
functional
and
running,.
A
A
Previous
tests,
that
I
was
doing
Here
I
have
the
models,
my
model
1
model
2
and
an
example
of
how
I
am
going
to
create
a
model
taking
from
a
table
and
I
am
going
to
go
to
another
one.
So
I
have
three
models
that
I
am
going
to
run.
This
project
is
using
this
profile
as
I
always
project,
one
that
this
effect
1
and
it
has
the
same
credentials
as
it
had
in
project
2.
A
Now,
let's
locate
this.
If
you
remember
in
the
previous
video,
the
docker
image
was
being
created,
it
was
creating
this
folder,
but
this
folder
was
empty
So.
There
was
no
docker
project
that
we
could
use
So.
In
this
case,
we
are
going
to
copy
everything
that
is
in
project
one
and
we
are
going
to
copy
it
to
the
folder
of
this
container,
right?.
A
A
So.
We
need
to
provide
that
profile
to
the
container,,
so
in
this
case,
I
made
a
copy
of
this
file
profile
and
I
put
it
Here
that
this
one
is
called
here
for
another
reason,
and
this
one
only
has
information
from
project
1
So
I
no
longer
need
This
one
So
in
order
not
to
delete
the
data,
then
this
profile
is
the
one
that
we
are
going
to
copy
to
the
root
of
the
container
and
when
we
run
and
when
we
demo,
they
should
steal
you,,
it's
going
to
use
these
credentials
to
connect
to
snowflake.
A
B
A
The
image
and
the
Command
that
we
are
going
to
run
in
this
case,
the
first
Command
that
we
are
going
to
run
is
Book,
the
same
one
that
we
ran,
but
in
my
local
the
only
difference
is
that
we
are
using
it
through
the
image
of
the
dokio
container.
As
you
can
see
here,
So,
it
is
running.
We
remove
it,
seeing
that
the
profile
is
correct,
it
should
be
correct
and
the
snowfly
connection
was
correct,
and
here
we
are
not
connecting
correctly
to
snowflake
through
a
container
Now.
Only.
A
What
we
What
remains
is
to
test
if
it
would
run
if
it
would
create
the
tables
and
the
track
that
we
need
through
the
container.
In
this
case,
let
me
delete
Saúl
test,
because
it
is
in
content
that
is
already
there.
We
are
going
to
run
it
again,
but
now
one
difference
is
that
we
are
going
to
execute
The
round
command
will
to
be
excellent
with
this
parameter
with,
and
what
will
it
be?
It
will
execute
the
models
that
are
in
this
folder.
A
2
number
3
is
removed,
correct
So.
If
I
go
to
my
snowflake,
you
will
see
here
that
the
first
one
has
already
been
created,
model
and
second
model,
and
here
is
an
example
that
I
did
of
how
to
pull
data
from
a
table.
That
is
here
in
the
snorflex,
twinkle
and
put
it
here
and
that's
it,
and
here
we
already
have
PhD
already
in
a
working
container.
A
We
have
it
as
an
executable,
f
container
In,
the
next
video
we
are
going
to
see
how
this
integrate
as
duster,
can
communicate
with
dbt
and
run
models
through
daxter.
For
now,
if
it
would
be
our
project
in
the
Bethel
Forum,
the
bt
project
that
we
are
going
to
use
and
the
profile
that
the
important
and
nothing
else
there
is
more
would
remain
in
the
next
video.
We
will
see
how
to
communicate
these
two
tools.