Serverless Analytics
This page is part of MariaDB's Documentation.
The parent of this page is: Connect and Query
Topics on this page:
Overview
Serverless Analytics provides real-time analytics on any data in SkySQL or cloud storage. No ETL (Extract, Transform, Load) is needed, since data is queried remotely.
Serverless Analytics allows ad-hoc high performance analytics without static provisioning. Pay only for what you use.
With SkySQL Serverless Analytics, you can:
Achieve predictable response time for concurrent users/apps
Join data across multiple repositories, such as S3 object storage, data warehouses, and SQL databases
Work with data in many formats, including JSON, CSV, Parquet, and AVRO
Serverless Analytics is powered by Apache Spark SQL.
This feature is in Technical Preview.
Prerequisite
Serverless Analytics requires a compatible SkySQL service in the same region.
The compatible SkySQL service is used for authentication.
Compatible SkySQL services are:
Enterprise Server With Replica(s)
Xpand Distributed SQL
ColumnStore Data Warehouse
Launch Serverless Analytics
Log in to the SkySQL portal.
From the Dashboard, click the "+ Launch New Service" button.
Choose the "Analytics" workload type.
Choose the "Serverless Analytics" topology option. This topology is powered by Apache Spark SQL.
Specify the other required options.
Click the "Launch Service" button.
Connection Options
Serverless Analytics depends on a compatible SkySQL service.
To connect, Serverless Analytics uses the credentials for that service. For default credentials, see "Client Connections".