A fresh Seafowl installation has a single database,
default. Seafowl doesn't
support creating or connecting to a different database.
public is the default schema for all Seafowl tables. You do not need to prefix
table references with a schema name if they are in the
To create a different schema, use the
CREATE SCHEMA statement.
This is a dedicated temporary schema for external (live) tables. You can create
tables in this schema with, and only with, the
CREATE EXTERNAL TABLE
statement. Tables in this schema don't get persisted into Seafowl and don't
survive instance restarts.
This schema contains helper tables with the aim of making Seafowl's internal
state more transparent. For now the only tables available are
dropped_tables; they can be used to query the available table versions
(including creation timestamps) as well as tables that were dropped and need to
Seafowl exposes DataFusion's
information_schema that provides information
about the available tables and their schemas:
information_schema.tables: list of all tables
information_schema.columns: list of all table columns and their types
information_schema.views: list of all views
for more information.