CREATE TABLE loader-target

The loader-target table is required for an ingestion process that includes two additional parts:

• Part 2 - create an example data source and TOML configuration file
• Part 3 - run fbsql loader command to import data to loader-target

Before you begin

• CREATE TABLE statement
• FeatureBase SQL editors
• fbsql loader examples

Create required table

Run the following SQL in a SQL editor:

CREATE TABLE loader-target (
    _id id,
    name string,
    qty int,
    categories stringset,
    level decimal(2),
    ts timestamp
)

Next step

• Part 2 - Create an Apache Kafka data source and TOML configuration file