Splice Machine Cloud Manager

This guide helps you to get registered with and start using the Splice Machine Cloud Manager. Here are the topics included in this guide:

Topic Description
Navigating Your Dashboard Your Dashboard is the entry point to the Splice Machine Cloud Manager. From here, you can create new clusters, access existing clusters, manage your account, review notifications, update your profile, and log out.
Registering Shows you how to complete the first step of using your database service: registering as a user of the Splice Machine Cloud Manager.
Logging In Shows you how to log into the Splice Machine Cloud Manager once you've registered.
Creating a New Cluster Follow this steps in this topic to quickly become productive with your clustered database. In only a few minutes, you'll have your cluster up and running, and will be able to load and work with your data.
Best Practices: Ingesting Data

You can load your data into Splice Machine from an AWS S3 bucket:

Also note that the S3 directory you specify for the log of record import issues (the bad record directory), must be write-accessible using the same AWS credentials that apply to the input directory, i.e. the bad record directory must allow the same access key/secret key pair.

Using the DB Console

The Splice Machine Database Console is a browser-based tool that you can use to monitor database queries on your cluster in real time. The Console UI allows you to see the Spark queries that are currently running in Splice Machine on your cluster, and to then drill down into each job to see the current progress of the queries, and to identify any potential bottlenecks. If you see something amiss, you can also terminate a query.

The DB Console is available for all Splice Machine products; you access the Splice DB Console for the Database-as-Service product by clicking the DB Console link in your Cluster Management dashboard, or by following the link sent to you by Splice Machine when your cluster was originally created.

The DB Console link in your Cluster Management dashboard allows you to monitor Splice Machine jobs running on your cluster. If you are running non-Splice jobs, you'll need to use a different console to monitor them; you'll find a link to this External Spark Console in the bottom left corner of your cluster dashboard.

Using the Notebooks Manager

One of the great features of our database service is the ease with which you can use Apache Zeppelin notebooks to interact with your database. Our Notebooks Manager provides convenient access to your notebooks, and to information about using Zeppelin.

This tutorial walks you through using a notebook created by Splice Machine that:

  • Creates a schema and the tables in your database to store the TPCH-1 benchmarks data.
  • Loads the data from an S3 bucket into your database.
  • Runs any or all of the TPCH-1 queries
Managing Your Account Use our Account Manager to manage your company profile, billing, and users.
Reviewing Event Notifications. Use our Events Manager to review notification messages that have been sent to your account.