Skip to content

To get started with Eventador, register for an account.

End-to-End examples

The easiest way to get started with the Eventador Platform is to use one of the end-to-end examples.

  • Use the fraud example to get a feel for using the Eventador Platform end-to-end.

Running a simple SQL job

For this example we will use a built in example data source. For using your own data, see Data Providers.

Create an environment.

A cloud environment is the cloud account processing resources will be allocated from. This can be your everyday AWS account, or a new account that is VPC Peered back to your main account.

  • Log into Eventador Console
  • Click on Cloud Environments in the left side menu.
  • Click on the Create Cloud Environment button
  • Enter a logical name for this environment. It's generally good to use the region in the name like AWS_EU_CENTRAL or something similar.
  • Add a description for the environment
  • Select AWS as your provider
  • Select the AWS region you would like to deploy to
  • Enter your AWS IAM Access Key
  • Enter your AWS IAM Secret Key
  • Select a VPC CIDR Range or use the default if it doesn't collide with your IP range.
  • Ensure Triple AZ is selected
  • Select Create Environment

AWS resources will then be allocated to the account associated with the IAM keys. Initially just a couple of resources will be built, more will be created as you create clusters to run jobs on.

Create a cluster.

A cluster is a set of resources where services run a job. Clusters are created in a cloud environment.

  • Log into Eventador Console
  • Click on Clusters in the left side menu.
  • Click on Create Cluster, with type SQLStreamBuilder.
  • Enter a name for the cluster. Maybe something like Development.
  • Enter a description. Maybe Testing 101.
  • Select the assets to run the cluster on, choose something with just 1 worker for now.
  • Select the environment you created from the previous step.
  • Click the Create button.

It will take a few minutes for a cluster to be created.

Create a ContinuousSQL job.

After an environment and cluster are created you are ready to run a SQLStreamBuilder job using SQL.

  • Log into Eventador Console
  • Click on SQLStreamBuilder in the left side menu.
  • In the SQL Job Name text box - name the job or use the name created for you.
  • Select the environment/cluster pair created above.
  • Leave sink virtual table to None.
  • In the SQL window, type:
SELECT * FROM ev_sample_fraud;
  • Select the Execute button.
  • To run another query, select the Stop button, and repeat the above steps but use the following SQL:
// some more complicated SQL: show max amount by card
SELECT card,
max(amount) as max_amount
FROM ev_sample_fraud
WHERE userid IS NOT NULL
GROUP BY card;

SQLStreamBuilder will provision a job to run the SQL. You can select the logs tab (it will preselect) with the status of the job. As data is returned, it will show up in the Results tab. This is the most simple form of running a job, and doesn't do much more than show results in the browser. Note you do not need the semicolon (;) in your statements.