Data Source

As a browser based application, SQL Frames Designer allows two types of data sources to analyze. They are

1. URL Data Source Any publicly available data sets, or private REST APIs (with appropriate credentials) can serve as remote data sources.
2. Local Files A local file on the user's computer.

The supported file formats are

1. CSV
2. Excel (xlsx)
3. JSON Array (of records)

The following screen recording demonstrates

1. Ability to add a URL based data source.
2. Ability to add a local file based data source.
3. Ability to edit an existing data source.
4. A workbook can have one or more data sources.

Click to maximize