Skip to content

On data markets and YQL gotchas

March 15, 2011

I just submitted the second article in my current PayPal X DevZone series on data markets (read the first installment here) and want to share a couple of things I learned as a sneak peak of sorts.  I also want to call out a potential YQL gotcha I discovered developing this second article.

As a part of the article, I put together a table summarizing the data market features that matter to me.  What I learned from that exercise:  There is a lot of variability in supported programming languages from market to market.

If you’re considering different markets for your data needs, you should investigate their available libraries, including third party packages, up front.  That way you won’t get any surprises after you’ve already committed to a particular dataset (even worse if you had to pay something for that data).  For example, I want to use markets that support Python-based development, and not all of the markets I investigated do.  Whatever your language(s) of choice, I would encourage you to read the article once it’s published for more details.

Another thing that jumped out at me:  It is critically important that a market provides a good search interface to help locate pertinent datasets.  Some of the markets I investigate in my article do, others do not.  I’ll let you draw your own conclusions after you read the piece, but suffice it to say that I’m partial to the ones that make surfacing datasets simple and quick.

Now on to the YQL gotcha:  As part of my article, I developed a simple example that pulls Twitter user influence metrics out of an Infochimps dataset.  It does this using the Infochimps provided YQL influence data table.  My original YQL statement was naively:

select * from infochimps.influence where screen_name='billday' and apikey='api_test-W1cipwpcdu9Cbd9pmm8D4Cjc469'

This returns the expected influence metrics when executed in the YQL console:

When you run the same query embedded in Python code using the Python-YQL package, however, you get a “No definition found for Table” error (pictured in the ActivePython Community Edition shell):

Click here for the solution to the YQL problem available in the complete post on the PayPal X Developer Network.

Advertisements

From → Uncategorized

2 Comments
  1. Without looking I can already tell you forgot the “USE” statement that will allow the custom table to be found. Ran into that a few weeks ago myself. I consider it a YQL documentation lapse myself.

Comments are closed.