# HubSpot-Snowflake Data Share

**URL:** <https://community.hubspot.com/t/hubspot-snowflake-data-share/91924>\
**Category:** Dashboards & Reporting\
**Tags:** developer\
**Created:** [October 16, 2023, 8:34pm UTC](https://community.hubspot.com/t/hubspot-snowflake-data-share/91924 "2023-10-16T20:34:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![AbyJacob](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@AbyJacob](https://community.hubspot.com/u/AbyJacob)\
**Post date:** [October 16, 2023, 8:34pm UTC](https://community.hubspot.com/t/hubspot-snowflake-data-share/91924/1 "2023-10-16T20:34:36Z")

</div>

Hi,

We are bringing the hubSpot data to SnowFlake using data share. Where do i find the Traffic Analytics data? I can see traffic analytics along with sessions analytics in HubSpot, but cannot find the same data in SnowFlake. Please help.

 ![Screenshot 2023-10-17 at 10.25.57 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/3/b3c0eb43c515f7a0a97d39fc2553b3b2c21959f3.png)

Thanks,

AB

---

<div class="post-metadata">

**Author:** ![Shadab\_Khan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/shadab_khan/32/12293_2.png) [@Shadab\_Khan](https://community.hubspot.com/u/Shadab_Khan)\
**Post date:** [October 17, 2023, 5:12am UTC](https://community.hubspot.com/t/hubspot-snowflake-data-share/91924/2 "2023-10-17T05:12:10Z")

</div>

Hi @AbyJacob ,

Looks like you need to use [SITE\_PAGE](https://knowledge.hubspot.com/reports/query-hubspot-data-in-snowflake#:~:text=collective%20marketing%20efforts.-,SITE_PAGE,-0%2D38) &/OR Event Type: [EVENTS\_VISITED\_PAGE](https://knowledge.hubspot.com/reports/query-hubspot-data-in-snowflake#:~:text=Sequence%20step%20executed.-,EVENTS_VISITED_PAGE,-Website%20page%20visits)

Full Details are shared on [Knowledge Doc](https://knowledge.hubspot.com/reports/query-hubspot-data-in-snowflake)

Stay Awesome & Keep Doing it BIG 🔥

---

<div class="post-metadata">

**Author:** ![AbyJacob](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@AbyJacob](https://community.hubspot.com/u/AbyJacob)\
**Post date:** [October 17, 2023, 1:01pm UTC](https://community.hubspot.com/t/hubspot-snowflake-data-share/91924/3 "2023-10-17T13:01:50Z")

</div>

Hey [@Shadab\_Khan](https://community.hubspot.com/t5/user/viewprofilepage/user-id/513582) ,

Thanks for the reply. I’m actually trying to replicate the reports in this “Traffic Analytics” dashboard within HubSpot in Snowflake.

> **[Understand HubSpot's traffic sources in the web traffic analysis tool](https://knowledge.hubspot.com/reports/understand-hubspots-traffic-sources-in-the-traffic-analytics-tool)**
>
> Learn more about the traffic sources in HubSpot's traffic analytics tool.

Do you think the same can be achieved using SITE\_PAGE or EVENTS\_VISITED\_PAGE?

---

<div class="post-metadata">

**Author:** ![Shadab\_Khan](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/shadab_khan/32/12293_2.png) [@Shadab\_Khan](https://community.hubspot.com/u/Shadab_Khan)\
**Post date:** [October 17, 2023, 1:10pm UTC](https://community.hubspot.com/t/hubspot-snowflake-data-share/91924/4 "2023-10-17T13:10:01Z")

</div>

I cannot say for sure(dont have active snowflake account on me), try doing it and then see if the data gets a tally or no.

---

<div class="post-metadata">

**Author:** ![AbyJacob](https://avatars.discourse-cdn.com/v4/letter/a/48db29/32.png) [@AbyJacob](https://community.hubspot.com/u/AbyJacob)\
**Post date:** [October 17, 2023, 2:26pm UTC](https://community.hubspot.com/t/hubspot-snowflake-data-share/91924/5 "2023-10-17T14:26:49Z")

</div>

Thanks, [@Shadab\_Khan](https://community.hubspot.com/t5/user/viewprofilepage/user-id/513582)

Looks like those tables provide info about the individual pages on the website. I’m trying to see if there’s an easy way to replicate the analytics provided at the HubSpot side. I’d think HubSpot has information like below stored in some tables, trying to identofy those tables.

 ![Screenshot 2023-10-17 at 10.25.57 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/3/b3c0eb43c515f7a0a97d39fc2553b3b2c21959f3.png)