/examples

Workbooks for the Kinetica Workbench

Primary LanguageJupyter NotebookOtherNOASSERTION

Kinetica Logo

The database for time and space

Kinetica is a database, purpose built for real-time analytics at scale. It leverages vectorized memory-first architecture with kernels that have been custom built for over a decade to deliver blistering performance at scale on significantly less infrastructure than traditional data warehouses. Using a highly-distributed, lockless design, Kinetica enables simultaneous ingestion and analysis with integrated geospatial, graph, SQL, and AI/ML capabilities. With out of the box connectors for ingest and egress, native language bindings and a rich API ecosystem, developers can leverage the tools that they are comfortable and familiar with to build and deploy advanced analytical applications.

This project contains fully reproducible examples of using Kinetica. Most of the examples feature workbench, an interactive SQL notebook wtih built in features to import/export, explore and visualize your data. Workbench is available for free via Kinetica cloud and the developer edition. You can also deploy it as a managed service on Azure and AWS.

How to run these examples

Each folder in this repo contains a fully reproducible example that uses either SQL or other supported languages (Python, Java, Javascript etc.).

How to import a SQL workbook

A majority of the examples in this repo use interactive SQL workbooks. The easiest way to download a workbook (without the entire repo) is as follows.

  1. Access the raw file and then copy the URL
  2. Import the workbook to your instance of Kinetica using the plus icon on the workbooks tab.

Other languages

Kinetica provides APIs across different languages (Python, JavaScript, Java etc.) that can be used to connect to and query a Kinetica database server using a third party client. The language specific instructions are included with each example.

Install Kinetica

The easiest way to get started is with the free developer edition of Kinetica.

This is the easiest way to get started. It takes 5 minutes to set up and you get access to a free shared cluster with 10 GB of space.

Kinetica offers a free forever personal developer edition that can be installed on Windows or Mac/Linux operating systems. Developer edition of Kinetica requires Docker with at least 8GB of RAM allocated. You can follow the instructions here to download and install it on your system.

There are free versions of Kinetica that can be provisioned as a managed service on Azure or AWS. You will have to pay a small fee for cloud infrastructure (to the cloud provider). Follow the instructions here to provision Kinetica on the cloud.

Install the on-premise version of Kinetica

You can also deploy an on-premise version of Kinetica. You can find more information on the different installation options here.

Support

For bugs please submit an issue on Github. Please reference the example that you are having an issue with in the title.

For support your can post on stackoverflow under the kinetica tag or Slack.

Contact Us