fbsql loader command
The loader command:
- supports Apache Impala, Apache Kafka and PostgreSQL data sources,
- reads from a specified TOML configuration file containing key/values for the data source and target table
- uses that information to ingest data from the data source
- then copies to the target table
Before you begin
- Learn about “docopt” notation standards used in this guide
- Learn about fbsql
- fbsql loader TOML configuration file settings
Syntax
(fbsql <featurebase-connection> --| \! )loader-(impala | kafka | postgres) <file-name>.toml
Arguments
| Argument | Description | Required | Additional information |
|---|---|---|---|
fbsql <featurebase-connection> | Run fbsql with a connection to a FeatureBase database | When run from CLI | * fbsql connect to FeatureBase Cloud |
\! | Run loader from fbsql interface | Existing FeatureBase database connection | |
loader-(impala | kafka | postgres) | Choose a data source for the loader to read from | Yes | Requires -- prefix when run from CLI |
<file-name>.toml | TOML configuration file containing key/values for data source and target table. | Yes | TOML configuration file for fbsql loader |