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

• Learn about “docopt” notation standards used in this guide
• Learn about fbsql

• Install fbsql

• Create a FeatureBase Cloud database

• Learn about fbsql TOML configuration
• Choose a connection method for your Cloud database:
  • User credentials
  • Learn how to create a Cloud API key

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

Step four - query your data

• [Query Impala data]
• [Query PostgreSQL data]
• [Query Kafka data]

---