Skip to content
DataOps.live Professional EditionNEW
Purpose-built environment for small data teams and dbt Core developers.
DataOps.live Enterprise Edition
DataOps.live is the leading provider of Snowflake environment management, end-to-end orchestration, CI/CD, automated testing & observability, and code management, wrapped in an elegant developer interface.
Spendview for Snowflake FREE

An inexpensive, quick and easy way to build beautiful responsive website pages without coding knowledge.


Pricing and Edition

See whats included in our Professional and Enterprise Editions.

Getting Started
Docs- New to DataOps.liveStart learning by doing. Create your first project and set up your DataOps execution environment.
Join the Community
Join the CommunityFind answers to your DataOps questions, collaborate with your peers, share your knowledge!
#TrueDataOps Podcast
#TrueDataOps PodcastWelcome to the #TrueDataOps podcast with your host Kent Graziano, The Data Warrior!
Resource Hub
On-demand resources: eBooks, white papers, videos, webinars.

Customer Stories
Academy

Enroll in the DataOps.live Academy to take advantage of training courses. These courses will help you make the most out of DataOps.live.


Learning Resources
A collection of resources to support your learning journey.
Events
Connect with fellow professionals, expand your network, and gain knowledge from our esteemed product and industry experts.
Blogs

Stay updated with the latest insights and news from our DataOps team and community.


#TrueDataOps.org
#TrueDataOps is defined by seven key characteristics or pillars:
In The News

In The News

Stay up-to-date with the latest developments, press releases, and news.
About Us
About UsFounded in 2020 with a vision to enhance customer insights and value, our company has since developed technologies focused on DataOps.
Careers

Careers

Join the DataOps.live team today! We're looking for colleagues on our Sales, Marketing, Engineering, Product, and Support teams.
Data with SAP
Guy Adams - CTO, DataOps.liveApr 9, 2024 5:48:31 PM4 min read

Building SAP Data Tables in Snowflake made simple with DataOps Assist

Building SAP Data Tables in Snowflake made simple with DataOps Assist
6:02

Have you ever struggled to create sample SAP tables or find meaningful data online? Navigating SAP data can be challenging as it requires a blend of technical know-how, an understanding of business processes, and familiarity with SAP systems.  

DataOps.live Assist is your go-to tool! With its mix of artificial intelligence and human intuition, creating valuable SAP insights on Snowflake has never been simpler. 

Join me as we explore the magic of DataOps.live Assist. See how Assist simplifies the process of generating sample SAP data without having any knowledge about SAP. At the end of this blog post, you can access a video demonstration to complement it. 

Let's step into a scenario where we create sample SAP models—KNA1, KNB1, KNVI, KNVV, VBAK, and VBAP—focusing on customer and sales data. These table names may seem cryptic at first glance, but each holds valuable information within the SAP systems, such as the SAP R\3 ERP system.  

We’ll then merge these tables to generate a comprehensive view of customer and sales insights. Throughout this process, we'll interact with Assist by asking questions in straightforward human language or providing prompts to achieve our desired outcome.

Understanding cryptic and obscure SAP metadata 

Assist can understand SAP data, even when the table names and columns are obscure. It can interpret human questions, understand the semantic meaning behind them, and craft advanced SQL queries to extract relevant insights. 

With just a simple question such as What SAP tables do you know about?" Assist can provide you with a business-related response showing how SAP data is organized and structured in various modules within the system, such as Master Data (MD), Finance (FI), Controlling (CO), Sales and Distribution (SD), and Material Management (MM).  1-understand-sap-metadata


Creating meaningful sample SAP data
 

Generating meaningful sample SAP data can be a tough task. However, with Assist this process becomes simple. Assist automatically generates example SAP tables filled with thousands of rows of sample data. It ensures that the data is referentially correct, making it suitable for various analytical tasks. 

Let's consider the scenario where we task Assist with generating customer master data. Achieving this requires just a minimal prompt and a few hints applicable to any sample data generation process 

For example: Create a dbt model to create SAP KNA1 table with all the possible columns that usually exist for a table within SAP and 1000 rows of sample data, each of the right data type, using the Snowflake SEQ4 GENERATOR and TABLE functions without WINDOW functions. Don't use ROW_NUMBER or WINDOW functions. Use SEQ4() to generate the ID. Ensure no duplicate columns. Include the prompt to create the model at the top as documentation in the dbt config block.”  

2-create-sap-sample


Building SAP models
 

After creating the sample preview, Assist creates the SAP model for KNA1 with the necessary columns. Once we run the generated SQL query and the model, it creates sample data, too.  

Next, we use the same approach to create: 

  • KNB1, ensuring it includes all the columns needed to join the previously generated KNA1 table. 
  • KNVI, using Assist’s increased context to replicate the process for a specific table name as before. 
  • KNVV, VBAK, and VBAP, where Assist even predicts our intention to create these tables. Consequently, we continue with the same process for these other tables. 

As a result, we now have models that generate a thousand rows of sample data, all running inside Snowflake without the need for complex SQL queries or SAP expertise. 3-create-sap-sample-knvv

 4-create-sap-sample-vbap-vbak


Visualizing SAP tables relationships
 

With just a simple prompt to create an ERD in mermaid format for the models and their columns, Assist generates a diagram showing the connection between the models and their columns.  

5-create-sap-sample-diagram

Now, we have a clear understanding of their relationship: KNB1, KNVI, and KNV are directly linked to KNA1, while VBAP is connected through VBAK. 


Joining SAP tables
 

With the prompt “create a model that joins all 6 tables together”—or any similar straightforward request—Assist integrates these tables, initiating the creation of a unified model. It accurately interprets the request and offers a comprehensive view of customer and sales data. It shows its ability to understand the significance of these tables and infer the insights gained from joining them. 

Upon previewing the model, we now have a cohesive customer and sales table, affirming the accuracy of our join keys. 6-create-sap-sample-join-model


Creating tests
 

By simply asking Assist to help in plain English, we can generate a test file for each model, incorporating referential integrity checks. This critical step guarantees the accuracy and reliability of our dataset. 

Assist generates the test files for the SAP models, enabling us to validate the data with confidence. With the assurance of the data integrity, we now have a valuable dataset to support our demos. 7-create-sap-sample-tests


Conclusion
 

DataOps.live Assist not only understood SAP data but also generated cohesive sample tables quickly. It simplifies the entire process with its automation capabilities for sample data generation, model construction, table joining, and test creation. With Assist, you can focus on deriving valuable insights from SAP data without the need for specialized SAP knowledge or expertise. 

Ready to experience the power of DataOps.live Assist for yourself? Watch this video for a visual walkthrough of this blog post and unlock the full potential of your SAP data on Snowflake. Get started today to speed up and start enjoying the way you extract value from your data. 

 

Discover how Assist unlocks SAP insights on Snowflake in our newest blog post, "How DataOps.live Assist Creates SAP Insights on Snowflake in Seconds. 

Schedule a demo to see the full DataOps.live platform. 

avatar

Guy Adams - CTO, DataOps.live

Snowflake Global #1 Data SuperHero! An experienced CTO and VP, I'm passionate about DataOps. I've spent 20+ years running software development organizations and now my focus is on bringing the principles and business value from DevOps and CI/CD to data. Cofounder of the truedataops.org movement. Also Dad, technologist, (over) engineer, amateur inventor, skier, and mildly eccentric.

RELATED ARTICLES