Connect Data Sources
To connect to a data source in EdgeSet, first navigate to “Connect” in the navigation bar. You can add any number of each data source type. For example, you can add multiple PostgreSQL databases.
Google Sheets
To access Google Sheets, you need to:
- Enable Google Drive API and Google Sheets API.
- Create a Service Account user.
- Grant the Service Account user permissions:
- Download the credentials (JSON) file for the Service Account user.
Supported Data Source Versions
| Data Source | Versions | Notes |
|---|---|---|
| BigQuery | N/A | requires a Google Cloud service account |
| Elasticsearch | 6.0.0 or higher | unauthenticated only |
| Google Drive | N/A | requires a Google Cloud service account |
| Internal Storage | N/A | |
| Kafka | 0.10.0 or higher | unauthenticated only |
| MariaDB | 10.0 or higher | add as a MySQL data source |
| MongoDB | 4.0 or higher | |
| MySQL | 5.7 or higher | |
| OpenAPI | 3.0 or higher | requires the URL of the specification file |
| Oracle | 11g or higher | |
| OSS | N/A | requires an Alibaba Cloud API key |
| PostgreSQL | 10.0 or higher | |
| Redshift | any | |
| S3 | N/A | requires an API key |
| SQL Server | 2012 or higher or Azure SQL | |
| TPC-DS | N/A | for testing queries |
TPC-DS
The TPC-DS data source is a built-in data source that can be used for testing. We will use it for illustration throughout the rest of the manual.