By SQream, 12.25.2023

How to: Create a Foreign Table in SQreamDB

How to: Create a Foreign Table in SQreamDB

This tutorial video walks you through the process of creating a foreign table in SQreamDB.

The video explains how to directly query data to save time, using a broad range of formats like CSV, Parquet, Avro, ORC and JSON.

We delve into the specifics, demonstrating efficient data load and on-the-fly transformations using JOIN operations between a foreign and an internal table.

A standout feature of SQreamDB—automatic schema mapping—is also explored.

Learn how to create a foreign table and let the database define the schema based on the file’s structure.

This tutorial is about using technology to optimize your data operations effectively.

Dive in to get the most out of your data with SQreamDB.