Learn about how you can work with data science and machine learning, and how you can run AI workloads in Exasol.
Exasol offers several ways to do advanced analytics and data science beyond what is achievable with standard SQL. This section provides step-by-step tutorials and examples to get you started, as well as links to additional resources.
Exasol AI Lab
Exasol AI Lab is a scalable platform that seamlessly integrates AI models into your data workflow. It streamlines common data science and AI tasks, including data loading, preparation, exploration, model training, and deployment.
-
For an introduction and tutorial videos explaining Exasol AI Lab, see Exasol AI Lab.
-
To get started immediately with Exasol AI Lab, visit the Exasol AI Lab GitHub repository.
User defined functions (UDFs)
User defined functions (UDFs) in Exasol allow you to program your own analysis, processing, and generation functions and to execute these functions in parallel inside an Exasol cluster. By using UDFs you can solve problems that are not possible to solve using only SQL statements.
In Exasol 2025.2 and later you can utilize GPUs to accelerate parallel processing for UDFs. This offers a significant performance increase for certain types of workloads, specifically those that require repetitive computations. For example, GPUs can tangibly accelerate AI and machine learning workloads, including model training and model inference. GPUs can also accelerate vector and semantic search workloads.
-
To learn more about how to use UDFs, see User defined functions (UDFs).
-
To learn how to utilize GPU support in UDFs, see Enable GPU acceleration in UDFs.
-
To learn how to use UDFs for advanced analytics, see Data science UDF examples.
-
For tutorials on how to train and predict in R using UDFs, see Train and predict with R and UDFs.
Skyline
Skyline is an SQL extension for data analysis developed by Exasol. The Skyline extension can help you with issues such as data flooding and empty results, and with correlating many dimensions when working with large data volumes with multi-criteria optimization.
For more information and an example on how to use the Skyline extension, see Skyline.
