BabelDB Data Source

BabelDB

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:

select * from query_web('https://api3.binance.com/api/v3/ticker/price');
query_web('https://api.github.com/search/repositories?q=more+useful+keyboard')
query_web('https://www.iso20022.org/sites/default/files/ISO10383_MIC/ISO10383_MIC.csv')
query_web('https://en.wikipedia.org/wiki/List_of_bank_failures_in_the_United_States_(2008%E2%80%93present)')
https://fred.stlouisfed.org/graph/fredgraph.csv?id=MORTGAGE30US

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:

select a.date, CSUSHPINSA/63.74 AS CSUSHPINSA,b.UNRATE/6.60 AS UNRATE
  FROM query_db('FRED','CSUSHPINSA') a
  LEFT JOIN query_db('FRED','UNRATE') b ON a.date=b.date

Query_data( hardcoded JSON/CSV )

query_data("[{d:'2011-01-01', v:9},{d:'2011-01-02', v:6},{d:'2011-01-03', v:8},{d:'2011-01-04', v:4}]")

query_data('Date,val
2001-01-07,88
2001-01-08,99
2001-01-09,55
2001-01-10,66
2001-01-11,70
2001-01-12,75
')