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
- Click the Data Upload tab.
- Click External Data Sources.
- Select different SQL databases and data warehouses to ingest data. For example, SQLite, Microsoft SQL, PostgreSQL, MySQL, Oracle, Google BigQuery, Redshift, Snowflake, Actian.
- To access data from the database, you need to provide essential credentials like Database Name, Username, Host Port, etc.
-
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.