►
Description
Cathy is working to implement the Zendesk dbt package from Fishtown Analytics but found some discrepancies in the expected data format. Emilie walks her through how to solve this problem.
Data Team Project: https://gitlab.com/gitlab-data/analytics
Zendesk dbt package: https://github.com/fishtown-analytics/zendesk
Cathy's MR: https://gitlab.com/gitlab-data/analytics/merge_requests/752
Docs on dbt Package Management: https://docs.getdbt.com/docs/package-management
dbt: https://www.getdbt.com
A
B
A
A
You
want
to
call
it
Zendesk
stitch
ticket,
metrics
or
whatever,
and
what
you're
gonna
do
with
d
nest
the
agent
weight
time
in
minutes
value
into
agent
weight
time
in
minutes,
business
agents
wait
time
in
minutes
on
then
in
your
DBT
project
Hamel
file,
rather
than
pointing
to
the
raw
table.
You're
gonna
point
to
the
one.
B
A
And
snowflake
has
really
great
JSON
support,
so
they
may
be
nesting.
This
really
easy,
and
there
are
a
couple
examples
in
the
repo
snowplow
base
models
all
follow
this
model
so
where
we
D
nest,
and
then
we
feed
that
into
the
package,
so
that
should
get
you
going
in
the
right
direction.
What
about
the
other
tables
in
the
package?
Are
they
similar
problems?
Yeah.