Uploading External Data Sources

Users can also access data from external databases for model training.

About this task

For uploading external data sources, complete the following steps:

Procedure

  1. Click the Data Upload tab.
  2. Click External Data Sources.
  3. Select different SQL databases and data warehouses to ingest data. For example, SQLite, Microsoft SQL, PostgreSQL, MySQL, Oracle, Google BigQuery, Redshift, Snowflake, Actian.
  4. To access data from the database, you need to provide essential credentials like Database Name, Username, Host Port, etc.
  5. If a single table contains all the data, you can simply put the table name and fetch the table as Data Frame. Otherwise, the user can perform join and selection based on the condition to merge more than one table and finally fetch the data.
    Note: Currently, this option is to upload data from some external databases and some data warehouses like- SQLite, PostgreSQL, etc. Users can insert a single table as a database. Also, some basic SQL operation like join, and selection based on where is also possible on multiple tables. Please contact Unica Admin to enable this option.