# Tools **URL:** https://forum.data-community.org/c/tools/15.md [Latest](https://forum.data-community.org/latest.md) · [Categories](https://forum.data-community.org/categories.md) · [Tags](https://forum.data-community.org/tags.md) --- ## [About the Tools category](https://forum.data-community.org/t/about-the-tools-category/1960)
**Author:** [@RhysHanscombe](https://forum.data-community.org/u/RhysHanscombe)\ **Replies:** 0
--- ## [Semantic Layer Stories](https://forum.data-community.org/t/semantic-layer-stories/2174)
**Author:** [@Frankie](https://forum.data-community.org/u/Frankie)\ **Replies:** 3\ **Last updated:** [October 1, 2026, 2:12am UTC](https://forum.data-community.org/t/semantic-layer-stories/2174 "2026-10-01T02:12:02Z")
Anyone built a semantic layer on top of their DV2.X solution yet? What was your experience, did you have any issues with stakeholder engagement? What sort of tooling did you use, any pros/cons? Interested to see peopl… --- ## [Meet the IRiS Assistant](https://forum.data-community.org/t/meet-the-iris-assistant/2120)
**Author:** [@JulienRedmond](https://forum.data-community.org/u/JulienRedmond)\ **Replies:** 1\ **Last updated:** [June 28, 2026, 11:21pm UTC](https://forum.data-community.org/t/meet-the-iris-assistant/2120 "2026-06-28T23:21:37Z")
Here is what you can get done in under 15 minutes if the silver layer of your Lakehouse is automated. --- ## [VaultSpeed News Letter - What's New in June 26](https://forum.data-community.org/t/vaultspeed-news-letter-whats-new-in-june-26/2131)
**Author:** [@kevin.monk](https://forum.data-community.org/u/kevin.monk)\ **Replies:** 0\ **Last updated:** [June 23, 2026, 3:02pm UTC](https://forum.data-community.org/t/vaultspeed-news-letter-whats-new-in-june-26/2131 "2026-06-23T15:02:58Z")
We just launched our monthly LinkedIn newsletter and the first edition is live! “What’s New in June” is packed: • We’re at Databricks Data + AI Summit next week, come find us at booth #112 • Webinar on June 23rd: What… --- ## [Effect on link structure if source table changes structure](https://forum.data-community.org/t/effect-on-link-structure-if-source-table-changes-structure/1217)
**Author:** [@kvs.naidu](https://forum.data-community.org/u/kvs.naidu)\ **Replies:** 4\ **Last updated:** [June 8, 2026, 12:23am UTC](https://forum.data-community.org/t/effect-on-link-structure-if-source-table-changes-structure/1217 "2026-06-08T00:23:58Z")
Hello All, I have been thinking about this? table 1 - car (car\_id) table 2 - customer (cust\_id) table 3 - salesinvoice (inv\_id(pk),card\_id(fk),cust\_id(fk)) When i generate data vault model on salesinvoice table i go… --- ## [VaultSpeed - Agentic Framework - Live Intro](https://forum.data-community.org/t/vaultspeed-agentic-framework-live-intro/2105)
**Author:** [@kevin.monk](https://forum.data-community.org/u/kevin.monk)\ **Replies:** 0\ **Last updated:** [May 26, 2026, 3:19pm UTC](https://forum.data-community.org/t/vaultspeed-agentic-framework-live-intro/2105 "2026-05-26T15:19:33Z")
There’s a gap automation has never quite reached around the data vault. Source profiling, business key identification, entity mapping on the way in. Semantic layer design, data products, and data contracts on the way out… --- ## [VaultSpeed NEXT London | 11th March 2026 - 13:00 - 18:00 GMT](https://forum.data-community.org/t/vaultspeed-next-london-11th-march-2026-13-00-18-00-gmt/2036)
**Author:** [@RhysHanscombe](https://forum.data-community.org/u/RhysHanscombe)\ **Replies:** 0\ **Last updated:** [February 3, 2026, 11:33am UTC](https://forum.data-community.org/t/vaultspeed-next-london-11th-march-2026-13-00-18-00-gmt/2036 "2026-02-03T11:33:58Z")
2026-03-11T13:00:00Z (UTC)→2026-03-11T18:00:00Z (UTC) Join us in London, together with AWS, for a community event where data leaders come together to explore how data engineering and analytics are evolving in an AI-d… --- ## [Webinar: Migrating from SQL Server to Azure & Microsoft Fabric: What Works, What Breaks, and How to Avoid Costly Mistakes](https://forum.data-community.org/t/webinar-migrating-from-sql-server-to-azure-microsoft-fabric-what-works-what-breaks-and-how-to-avoid-costly-mistakes/2026)
**Author:** [@RhysHanscombe](https://forum.data-community.org/u/RhysHanscombe)\ **Replies:** 0\ **Last updated:** [January 16, 2026, 2:57pm UTC](https://forum.data-community.org/t/webinar-migrating-from-sql-server-to-azure-microsoft-fabric-what-works-what-breaks-and-how-to-avoid-costly-mistakes/2026 "2026-01-16T14:57:35Z")
Join an expert panel discussion on real-world SQL Server to Azure and Microsoft Fabric migrations. Legacy SQL environments rarely move cleanly to the cloud. Without rethinking architecture, governance, and operating … --- ## [Effectivity Satellite from Intersection Table with Payload](https://forum.data-community.org/t/effectivity-satellite-from-intersection-table-with-payload/1942)
**Author:** [@darkchanter](https://forum.data-community.org/u/darkchanter)\ **Replies:** 1\ **Last updated:** [December 2, 2025, 11:03am UTC](https://forum.data-community.org/t/effectivity-satellite-from-intersection-table-with-payload/1942 "2025-12-02T11:03:36Z")
Hi, I recently started to learn AutomateDV. It works quite well, but I’m struggeling a little with specific link-satellites. Consider a simple m:m relation coming from an intersection table: create table "source".cse\_… --- ## [AutomateDV advise](https://forum.data-community.org/t/automatedv-advise/1946)
**Author:** [@rudra](https://forum.data-community.org/u/rudra)\ **Replies:** 4\ **Last updated:** [November 28, 2025, 10:58am UTC](https://forum.data-community.org/t/automatedv-advise/1946 "2025-11-28T10:58:40Z")
Does anyone implemented AutomateDV in data vault project in Snowflake ? I watched all the videos about AutomateDV. There are few questions on how to use AutomateDV in Snowflake ? How to create and use Streams and Task… --- ## [Support for dbt-core 1.10.x with the dbt-snowflake adapter?](https://forum.data-community.org/t/support-for-dbt-core-1-10-x-with-the-dbt-snowflake-adapter/1959)
**Author:** [@saqib](https://forum.data-community.org/u/saqib)\ **Replies:** 1\ **Last updated:** [September 25, 2025, 11:36am UTC](https://forum.data-community.org/t/support-for-dbt-core-1-10-x-with-the-dbt-snowflake-adapter/1959 "2025-09-25T11:36:06Z")
Hi, I just wanted to check if anyone is the using the latest AutomateDV macros with dbt-core 1.10.x with the dbt-snowflake adapter? Any issues? Thanks, Saqib --- ## [The Data Vault Staging Balancing Act: Purity vs. Practicality](https://forum.data-community.org/t/the-data-vault-staging-balancing-act-purity-vs-practicality/1906)
**Author:** [@liberrenaud](https://forum.data-community.org/u/liberrenaud)\ **Replies:** 4\ **Last updated:** [August 5, 2025, 8:20am UTC](https://forum.data-community.org/t/the-data-vault-staging-balancing-act-purity-vs-practicality/1906 "2025-08-05T08:20:56Z")
Hello AutomateDV community, I’m new to Data Vault 2.0 and have a foundational question about the proper use of the staging area. I understand the principle that the Raw Vault should be an unaltered, auditable copy of th… --- ## [Modeling Firebase app logs](https://forum.data-community.org/t/modeling-firebase-app-logs/1907)
**Author:** [@saqib](https://forum.data-community.org/u/saqib)\ **Replies:** 9\ **Last updated:** [July 19, 2025, 9:26pm UTC](https://forum.data-community.org/t/modeling-firebase-app-logs/1907 "2025-07-19T21:26:48Z")
We working on modeling out Android App Logs. Android Apps can be used across multiple devices by the same user. We have hub\_app, hub\_user and hub\_screen\_id. screen\_id is a unique ID of the screen which was opened by the… --- ## [dbt model versions and DV history](https://forum.data-community.org/t/dbt-model-versions-and-dv-history/1813)
**Author:** [@mmtar](https://forum.data-community.org/u/mmtar)\ **Replies:** 1\ **Last updated:** [April 9, 2025, 10:07am UTC](https://forum.data-community.org/t/dbt-model-versions-and-dv-history/1813 "2025-04-09T10:07:50Z")
Hi, we are starting to ramp up AutomateDV, dbt, data contracts and model versioning. I was wondering how model versioning will work with incremental models for satellites if business logic evolves. For instance: Stag… --- ## [AutomateDV Initial Load](https://forum.data-community.org/t/automatedv-initial-load/1789)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 1\ **Last updated:** [March 27, 2025, 10:32pm UTC](https://forum.data-community.org/t/automatedv-initial-load/1789 "2025-03-27T22:32:46Z")
We have a reliable date received in one of our data feeds. To initially load the data, I assume it is fair game to use the date received as the load date time in Dbt Vault, and then change back to the run date. --- ## [Clarification on src\_eff: "EFFECTIVE\_FROM" in Staging Files](https://forum.data-community.org/t/clarification-on-src-eff-effective-from-in-staging-files/1776)
**Author:** [@MarkyMark](https://forum.data-community.org/u/MarkyMark)\ **Replies:** 3\ **Last updated:** [March 21, 2025, 9:30am UTC](https://forum.data-community.org/t/clarification-on-src-eff-effective-from-in-staging-files/1776 "2025-03-21T09:30:23Z")
Is the effective from the updated/modified date in a data source, assuming that it is reliable, or is it the created date, meaning that it will always be the same regardless of the load? If the record is updated, is it … --- ## [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… --- ## [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… --- ## [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 convert Unix seconds to date type in staging macro ](https://forum.data-community.org/t/how-to-convert-unix-seconds-to-date-type-in-staging-macro/1553)
**Author:** [@CuriousMind](https://forum.data-community.org/u/CuriousMind)\ **Replies:** 1\ **Last updated:** [October 15, 2024, 9:42am UTC](https://forum.data-community.org/t/how-to-convert-unix-seconds-to-date-type-in-staging-macro/1553 "2024-10-15T09:42:04Z")
Hi , I want to convert Unix seconds like (12345678)format to date YYYY-MM-DD in staging macro . I am using bigquery with automatedv --- ## [First try AutomateDV - what are the correct keys?](https://forum.data-community.org/t/first-try-automatedv-what-are-the-correct-keys/1443)
**Author:** [@datavaultmon](https://forum.data-community.org/u/datavaultmon)\ **Replies:** 1\ **Last updated:** [July 31, 2024, 9:55pm UTC](https://forum.data-community.org/t/first-try-automatedv-what-are-the-correct-keys/1443 "2024-07-31T21:55:52Z")
Hi together, I have a total noob question but we have just started testing Automate DV :leichtes\_lächeln: So, there are two staging tables involved in this, stg\_eafako and stg\_eakopf. They both have a EAFAKO\_ID and EAKO… --- ## [AutomateDV vs dataVault4dbt](https://forum.data-community.org/t/automatedv-vs-datavault4dbt/1393)
**Author:** [@kasia](https://forum.data-community.org/u/kasia)\ **Replies:** 8\ **Last updated:** [July 23, 2024, 6:18pm UTC](https://forum.data-community.org/t/automatedv-vs-datavault4dbt/1393 "2024-07-23T18:18:57Z")
Dear Data-Vaulters, I’m about to choose which data vault package for dbt will be used in my company. Do you have experiences with automateDV and/or datavault4dbt? Which one is better? To make things more complex on my … --- ## [Column aliasing in HUBs and LINKS](https://forum.data-community.org/t/column-aliasing-in-hubs-and-links/1408)
**Author:** [@Sushmitha](https://forum.data-community.org/u/Sushmitha)\ **Replies:** 1\ **Last updated:** [July 15, 2024, 10:50pm UTC](https://forum.data-community.org/t/column-aliasing-in-hubs-and-links/1408 "2024-07-15T22:50:08Z")
Hello, we have a requirement to load a column from stage as different column name in hub and satellite. We were able to use alias in satellites but not in hubs and links. Is it possible to enable column aliasing in hubs … --- ## [database error while doing worked exmaple in docs](https://forum.data-community.org/t/database-error-while-doing-worked-exmaple-in-docs/1172)
**Author:** [@angel-s](https://forum.data-community.org/u/angel-s)\ **Replies:** 2\ **Last updated:** [June 26, 2024, 12:36pm UTC](https://forum.data-community.org/t/database-error-while-doing-worked-exmaple-in-docs/1172 "2024-06-26T12:36:37Z")
Runtime Error Database error while listing schemas in database “DV\_PROTOTYPE\_DB” Database Error 250001: Could not connect to Snowflake backend after 1 attempt(s).Aborting --- ## [Sat hash Diff Calculation](https://forum.data-community.org/t/sat-hash-diff-calculation/1243)
**Author:** [@kvs.naidu](https://forum.data-community.org/u/kvs.naidu)\ **Replies:** 1\ **Last updated:** [April 10, 2024, 9:56am UTC](https://forum.data-community.org/t/sat-hash-diff-calculation/1243 "2024-04-10T09:56:15Z")
Usually hash difference in satellite calculates on user columns. it is like md5(name+address+pincode+country). is it good to include foreign keys in hash diff calculation ? md5(name+address+pincode+country+region\_id(fk… --- ## [Loading from multiple sources to form a union-based transactional link](https://forum.data-community.org/t/loading-from-multiple-sources-to-form-a-union-based-transactional-link/800)
**Author:** [@Hugo](https://forum.data-community.org/u/Hugo)\ **Replies:** 4\ **Last updated:** [January 2, 2024, 9:09am UTC](https://forum.data-community.org/t/loading-from-multiple-sources-to-form-a-union-based-transactional-link/800 "2024-01-02T09:09:56Z")
Hello, I need to implement a transactional link in dbtvault with two sources. In the dbtvault documentation, it is said that it is possible to do that for Links, but it is not for possible transactional links. What worka… --- ## [Loading the same HUB as part of two different DBT jobs](https://forum.data-community.org/t/loading-the-same-hub-as-part-of-two-different-dbt-jobs/1085)
**Author:** [@saqib](https://forum.data-community.org/u/saqib)\ **Replies:** 13\ **Last updated:** [December 13, 2023, 11:47pm UTC](https://forum.data-community.org/t/loading-the-same-hub-as-part-of-two-different-dbt-jobs/1085 "2023-12-13T23:47:00Z")
Hi, We have a HUB\_ORDER that integrates ORDERs from Netsuite and Salesforce. The cadence for new Order data from Salesforce and Netsuite is different. So we have two DBT jobs that load data from these sources into their… --- ## [Indexing in SQL server and DV 2.0](https://forum.data-community.org/t/indexing-in-sql-server-and-dv-2-0/917)
**Author:** [@DVBeginner](https://forum.data-community.org/u/DVBeginner)\ **Replies:** 2\ **Last updated:** [November 4, 2023, 8:55am UTC](https://forum.data-community.org/t/indexing-in-sql-server-and-dv-2-0/917 "2023-11-04T08:55:29Z")
Hello I started testing the automatedv and found that only clustered columnstore indexes are added for all tables. Would you still add additional indexes? E g. Unique non-clustered for hash keys of hubs and links, busin… --- ## [START\_DATE and END\_DATE in EFF\_SAT macro](https://forum.data-community.org/t/start-date-and-end-date-in-eff-sat-macro/597)
**Author:** [@saqib](https://forum.data-community.org/u/saqib)\ **Replies:** 17\ **Last updated:** [June 6, 2023, 8:00am UTC](https://forum.data-community.org/t/start-date-and-end-date-in-eff-sat-macro/597 "2023-06-06T08:00:34Z")
Hi Is anyone using the DBT Effectivity SAT macro? I want to understand the pattern for capturing the START\_DATE and END\_DATE when the source doesn’t provide it. We have ORDER\_HK as the driving key. And CUSTOMER\_HK as th… --- ## [Automate\_dv in dbt - not working](https://forum.data-community.org/t/automate-dv-in-dbt-not-working/815)
**Author:** [@Nat](https://forum.data-community.org/u/Nat)\ **Replies:** 1\ **Last updated:** [May 24, 2023, 6:55am UTC](https://forum.data-community.org/t/automate-dv-in-dbt-not-working/815 "2023-05-24T06:55:35Z")
Hi @alex.higgs When I tried the automate\_dv effectivity sat, the error told me that the macro automate\_dv wasn’t available but when i replaced the term in the code with dbtvault it worked… Any ideas? Using 0.9.5 [Next page](https://forum.data-community.org/c/tools/15.md?page=1)