BabelDB Data Source
Query everything in one place.
Combine queries between any JDBC compatible database and JSON/CSV/HTML data
Click here to try this code in a live environment.
BabelDB allows querying CSV/JSON via HTTP or as text and combining queries across different databases.
Query_web( REST/CSV/HTML )
To query JSON/CSV/HTML based tables use query_web and BabelDB will automatically detect the format and return a table:
query_web takes the following arguments:
| Arg | Description |
|---|---|
| HTTP | HTTP endpoint with data |
| JQ Path (Optional) | JQ Path Expression |
| ColumnTypes (Optional) | A json struct that specifies the key names and value types contained within the JSON file e.g. ``{key1: 'INTEGER', key2: 'VARCHAR'}`` - If not specified these will be guessed. |
Query_db(db,) - join data from different databases
Add a mysql / postgresql connection and query them. Notice the SQL queries can be wrapped in parentheses (), Quotes also work but parentheses allow SQL highlighting to work better in most editors.
Comparing the U.S. Unemployment rate to U.S. National Home Price Index:
Query_data( hardcoded JSON/CSV )
