Quickstart with the Query & Admin Console

After deploying AnzoGraph, you can get a quick start to loading data and running SPARQL queries by using the GUI-based Query & Admin Console.

The Query & Admin Console is installed and automatically available with all deployment methods except for the RHEL/CentOS Tarball option. See Deploying the AnzoGraph Frontend Console Container for instructions on installing the console separately with a Docker container in those environments. The Console can also be deployed separately by running the Installer script program available from the AnzoGraph Download page. (See Installing AnzoGraph for information on running the Installer.)

This brief tutorial introduces you to the AnzoGraph Query/Admin Console and gets you started with loading data and running SPARQL queries.

  1. Log in to the Query Console
  2. Load and Query Sample Data
  3. Load and Query Your Own Data

Log in to the Query Console

The AnzoGraph console supports the latest Safari, Google Chrome, and Mozilla Firefox browsers. Microsoft Edge and Internet Explorer are not supported at this time.

  1. Depending on whether you deployed AnzoGraph using the Docker CE, Kubernetes with Helm, or the AWS CloudFormation options, follow the appropriate instructions below to access the user interface:
    • Docker Desktop for Mac or Windows: You can use the Docker Dashboard to open the AnzoGraph container in a browser, or open a browser and go to the following URL:
      http://127.0.0.1

      If you specified a port other than 80 for the host HTTP port when you deployed AnzoGraph, include that port in the URL. For example, http://127.0.0.1:8888.

    • Docker on Linux: If you are accessing Docker on a remote Linux host, note the IP address of the host, and then open a browser and go to the following URL:
      https://host_IP_address

      If you mapped the container's HTTPS (8443) port to port 443 on the host when you deployed AnzoGraph, you do not need to specify a port. If you specified a port other than 443, include the port in the URL. For example, https://10.100.0.1:8888.

      If you are using Docker locally on a Linux machine and need to know the IP address of the AnzoGraph container, you can run the following command:

      sudo docker inspect container_name | grep '"IPAddress"' | head -n 1

      For example:

      sudo docker inspect anzograph | grep '"IPAddress"' | head -n 1
      "IPAddress": "172.17.0.2"
    • Kubernetes with Helm deployments: Using the AnzoGraph Cluster IP or External IP from the kubectl get service command, open a browser and go to the following URL:
      https://IP_address
    • AWS CloudFormation deployments: In the Outputs section of the Stack Detail screen, click an AnzoGraph endpoint URL (AnzoGraphURL) to open the AnzoGraph Console.

    If you use the HTTPS endpoint, your browser may warn you that the connection is not private. The warning is normal behavior. AnzoGraph servers use self-signed certificates, and browsers automatically trust only the certificates from well-known certificate authorities. For more information about certificate warnings, see Security Certificate Errors on the DigiCert website. Depending on your browser, follow the appropriate instructions below to either bypass the warning and continue to the console or configure the browser to trust the certificate:

    • On Chrome, click the Advanced link at the bottom of the page and then click the Proceed to ip (unsafe) link.
    • On Safari, click the Show Details button and then click Visit Website to import the certificate.
    • On Firefox, click Advanced and then click Add Exception. On the next screen, click Add Security Exception to confirm the exception for the AnzoGraph endpoint.

    The browser displays the AnzoGraph log in screen.

  2. On the log in screen, type admin as the user name and Passw0rd1 as the password, and then click Sign In. The browser displays the AnzoGraph End User License Agreement (EULA). See AnzoGraph Administration

  3. Review the agreement, and then click Accept to agree to the EULA terms and proceed to the AnzoGraph Query & Admin Console.

    When you log in with "admin" credentials, the user interface also displays an Admin tab. For more information on navigating the Console user interface, see Using the Query & Admin Console.

    The left navigation pane of the Query Console tab page shows two default queries, Count Statements and Total Statements. The Count Statements query returns a list of each named graph and the number of statements or triples in the graph. The Total Statements query returns the total number of statements in all named graphs. Click a query in the navigation pane to open the query in the main window. You can edit or overwrite the default queries, or you can click Add Query to create a new query from scratch. To run a query, click the Run button () at the top of the screen. The results display at the bottom of the screen.

Load and Query Sample Data

  1. On the Query console, replace the default query with the following statement. This statement loads the sample Tickit data from the tickit.ttl.gz directory on the csi-sdl-data-tickit S3 bucket.
    LOAD WITH 'global' <s3://csi-notebook-datasets/MovieTicketAnalysis/20190217/tickit.ttl.gz> INTO GRAPH <tickit>

    This simple data set captures sales activity for a fictional Tickit website where people buy and sell tickets for sporting events, shows, and concerts.

  2. Click the Run button () to run the query and load the data. When the load completes, the console displays an Update Successful message.
  3. On the console, replace the load statement with the following simple query that counts the number of triples in the Tickit data set:
    SELECT (count(*) as ?number_of_triples)
    FROM <tickit>
    WHERE { ?s ?p ?o }

    For example:

If you want to continue to work with the Tickit data set and run more complex queries or view explanations of the query syntax, see Working with the Tickit Data.

Load and Query Your Own Data

This section provides guidance on quickly loading and analyzing some of your own data. AnzoGraph supports loading data from Turtle (.ttl), N-Triple (.n3 or .nt), N-Quad (.nq), TriG (.trig), and CSV files. You can load files that are hosted on Amazon S3 or other storage, the local or a mounted file system, or a web server.

Below are sample SPARQL LOAD statements. Follow these steps to load a file:

  1. Copy the appropriate statement below, depending on the location of your load file. Paste the query into the AnzoGraph Query Console. 

    Load a TTL, N3, NQ, or TriG file in S3 storage:

    LOAD with 'global' <s3://bucket_name/path_to_file/file_name> INTO GRAPH <mydata>

    Load a TTL, N3, NQ, or TriG file on the local or mounted file system:

    LOAD <file:/path_to_file/file_name> INTO GRAPH <mydata>
  2. Edit the query in the console to supply the bucket_name and/or path_to_file and file_name for your load file. You can also change the graph name or remove the INTO GRAPH statement if you want to load a file that includes graph specifications.
  3. Click the Run button () to run the query and load the data. When the load is complete, you can query your data using the Query Console.

For more detailed information about loading data and to review load file requirements and recommendations, see Loading Data from Files.

Related Topics