# Latest **URL:** https://forum.data-community.org/latest.md?page=3 [Latest](https://forum.data-community.org/latest.md) · [Categories](https://forum.data-community.org/categories.md) · [Tags](https://forum.data-community.org/tags.md) **Page:** 4 --- ## [Is an interaction a hub?](https://forum.data-community.org/t/is-an-interaction-a-hub/1759)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 8\ **Last updated:** [March 18, 2025, 1:51am UTC](https://forum.data-community.org/t/is-an-interaction-a-hub/1759 "2025-03-18T01:51:06Z")
So, there’s a bit of a debate around whether interactions originating from various CRMs should have a hub or not. I stand corrected if I’m wrong, but to me the interaction is not a participant. For example, we have a s… --- ## [Mandatory DV\_tenantid in satellite tables](https://forum.data-community.org/t/mandatory-dv-tenantid-in-satellite-tables/1772)
**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\ **Replies:** 2\ **Last updated:** [March 17, 2025, 10:40pm UTC](https://forum.data-community.org/t/mandatory-dv-tenantid-in-satellite-tables/1772 "2025-03-17T22:40:37Z")
Hi @patrickcuba Given I’m implementing DV for multiple entities of the financial group, I’ve added dv\_tenantid to all DV structures to logically segregate business keys of Offers, Contracts, etc. However, till now I ha… --- ## [Modeling customer activity](https://forum.data-community.org/t/modeling-customer-activity/1581)
**Author:** [@arozsypal](https://forum.data-community.org/u/arozsypal)\ **Replies:** 6\ **Last updated:** [March 12, 2025, 7:04am UTC](https://forum.data-community.org/t/modeling-customer-activity/1581 "2025-03-12T07:04:30Z")
Hi, I am trying to understand what would be your recommendation for modeling the following object. There is a Salesforce custom object Customer\_Activity. It has relationship to Campaign, Contact or Lead (current design … --- ## [Restructuring Source Data](https://forum.data-community.org/t/restructuring-source-data/1758)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 1\ **Last updated:** [March 11, 2025, 11:03am UTC](https://forum.data-community.org/t/restructuring-source-data/1758 "2025-03-11T11:03:08Z")
Should you ever split the source data table into multiple hubs/sats (unless PII)? Would this be considered to be restructuring the source data in the raw data vault? Let’s say you have a table coming from yet another C… --- ## [Business subject but no business key](https://forum.data-community.org/t/business-subject-but-no-business-key/1744)
**Author:** [@justinV](https://forum.data-community.org/u/justinV)\ **Replies:** 4\ **Last updated:** [February 27, 2025, 2:31pm UTC](https://forum.data-community.org/t/business-subject-but-no-business-key/1744 "2025-02-27T14:31:55Z")
Hello everyone, I’m seeking advice on modeling my DV. Our team focuses on fraud and corporate solvency risks. We’ve collaborated with the business team to identify key business objects : company, contract, financial st… --- ## [Renaming the source columns in raw vault](https://forum.data-community.org/t/renaming-the-source-columns-in-raw-vault/1311)
**Author:** [@mrcool4](https://forum.data-community.org/u/mrcool4)\ **Replies:** 10\ **Last updated:** [February 23, 2025, 9:52pm UTC](https://forum.data-community.org/t/renaming-the-source-columns-in-raw-vault/1311 "2025-02-23T21:52:59Z")
Hi All, We have encountered a few special column names that are reserved words(keywords), and numeric column names like 238567 from the source tables. What is the best practice for handling these columns in the raw vaul… --- ## [Metrics vault on Snowflake](https://forum.data-community.org/t/metrics-vault-on-snowflake/1707)
**Author:** [@jhall\_uk](https://forum.data-community.org/u/jhall_uk)\ **Replies:** 4\ **Last updated:** [February 16, 2025, 9:45pm UTC](https://forum.data-community.org/t/metrics-vault-on-snowflake/1707 "2025-02-16T21:45:48Z")
Has anyone implemented a custom metric vault on Snowflake for logging execution history - timings, records inserted etc? If so, any recommendations for going about - if streams and tasks are the basis for loading the raw… --- ## [Applied Date - cluster key query](https://forum.data-community.org/t/applied-date-cluster-key-query/1733)
**Author:** [@jhall\_uk](https://forum.data-community.org/u/jhall_uk)\ **Replies:** 4\ **Last updated:** [February 16, 2025, 9:43pm UTC](https://forum.data-community.org/t/applied-date-cluster-key-query/1733 "2025-02-16T21:43:17Z")
Good day everyone! Just a quick question regarding the use of Applied Date in the context of indexing or clustering. Is the recommendation on Snowflake to cluster the Satellite table by the parent hub/link Hashkey and A… --- ## [Modelling Counterparty / GUID / BK](https://forum.data-community.org/t/modelling-counterparty-guid-bk/1736)
**Author:** [@Chris](https://forum.data-community.org/u/Chris)\ **Replies:** 3\ **Last updated:** [February 14, 2025, 11:15pm UTC](https://forum.data-community.org/t/modelling-counterparty-guid-bk/1736 "2025-02-14T23:15:33Z")
Hi, Currently, I have the following source data regarding counterparties/companies: The source provides the columns GUID, NAME, and CUSTOMER\_ID, along with corresponding descriptive properties. The NAME column and the … --- ## [A single HUB can be used to store the records from different sources with different natural keys](https://forum.data-community.org/t/a-single-hub-can-be-used-to-store-the-records-from-different-sources-with-different-natural-keys/1376)
**Author:** [@shuja](https://forum.data-community.org/u/shuja)\ **Replies:** 4\ **Last updated:** [February 14, 2025, 3:58pm UTC](https://forum.data-community.org/t/a-single-hub-can-be-used-to-store-the-records-from-different-sources-with-different-natural-keys/1376 "2025-02-14T15:58:12Z")
A single HUB can be used to store the records for different natrual keys(concatenated by different natural keys from different sources) ? For example Source 1 Hassh key H\_Costomer cust\_hash\_key =(concatenation of fn… --- ## [\[Need Advice\] Sat Table Reloading Stretegy](https://forum.data-community.org/t/need-advice-sat-table-reloading-stretegy/1729)
**Author:** [@Samvar](https://forum.data-community.org/u/Samvar)\ **Replies:** 1\ **Last updated:** [February 11, 2025, 10:00pm UTC](https://forum.data-community.org/t/need-advice-sat-table-reloading-stretegy/1729 "2025-02-11T22:00:13Z")
Hey there , I want some advice on the data vault modelling and load stretegy of the sat table. In our load progress we have load from the data lake into the landing layer in the batches and these landing layer are use… --- ## [Errata on "The Data Vault Guru, a pragmatic guide on building a data vault"?](https://forum.data-community.org/t/errata-on-the-data-vault-guru-a-pragmatic-guide-on-building-a-data-vault/1717)
**Author:** [@frank\_boekamp](https://forum.data-community.org/u/frank_boekamp)\ **Replies:** 1\ **Last updated:** [February 7, 2025, 4:20am UTC](https://forum.data-community.org/t/errata-on-the-data-vault-guru-a-pragmatic-guide-on-building-a-data-vault/1717 "2025-02-07T04:20:33Z")
Hello, I’m quite impressed by this book. I’m wondering, does an errata exist for this book? I can not find anything on the internet. Thanks, Frank --- ## [Multi-table insert from staging to raw on Snowflake](https://forum.data-community.org/t/multi-table-insert-from-staging-to-raw-on-snowflake/1700)
**Author:** [@jhall\_uk](https://forum.data-community.org/u/jhall_uk)\ **Replies:** 3\ **Last updated:** [February 4, 2025, 11:00pm UTC](https://forum.data-community.org/t/multi-table-insert-from-staging-to-raw-on-snowflake/1700 "2025-02-04T23:00:28Z")
Hello everyone! I’ve seen a number of sample articles relating to near-real time integration on a Snowflake platform. One article advocates using a combo of staging tables, staging metadata views and streams as a basis … --- ## [How should I model Customer/Invoice relationship?](https://forum.data-community.org/t/how-should-i-model-customer-invoice-relationship/1702)
**Author:** [@christobo](https://forum.data-community.org/u/christobo)\ **Replies:** 3\ **Last updated:** [February 4, 2025, 2:07am UTC](https://forum.data-community.org/t/how-should-i-model-customer-invoice-relationship/1702 "2025-02-04T02:07:02Z")
Hi all! This seems like a simple and common situation but we’re struggling with the right way to do it. We have a customer hub, and an invoice header hub. Invoices are linked to customers, and invoices come from multiple… --- ## [How to model Data Vault when source system has a separate table with history](https://forum.data-community.org/t/how-to-model-data-vault-when-source-system-has-a-separate-table-with-history/1664)
**Author:** [@cx1964](https://forum.data-community.org/u/cx1964)\ **Replies:** 4\ **Last updated:** [February 3, 2025, 12:52pm UTC](https://forum.data-community.org/t/how-to-model-data-vault-when-source-system-has-a-separate-table-with-history/1664 "2025-02-03T12:52:54Z")
Normally history is created when descriptive informatie changes for a specific business key. Those changes are store in a Satellite. Now I have to model a Data Vault where the source system has a separate table for hi… --- ## [DBT vs SQLMesh in context of DWH/DataVault](https://forum.data-community.org/t/dbt-vs-sqlmesh-in-context-of-dwh-datavault/1646)
**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\ **Replies:** 2\ **Last updated:** [February 3, 2025, 9:13am UTC](https://forum.data-community.org/t/dbt-vs-sqlmesh-in-context-of-dwh-datavault/1646 "2025-02-03T09:13:47Z")
Hi, Recently I’ve read about SQLMesh framework as one of the competitors for DBT. It’s definitely way less popular than DBT, but apparently (according to few blog entries) more scalable and better suitable for data eng… --- ## [Qlik Data Movement as source to Snowflake](https://forum.data-community.org/t/qlik-data-movement-as-source-to-snowflake/1701)
**Author:** [@jhall\_uk](https://forum.data-community.org/u/jhall_uk)\ **Replies:** 0\ **Last updated:** [February 2, 2025, 10:22pm UTC](https://forum.data-community.org/t/qlik-data-movement-as-source-to-snowflake/1701 "2025-02-02T22:22:09Z")
Hello everyone! Possibly slightly off-topic for the forum, but the context is within a planned DV2.0 modelled Snowflake target. My customer is looking to deploy Qlik Data Movement (it seems to have multiple names) as a… --- ## [Multi hub from one source. Split the satellite ?](https://forum.data-community.org/t/multi-hub-from-one-source-split-the-satellite/1687)
**Author:** [@justinV](https://forum.data-community.org/u/justinV)\ **Replies:** 4\ **Last updated:** [January 31, 2025, 9:42am UTC](https://forum.data-community.org/t/multi-hub-from-one-source-split-the-satellite/1687 "2025-01-31T09:42:08Z")
Hi everybody! I need some advice regarding best practices in hub/satellite modelisation. I have 2 hub : hub\_employee and hub\_company I have a source that give me data about employee AND company (a bool on each line s… --- ## [Immutable Business Key for Customer Contact](https://forum.data-community.org/t/immutable-business-key-for-customer-contact/1677)
**Author:** [@Jeff](https://forum.data-community.org/u/Jeff)\ **Replies:** 2\ **Last updated:** [January 23, 2025, 6:02am UTC](https://forum.data-community.org/t/immutable-business-key-for-customer-contact/1677 "2025-01-23T06:02:42Z")
Hi all, I’m new to DVUG, but have been lurking these pages trying to expand my knowledge of DV2.0 beyond the basics, and to decide if DV is the right way to go for a new data platform I’m designing. I’ve read a few sim… --- ## [Trial users wanted for a new end to end data vault to metrics AI enabled automation](https://forum.data-community.org/t/trial-users-wanted-for-a-new-end-to-end-data-vault-to-metrics-ai-enabled-automation/1681)
**Author:** [@Nat](https://forum.data-community.org/u/Nat)\ **Replies:** 0\ **Last updated:** [January 22, 2025, 2:13pm UTC](https://forum.data-community.org/t/trial-users-wanted-for-a-new-end-to-end-data-vault-to-metrics-ai-enabled-automation/1681 "2025-01-22T14:13:40Z")
Hi everyone Wanted - trial users for Calon Backbone, our AI-enabled data warehouse / data vault automation solution. The first 5 trial users we get will get all the dbt code generated for free so they can run it themsel… --- ## [Parallel loading of Raw Data Vault and Data Mart from Staging.](https://forum.data-community.org/t/parallel-loading-of-raw-data-vault-and-data-mart-from-staging/1667)
**Author:** [@Rammohan](https://forum.data-community.org/u/Rammohan)\ **Replies:** 1\ **Last updated:** [January 19, 2025, 1:45am UTC](https://forum.data-community.org/t/parallel-loading-of-raw-data-vault-and-data-mart-from-staging/1667 "2025-01-19T01:45:51Z")
Hi All, In our organisation we are in the process of including a raw data vault layer in our architecture. However there are still some questions from different teams around the necessity and the added complexity it bri… --- ## [Data Vault Links (1:n relaiton)](https://forum.data-community.org/t/data-vault-links-1-n-relaiton/1658)
**Author:** [@Abdallah.77](https://forum.data-community.org/u/Abdallah.77)\ **Replies:** 2\ **Last updated:** [January 13, 2025, 11:51pm UTC](https://forum.data-community.org/t/data-vault-links-1-n-relaiton/1658 "2025-01-13T23:51:03Z")
Hello I am currently working with raw data in Snowflake, I have a table contains two BK’s that their relationship is 1:n I faced an issue for example, my raw data gets updated frequently. An account that holds account\_… --- ## [Applied and Load dates as full datetime](https://forum.data-community.org/t/applied-and-load-dates-as-full-datetime/1651)
**Author:** [@KostyaRico](https://forum.data-community.org/u/KostyaRico)\ **Replies:** 1\ **Last updated:** [January 2, 2025, 9:54am UTC](https://forum.data-community.org/t/applied-and-load-dates-as-full-datetime/1651 "2025-01-02T09:54:50Z")
Hi! A simple but novice question - why Applied and Load dates in DV are dates but not dates with time? I was thinking about intraday loading patterns for DV artifacts. (For example a simple case of changing attribute v… --- ## [Multi-active Satellites](https://forum.data-community.org/t/multi-active-satellites/866)
**Author:** [@DikshaSaha](https://forum.data-community.org/u/DikshaSaha)\ **Replies:** 2\ **Last updated:** [December 12, 2024, 9:52pm UTC](https://forum.data-community.org/t/multi-active-satellites/866 "2024-12-12T21:52:04Z")
Has anyone here implemented multi-active satellites using Automate DV package of DBT? I have a scenario of creating Data Vault on an XML file data. This file is having multiple nested elements for each unique identifier… --- ## [How to design hub & satellite for customer dimension](https://forum.data-community.org/t/how-to-design-hub-satellite-for-customer-dimension/1642)
**Author:** [@RArchitect](https://forum.data-community.org/u/RArchitect)\ **Replies:** 1\ **Last updated:** [December 12, 2024, 9:09pm UTC](https://forum.data-community.org/t/how-to-design-hub-satellite-for-customer-dimension/1642 "2024-12-12T21:09:27Z")
Hi, I am a first timer on Delta Vault Architecture and trying to Data Model from scratch. Here is my problem statement. I have one Customer Master source which I am planning to convert in one Hub and One satellite. I … --- ## [Data Vault Integration for Dashboard Data Extraction](https://forum.data-community.org/t/data-vault-integration-for-dashboard-data-extraction/1628)
**Author:** [@tg3](https://forum.data-community.org/u/tg3)\ **Replies:** 3\ **Last updated:** [December 12, 2024, 2:09pm UTC](https://forum.data-community.org/t/data-vault-integration-for-dashboard-data-extraction/1628 "2024-12-12T14:09:41Z")
Hello everyone, I’m working on a Data Vault implementation that currently includes Hubs, Links, and Satellites, including multi-active satellites and satellite links. The model is still in the development phase, so we’r… --- ## [Hub - Link - Satellite ](https://forum.data-community.org/t/hub-link-satellite/1617)
**Author:** [@JaimeVadell](https://forum.data-community.org/u/JaimeVadell)\ **Replies:** 1\ **Last updated:** [November 25, 2024, 9:55pm UTC](https://forum.data-community.org/t/hub-link-satellite/1617 "2024-11-25T21:55:15Z")
Hello everyone, I have a question regarding Data Vault 2.0 modeling. Is it valid to establish a connection between a hub, a link, and a satellite, considering there is only one hub involved in the relationship? The cha… --- ## [PIT and Bridge tables generation with RV tables](https://forum.data-community.org/t/pit-and-bridge-tables-generation-with-rv-tables/1606)
**Author:** [@kvs.naidu](https://forum.data-community.org/u/kvs.naidu)\ **Replies:** 1\ **Last updated:** [November 16, 2024, 7:03am UTC](https://forum.data-community.org/t/pit-and-bridge-tables-generation-with-rv-tables/1606 "2024-11-16T07:03:09Z")
Hello threre, I have multile questions. i m listing below. How many minimum number table we need to generate a pit and bridge table? As i understad, PIT Minumum 1hub 2 sats Maximum 1hub x number of sats … --- ## [BKCC used twice in generating a HK for a link table](https://forum.data-community.org/t/bkcc-used-twice-in-generating-a-hk-for-a-link-table/1598)
**Author:** [@robert](https://forum.data-community.org/u/robert)\ **Replies:** 5\ **Last updated:** [November 11, 2024, 10:46pm UTC](https://forum.data-community.org/t/bkcc-used-twice-in-generating-a-hk-for-a-link-table/1598 "2024-11-11T22:46:51Z")
Hi, I’m asking this because I don’t understand why we are doing it. We are creating hubs which use BKCC+BK to generate a HK. e.g. (not the actual tables) person\_hub has PERSON\_HK generated from BKCC + PERSON\_BK cours… --- ## [Composite key , more than 1 business keys](https://forum.data-community.org/t/composite-key-more-than-1-business-keys/1575)
**Author:** [@CuriousMind](https://forum.data-community.org/u/CuriousMind)\ **Replies:** 5\ **Last updated:** [November 10, 2024, 9:57pm UTC](https://forum.data-community.org/t/composite-key-more-than-1-business-keys/1575 "2024-11-10T21:57:06Z")
Hello All, We have many entities where we have more than 1 business keys (composite key) . Is it better to have them concatenated together as a single business key or keep them as different columns ? What is the impac… [Previous page](https://forum.data-community.org/latest.md?page=2) [Next page](https://forum.data-community.org/latest.md?page=4)