Example fbsql loader command

This example demonstrates how to run the loader command:

• with a TOML configuration file setup with data source and target key/values
• to import data from a specified data source to an existing target table

Before you begin

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

• Install fbsql

• Create a FeatureBase Cloud database

• fbsql loader syntax
• FBSQL loader examples
• Choose a connection method for your Cloud database:
  • User credentials
  • Create a Cloud API key

Step 1 - connect to your Cloud database

• Open a terminal then substitute your connection details in either of the following commands:

Connect with API key

fbsql --host="https://cloud.featurebase.com" \
--api-key="<your-api-key-here>"

Connect with user credentials

fbsql --host="https://cloud.featurebase.com" \
--email="<your-account-email-address-here>" \
--password="<your-account-password-here>"

Step 2 - run loader command

Substitute your data source type where specified in the following fbsql command:

loader-<data-source-type> example-config.toml

Where <data-source-type> is:

• impala
• kafka
• postgres