fbsql loader examples

These examples demonstrate how to:

• Create a FeatureBase table ready for data to be imported
• Create an Impala, Kafka or PostgreSQL data source
• Create a TOML configuration file for your data source
• Run the fbsql loader command with the TOML configuration file

When the loader process is complete, content from the data source is imported to the target table ready to be queried.

Before you begin

• Create a FeatureBase Community database
• Learn how to install fbsql
• Learn how to connect to your Community database
• Learn about fbsql TOML configuration

Step one - create your destination table

Choose one of the following tables:

• Create a table for Impala or PostgreSQL data
• Create a table for Kafka data

Step two - create your data source and TOML configuration file

Create one of the following data sources and TOML files:

• Create an Apache Impala data source and TOML configuration file
• Create an Apache Kafka data source and TOML configuration file
• Create a PostgreSQL data source and TOML configuration file

Step three - run fbsql loader

• [Run fbsql loader with your TOML configuration file] /docs/tools/fbsql-examples/fbsql-loader-eg-ingest)

Next step

• Run SQL queries on your data

---