Welcome to datatables.org

What if there was just a single, uniform way of using any web-service or data source like Amazon, iTunes, or Twitter?

With YQL and community Open Data tables there is.

The YQL (Yahoo! Query Language) platform enables developers to query, filter, and combine data across the web through a single interface. It exposes a SQL-like syntax that is both familiar to developers and expressive enough for getting the right data.

Open Data Tables are XML files that can be "plugged" into the Yahoo! Query Language open platform (YQL). These files describe how the YQL SQL-like language can be mapped onto any web service or source on internet. Once mapped, these data sources can be used by developers in many ways in YQL.

To get started with using YQL and community Open Data tables, check out the Getting Started section.

Getting Started

Using community Open Data tables with YQL

In order to use YQL with the community tables, you must pass in the datatables env file. You can do this on the YQL console as part of a YQL statement, or by passing in a query parameter.

YQL supports three SQL-like verbs:

  1. SHOW for getting a list of the tables/data sources supported by the language/platform.
  2. DESC for describing the input fields for a table and other meta information;
  3. SELECT for fetching, combining, filtering and projecting data

The following examples show how each of these verbs can be used for practical applications:

For more information on how to use YQL, please refer to the YQL Developer Guide.



How to contribute an Open Data table

A quick read of the YQL guide is a great starting point, in particular the sections on Open Data tables and Running your own code with Execute in Open Data Tables.

Another easy way of working out how to do something is to look at someone else's open data table that wraps a data source similar to what you want to enable.

What is YQL?

YQL (Yahoo Query Language), is a tool that allows you to query, filter, and combine data across the web. Some of the features include:

  • Direct access to Yahoo! content

    YQL can directly tap into the source of Yahoo! content.

  • Cloud storage

    YQL allows you to store and use data using YQL itself on Yahoo!'s Sherpa cloud storage infrastructure..

For a full list of features, please refer to the main YQL website.

Open Data tables

What are Open Data Tables?

Open Data Tables are XML files that can be "plugged" into the Yahoo! Query Language open platform (YQL). These files describe how the YQL SQL-like language can be mapped onto any web service or source on internet. Once mapped, these data sources can be used by developers in many ways in YQL.

What are Community Open Data Tables?

While anyone can develop and share an open data table for YQL, we are encouraging the community of open data table developers to contribute their tables to the open data tables github project. This makes tables much easier to find and share, and try out in the YQL console.