Looking to deploy on prem? Check out the demos here
By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.

Getting Started with Streambased A.S.K.

Looking to enhance your analytical experience with Kafka data? Follow this guide to be connected to your data and querying in your tools in minutes.

pREREQUISITES

Before using A.S.K.
make sure you have:

Publicly available
Kafka

Ensure your Kafka instance is accessible and configured for your needs.

Schema Registry with
TopicNameStrategy

Set up your Schema Registry to use TopicNameStrategy for managing schemas.

Data in JsonSchema
or Avro format

Verify that your data is formatted correctly using either JsonSchema or Avro.

“backwards” or "backwards transitive”
compatibility.

To ensure the smooth evolution of table structures in A.S.K. we support backwards (the default) and backwards transitive compatibility types.

2

Run some queries against our
lobby data set:

SHOW TABLES;				
SELECT line FROM readme ORDER BY lineno;

    
3

Convert your Kafka connection
properties to JSON:

4

Apply our new
connection:

SET SESSION streambased_connection =
5

Explore!

SELECT a.accounttype, 
  count(t.transactionamount) as deposit_count, 
  sum(t.transactionamount) as deposit_total 
FROM 
  demo_transactions t 
JOIN
  demo_accounts a on t.accountId = a.accountId 
WHERE
  t.transactiontype='Deposit' 
GROUP BY
  a.accounttype;
        
    

Want to go faster?

The zero signup nature of A.S.K. means that we cannot apply Streambased super fast acceleration technology. Contact us today to get a dedicated Streambased cluster and experience up to 30x speed up on your queries.

Copyright 2024 Streambased Platform Limited. Company Number 14709247.