Hero Backgroud Elements 2
Back to all Resources

When to use SQL Modeling vs. Graphical Modeling

In SAP Data Warehouse Cloud, you may have noticed the letters "SQL" in the Data Builder. SQL – structured query language – is a computer language that lets you talk to a database. With SQL, you can do several things in a database like retrieve information and even create or modify tables.

SQL-based modeling is available in SAP Data Warehouse Cloud as an alternative to the graphical drag-and-drop view modeler. They both retrieve information from your database; the difference is the technique you use to ask the questions. SQL retrieves information with text-based commands, and the graphical view lets you drag and drop elements into your model and visually build your connections. Behind the scenes, the same things are happening.

Which one should you use?

Well, it's up to you. Both ways end up in the same question sent to the database and return the same result. We wanted to provide you with both options so you can use the one that works better for you. In the end, the same view/table is being created in the repository, no matter how you define it.

If you are interested in learning SQL, you can try building your model in the Data Builder and with the SQL view editor.

For more information on SQL, check out our article "Deep Dive: What is SQL Modeling."

Was this post helpful?

Author
Maarten Rikken Maarten Rikken
Maarten Rikken is a Senior Solutions and Product Marketing Specialist in the SAP Digital Strategy Team.
Keep in touch

SAP HANA Cloud Services delivers solutions maximizing the value of your data. Get on the mailing list and receive all the latest updates.

Subscribe