# Tutorials **URL:** https://community.cratedb.com/c/tutorials/28.md?page=1 [Latest](https://community.cratedb.com/latest.md) · [Categories](https://community.cratedb.com/categories.md) · [Tags](https://community.cratedb.com/tags.md) **Page:** 2 --- ## [Objects in CrateDB](https://community.cratedb.com/t/objects-in-cratedb/1188)
**Author:** [@rafaelasantana](https://community.cratedb.com/u/rafaelasantana)\ **Replies:** 0\ **Last updated:** [August 8, 2022, 11:59am UTC](https://community.cratedb.com/t/objects-in-cratedb/1188 "2022-08-08T11:59:06Z")
In this tutorial, you will learn the basics of CrateDB Objects. This tutorial is also available in the video format: CrateDB Video | Fundamentals: Getting Started with CrateDB Objects First, I present a simple use cas… --- ## [Updating stock market data automatically with CrateDB and Apache Airflow](https://community.cratedb.com/t/updating-stock-market-data-automatically-with-cratedb-and-apache-airflow/1304)
**Author:** [@rafaelasantana](https://community.cratedb.com/u/rafaelasantana)\ **Replies:** 0\ **Last updated:** [December 9, 2022, 8:34am UTC](https://community.cratedb.com/t/updating-stock-market-data-automatically-with-cratedb-and-apache-airflow/1304 "2022-12-09T08:34:42Z")
Watch this tutorial on Youtube: https://www.youtube.com/watch?v=YTTUzeaYUgQ&t=685s If you are struggling with keeping your stock market data up to date, this tutorial walks you through exactly what you need to do so y… --- ## [Getting started with Apache Spark and CrateDB: A step by step tutorial](https://community.cratedb.com/t/getting-started-with-apache-spark-and-cratedb-a-step-by-step-tutorial/1595)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [September 19, 2023, 12:53pm UTC](https://community.cratedb.com/t/getting-started-with-apache-spark-and-cratedb-a-step-by-step-tutorial/1595 "2023-09-19T12:53:41Z")
Apache Spark is an open-source distributed computing framework designed for high-speed, versatile big-data processing. It offers support for various data processing tasks, such as batch processing, real-time streaming, m… --- ## [Connecting with SSL to CrateDB using the PostgreSQL protocol from Java-based applications](https://community.cratedb.com/t/connecting-with-ssl-to-cratedb-using-the-postgresql-protocol-from-java-based-applications/1591)
**Author:** [@hernanc](https://community.cratedb.com/u/hernanc)\ **Replies:** 0\ **Last updated:** [September 13, 2023, 12:01pm UTC](https://community.cratedb.com/t/connecting-with-ssl-to-cratedb-using-the-postgresql-protocol-from-java-based-applications/1591 "2023-09-13T12:01:39Z")
If you are using CrateDB Cloud, or if you have configured a server certificate for an on-premises deployment, and you try to enforce SSL on a PostgreSQL connection to CrateDB you may come across an error message like thi… --- ## [Overview of CrateDB drivers and adapters](https://community.cratedb.com/t/overview-of-cratedb-drivers-and-adapters/1464)
**Author:** [@amotl](https://community.cratedb.com/u/amotl)\ **Replies:** 3\ **Last updated:** [September 10, 2023, 3:25pm UTC](https://community.cratedb.com/t/overview-of-cratedb-drivers-and-adapters/1464 "2023-09-10T15:25:41Z")
We recommend to use those drivers and adapters for the corresponding languages and frameworks.:point\_down: Language Driver/Adapter Interface Description Golang pgx PG A pure Go driver and toolkit for PostgreSQL. … --- ## [How to set up LangChain with CrateDB](https://community.cratedb.com/t/how-to-set-up-langchain-with-cratedb/1576)
**Author:** [@karynsaz](https://community.cratedb.com/u/karynsaz)\ **Replies:** 0\ **Last updated:** [August 29, 2023, 5:49pm UTC](https://community.cratedb.com/t/how-to-set-up-langchain-with-cratedb/1576 "2023-08-29T17:49:20Z")
Introduction LangChain is a framework for developing applications powered by language models. For this tutorial, we are going to use it to interact with CrateDB using only natural language without writing any SQL. To ac… --- ## [Using regex comparisons and other advanced database features for real-time inspection of web server logs](https://community.cratedb.com/t/using-regex-comparisons-and-other-advanced-database-features-for-real-time-inspection-of-web-server-logs/1564)
**Author:** [@hernanc](https://community.cratedb.com/u/hernanc)\ **Replies:** 0\ **Last updated:** [August 14, 2023, 11:43am UTC](https://community.cratedb.com/t/using-regex-comparisons-and-other-advanced-database-features-for-real-time-inspection-of-web-server-logs/1564 "2023-08-14T11:43:27Z")
In Storing server logs on CrateDB for fast search and aggregations we saw how we can get server logs sent to CrateDB in real-time, and for demo purposes we set up an instance of MediaWiki. It was just an example, but it… --- ## [Building Seamless Data Pipelines Made Easy: Combining Prefect and CrateDB](https://community.cratedb.com/t/building-seamless-data-pipelines-made-easy-combining-prefect-and-cratedb/1555)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [August 3, 2023, 12:13pm UTC](https://community.cratedb.com/t/building-seamless-data-pipelines-made-easy-combining-prefect-and-cratedb/1555 "2023-08-03T12:13:37Z")
Introduction Prefect is an open-source workflow automation and orchestration tool for data engineering, machine learning, and other data-related tasks. It allows you to define, schedule, and execute complex data workflow… --- ## [Integration testing with Testcontainers on CrateDB](https://community.cratedb.com/t/integration-testing-with-testcontainers-on-cratedb/1082)
**Author:** [@jayeff](https://community.cratedb.com/u/jayeff)\ **Replies:** 0\ **Last updated:** [April 15, 2022, 3:34pm UTC](https://community.cratedb.com/t/integration-testing-with-testcontainers-on-cratedb/1082 "2022-04-15T15:34:23Z")
Testcontainers is a framework that allows provisioning Docker containers as part of your automated integration test runs. This way, you can run end-to-end tests of your application, including CrateDB. This tutorial focus… --- ## [Guide to efficient data ingestion to CrateDB with pandas and Dask](https://community.cratedb.com/t/guide-to-efficient-data-ingestion-to-cratedb-with-pandas-and-dask/1482)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [May 11, 2023, 11:46am UTC](https://community.cratedb.com/t/guide-to-efficient-data-ingestion-to-cratedb-with-pandas-and-dask/1482 "2023-05-11T11:46:11Z")
Dask is a parallel computing library that enables distributed computing for tasks such as data processing and machine learning. In this tutorial, we’ll explore how to leverage the power of CrateDB, a distributed SQL data… --- ## [Guide to efficient data ingestion to CrateDB with pandas](https://community.cratedb.com/t/guide-to-efficient-data-ingestion-to-cratedb-with-pandas/1541)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [July 10, 2023, 12:29pm UTC](https://community.cratedb.com/t/guide-to-efficient-data-ingestion-to-cratedb-with-pandas/1541 "2023-07-10T12:29:09Z")
Introduction Bulk insert is a technique for efficiently inserting large amounts of data into a database by submitting multiple rows of data in a single database transaction. Instead of executing multiple SQL INSERT state… --- ## [Monitoring CrateDB Cloud clusters](https://community.cratedb.com/t/monitoring-cratedb-cloud-clusters/1397)
**Author:** [@Matej](https://community.cratedb.com/u/Matej)\ **Replies:** 0\ **Last updated:** [March 7, 2023, 9:34am UTC](https://community.cratedb.com/t/monitoring-cratedb-cloud-clusters/1397 "2023-03-07T09:34:51Z")
This tutorial demonstrates how you can monitor your CrateDB Cloud cluster using the exposed Prometheus metrics. The visualization tool Grafana is used with Prometheus to scrape the API endpoint that exposes metrics and… --- ## [Importing data to CrateDB Cloud clusters](https://community.cratedb.com/t/importing-data-to-cratedb-cloud-clusters/1467)
**Author:** [@Matej](https://community.cratedb.com/u/Matej)\ **Replies:** 0\ **Last updated:** [May 3, 2023, 4:22pm UTC](https://community.cratedb.com/t/importing-data-to-cratedb-cloud-clusters/1467 "2023-05-03T16:22:59Z")
This tutorial demonstrates three different methods of importing data into your CrateDB Cloud cluster. Two of them, Import from URL, and Import data from a file, are most convenient, as they are available directly from… --- ## [Automating financial data collection and storage in CrateDB with Python and pandas 2.0.0](https://community.cratedb.com/t/automating-financial-data-collection-and-storage-in-cratedb-with-python-and-pandas-2-0-0/916)
**Author:** [@rafaelasantana](https://community.cratedb.com/u/rafaelasantana)\ **Replies:** 0\ **Last updated:** [November 25, 2021, 1:50pm UTC](https://community.cratedb.com/t/automating-financial-data-collection-and-storage-in-cratedb-with-python-and-pandas-2-0-0/916 "2021-11-25T13:50:01Z")
In this step-by-step post, I introduce a method to get financial data from stock companies. Then, I show how to store this data in CrateDB and keep it up to date with companies’ data. In this step-by-step post, I in… --- ## [From data storage to data analysis: Tutorial on CrateDB and pandas](https://community.cratedb.com/t/from-data-storage-to-data-analysis-tutorial-on-cratedb-and-pandas/1440)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [April 4, 2023, 8:17am UTC](https://community.cratedb.com/t/from-data-storage-to-data-analysis-tutorial-on-cratedb-and-pandas/1440 "2023-04-04T08:17:14Z")
Introduction Pandas is an open-source data manipulation and analysis library for Python. It is widely used for handling and analyzing data in a variety of fields, including finance, research, etc. One of the key benefit… --- ## [Demo of Metabase and CrateDB: Getting started](https://community.cratedb.com/t/demo-of-metabase-and-cratedb-getting-started/1436)
**Author:** [@paoliniluis](https://community.cratedb.com/u/paoliniluis)\ **Replies:** 0\ **Last updated:** [April 1, 2023, 10:20pm UTC](https://community.cratedb.com/t/demo-of-metabase-and-cratedb-getting-started/1436 "2023-04-01T22:20:47Z")
Hi there! I’m Luis from the Metabase Success team. A few days ago we had a webinar about using Metabase with CrateDB and I showed how to connect Metabase to CrateDB and I mentioned that you could do things programaticall… --- ## [Setting AWS S3 object storage as snapshot repository for CrateDB](https://community.cratedb.com/t/setting-aws-s3-object-storage-as-snapshot-repository-for-cratedb/1603)
**Author:** [@amotl](https://community.cratedb.com/u/amotl)\ **Replies:** 0\ **Last updated:** [March 28, 2023, 10:00pm UTC](https://community.cratedb.com/t/setting-aws-s3-object-storage-as-snapshot-repository-for-cratedb/1603 "2023-03-28T22:00:00Z")
Sign up for an AWS account: Prerequisite: Setting up Amazon S3 - Amazon Simple Storage Service Create an S3 bucket: Step 1: Create your first S3 bucket - Amazon Simple Storage Service For configuring the reposito… --- ## [Visualizing data with Metabase](https://community.cratedb.com/t/visualizing-data-with-metabase/1401)
**Author:** [@Matej](https://community.cratedb.com/u/Matej)\ **Replies:** 0\ **Last updated:** [March 9, 2023, 2:06am UTC](https://community.cratedb.com/t/visualizing-data-with-metabase/1401 "2023-03-09T02:06:48Z")
This content has been migrated. ▶ Retained images --- ## [Setting up data pipelines with CrateDB and Kestra.io](https://community.cratedb.com/t/setting-up-data-pipelines-with-cratedb-and-kestra-io/1400)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [March 8, 2023, 11:01am UTC](https://community.cratedb.com/t/setting-up-data-pipelines-with-cratedb-and-kestra-io/1400 "2023-03-08T11:01:03Z")
Kestra.io is an open-source workflow automation and orchestration tool that enables users to automate and manage complex workflows in a streamlined and efficient manner. The tool provides a wide range of features and int… --- ## [Window functions in CrateDB](https://community.cratedb.com/t/window-functions-in-cratedb/1398)
**Author:** [@rafaelasantana](https://community.cratedb.com/u/rafaelasantana)\ **Replies:** 0\ **Last updated:** [March 7, 2023, 12:45pm UTC](https://community.cratedb.com/t/window-functions-in-cratedb/1398 "2023-03-07T12:45:19Z")
In this tutorial, you will learn how to use window functions in CrateDB. CrateDB is an open-source distributed database designed for scalability and performance. One of the features of CrateDB is its support for windo… --- ## [Connecting to CrateDB with Excel ODBC Driver on MacOS](https://community.cratedb.com/t/connecting-to-cratedb-with-excel-odbc-driver-on-macos/1373)
**Author:** [@rafaelasantana](https://community.cratedb.com/u/rafaelasantana)\ **Replies:** 0\ **Last updated:** [February 13, 2023, 2:44pm UTC](https://community.cratedb.com/t/connecting-to-cratedb-with-excel-odbc-driver-on-macos/1373 "2023-02-13T14:44:04Z")
This tutorial will teach you to connect to CrateDB from Excel on MacOS using ODBC. CrateDB is a highly scalable and distributed SQL database suited for big data and IoT applications. With the help of ODBC, you can easi… --- ## [Integrating a Bubble.io app with CrateDB](https://community.cratedb.com/t/integrating-a-bubble-io-app-with-cratedb/1348)
**Author:** [@rafaelasantana](https://community.cratedb.com/u/rafaelasantana)\ **Replies:** 0\ **Last updated:** [February 1, 2023, 1:36pm UTC](https://community.cratedb.com/t/integrating-a-bubble-io-app-with-cratedb/1348 "2023-02-01T13:36:25Z")
Bubble.io is a powerful platform for building web applications without code. One of the features it offers is the ability to connect to external databases, such as CrateDB, and display the data in your Bubble app. This… --- ## [Reducing disk read operations from statistics collection](https://community.cratedb.com/t/reducing-disk-read-operations-from-statistics-collection/1315)
**Author:** [@hammerhead](https://community.cratedb.com/u/hammerhead)\ **Replies:** 0\ **Last updated:** [December 21, 2022, 9:21am UTC](https://community.cratedb.com/t/reducing-disk-read-operations-from-statistics-collection/1315 "2022-12-21T09:21:02Z")
CrateDB regularly populates the system table pg\_catalog.pg\_stats. It contains approximate statistical information at the column level, such as a column’s number of distinct values or most common values. Client applicatio… --- ## [Querying CrateDB with DataStation](https://community.cratedb.com/t/querying-cratedb-with-datastation/1302)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [December 5, 2022, 12:16pm UTC](https://community.cratedb.com/t/querying-cratedb-with-datastation/1302 "2022-12-05T12:16:02Z")
DataStation is a powerful IDE for querying and analyzing data. It supports data imports from databases, REST APIs, and files. In this tutorial, we will illustrate how to run DataStation with your local CrateDB instance. … --- ## [Deploying CrateDB on balena.io](https://community.cratedb.com/t/deploying-cratedb-on-balena-io/1067)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 7\ **Last updated:** [November 25, 2022, 2:20pm UTC](https://community.cratedb.com/t/deploying-cratedb-on-balena-io/1067 "2022-11-25T14:20:54Z")
Balena is a complete set of tools for building, deploying and managing fleets of connected IoT devices. Balena provides infrastructure for fleet owners so they can focus on developing their applications and growing their… --- ## [OpenLineage with Airflow, Marquez, and CrateDB](https://community.cratedb.com/t/openlineage-with-airflow-marquez-and-cratedb/1764)
**Author:** [@hernanc](https://community.cratedb.com/u/hernanc)\ **Replies:** 0\ **Last updated:** [November 22, 2022, 11:00pm UTC](https://community.cratedb.com/t/openlineage-with-airflow-marquez-and-cratedb/1764 "2022-11-22T23:00:00Z")
About OpenLineage is an open source industry standard framework for data lineage. It standardizes the definition of data lineage, the metadata that makes up lineage data, and the approach for collecting lineage data fr… --- ## [Deploying CrateDB clusters with Kubernetes on Azure AKS](https://community.cratedb.com/t/deploying-cratedb-clusters-with-kubernetes-on-azure-aks/1280)
**Author:** [@Marija](https://community.cratedb.com/u/Marija)\ **Replies:** 0\ **Last updated:** [November 7, 2022, 9:21am UTC](https://community.cratedb.com/t/deploying-cratedb-clusters-with-kubernetes-on-azure-aks/1280 "2022-11-07T09:21:21Z")
In this tutorial, we will illustrate step-by-step how to run CrateDB clusters with Kubernetes on Azure AKS using the CrateDB Kubernetes operator. The operator has been recently licensed under the Apache 2.0 license. Ins… --- ## [Fetching large result sets from CrateDB](https://community.cratedb.com/t/fetching-large-result-sets-from-cratedb/1270)
**Author:** [@hernanc](https://community.cratedb.com/u/hernanc)\ **Replies:** 0\ **Last updated:** [October 31, 2022, 2:41pm UTC](https://community.cratedb.com/t/fetching-large-result-sets-from-cratedb/1270 "2022-10-31T14:41:34Z")
As a distributed database system with support for the standard SQL query language, CrateDB is great to run aggregations server-side, working on huge datasets, and getting summarized results back; there are however case… --- ## [Automating the import of Parquet files with Apache Airflow](https://community.cratedb.com/t/automating-the-import-of-parquet-files-with-apache-airflow/1247)
**Author:** [@karynsaz](https://community.cratedb.com/u/karynsaz)\ **Replies:** 0\ **Last updated:** [October 6, 2022, 6:11pm UTC](https://community.cratedb.com/t/automating-the-import-of-parquet-files-with-apache-airflow/1247 "2022-10-06T18:11:40Z")
Introduction In a previous tutorial, we approached how to Build a data ingestion pipeline using Airflow and the NYC Taxi and Limousine dataset. However, due to a change in the data format provided, switching from CSV to… --- ## [Monitoring a self-managed CrateDB cluster with Prometheus and Grafana](https://community.cratedb.com/t/monitoring-a-self-managed-cratedb-cluster-with-prometheus-and-grafana/1236)
**Author:** [@hernanc](https://community.cratedb.com/u/hernanc)\ **Replies:** 0\ **Last updated:** [September 30, 2022, 11:14am UTC](https://community.cratedb.com/t/monitoring-a-self-managed-cratedb-cluster-with-prometheus-and-grafana/1236 "2022-09-30T11:14:43Z")
If you are running CrateDB in a production environment, you have probably wondered what would be the best way to monitor the servers to identify issues before they become problematic and to collect statistics that you … [Previous page](https://community.cratedb.com/c/tutorials/28.md) [Next page](https://community.cratedb.com/c/tutorials/28.md?page=2)