4. Let’s get to the fun part by clicking the “Open Solution”
Getting Started with GraphStudio
1. Login Page
When you hit “open solutions” you will see a screen like the one below.
The first step will be to login to your provisioned instance. By default, the username is “tigergraph” and the password is the one you choose when provisioning the instance.
Side Note: before we can Explore and Query the data, we need to first do the following (which we will cover in steps 2,3,4)
2. Publish Schema Design
Click on the “Design Schema” tab.
This is your Schema Design Studio. Think of it as your data modeling space.
Design Schema Tab
One thing that is important when designing the database (aka building the schema) is thinking about how you should structure the data, how is it going to be accessed, are there certain types of algorithms that you will need to account for?
For more information on schema modeling checkout this helpful video.
For the purpose of this tutorial, you will just need to hit the “publish”button which will activate your current design.
Or, if you want to get fancy, try adding a few more vertices or edges.
Done? Let’s move on.
3. Data Mapping
Click on the “Map Data to Graph” tab.
Now that we have the data model published, we can create a data mapping of how the data should be inserted into the graph.
For this example, you see that we have two files, a “friendship.csv” file pointing to the edge “friendship” & a “person.csv” file that points to the “person” vertex.
If you want to explore, click around on edges, files, icons, and vertices… Just be careful of the “delete” button.
Data Mapping Tab
Now double click on one of the edges.
Focus your eyes on the right (of the image above), you will notice how the data or the current file is mapped.
The neat part about these starter kits is that all of the data is pre-mapped. All you need to do is “Publish” the data mapping.
If you have chosen a blank demo. No worries. Just add your data file and then “map data” to Vertex or Edge (reference the icon tools above).
At this stage we have the schema built and data file mapped. Looking on the right you will notice that there is no data in the graph. That is because we will need to choose 1 or all of the files to initiate the data loading procedure.
Simply click the “play” button to load all the files. It’s that simple.
Data Loading Tab
5. Data Exploration
Click on the “Explore Graph” tab.
Finally, we made it to the fun stuff!
What you’re seeing below is one of the most powerful graph exploration tools. It allows you to access your data and crawl your data without writing a single line of code. This is the page where you can have the MOST fun.
My recommendation is to just start clicking around:
– Pick Random Vertices.
– Try Expanding Vertices.
– Try Expanding Only Certain Edges
6. Query Building
Click on the “Write Queries” tab.
As much fun as you had above.. this is where the MAGIC happens. Yes, MAGIC in all CAPS! Haha.
Why is it MAGIC? Because GSQL is a turning complete language meaning you can do absolutely anything with it.
But wait there is more.. (always wanted to say that after watching all the commercials)
My favorite feature is every query you build… The query gets automagically exposed as a REST service.
Ok, maybe I’m the only one that finds this truly marvelous. But never the less it’s super convenient because after you write something it immediately becomes functional.
Let’s test this out (reference image above for places you should click):
– Click on the “hello” query — This query is designed for the user to put a name into the parameter and the logic is to find all the people that that user is friends with.
– Click the “Install” button
– Click the “Run” button
Now it’s ready for a parameter. You can try “Tom”.
What do you see? Do you see the connections? Awesome Right? You just literally passed a parameter to the REST endpoint to get these results.
– Click “View JSON” — Now you will see the JSON that TigerGraph returns.
Your first time writing GSQL queries? I would recommend the following two resources to help get started:
WHY THIS IS EXCITING?! — In a matter of minutes not only did you provision a graph… but, you created a schema, you mapped data, you loaded data, you wrote a parameterized query that was exposed as a REST endpoint and then called that query via the REST endpoint.
Dr. Jay Yu is the VP of Product and Innovation at TigerGraph, responsible for driving product strategy and roadmap, as well as fostering innovation in graph database engine and graph solutions. He is a proven hands-on full-stack innovator, strategic thinker, leader, and evangelist for new technology and product, with 25+ years of industry experience ranging from highly scalable distributed database engine company (Teradata), B2B e-commerce services startup, to consumer-facing financial applications company (Intuit). He received his PhD from the University of Wisconsin - Madison, where he specialized in large scale parallel database systems
Todd Blaschka |COO
Todd Blaschka is a veteran in the enterprise software industry. He is passionate about creating entirely new segments in data, analytics and AI, with the distinction of establishing graph analytics as a Gartner Top 10 Data & Analytics trend two years in a row. By fervently focusing on critical industry and customer challenges, the companies under Todd's leadership have delivered significant quantifiable results to the largest brands in the world through channel and solution sales approach. Prior to TigerGraph, Todd led go to market and customer experience functions at Clustrix (acquired by MariaDB), Dataguise and IBM.