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
- Create a FeatureBase Community database
- fbsql loader syntax
- FBSQL loader examples
Step 1 - connect to your 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