This example will:

• upload the RDU weather dataset from the CSV demo to Splitgraph, making it viewable on the Splitgraph registry
• upload its description to the registry
• use the autogenerated Postgrest endpoint for this dataset to query it
• use the Splitgraph query API to run a couple of Splitfile commands joining this dataset with US domestic flights from 1990 to 2009 (source) to generate a table of average temperature at Raleigh-Durham Airport and the total passenger count in a given month
• pull the created dataset and inspect it.

Copy your .sgconfig file into this directory (it must contain API credentials to access data.splitgraph.com). If you don't have them yet, take a look at the Splitgraph Cloud reference or register using sgr cloud register.

Change the splitgraph-demo username in the example file to yours.

Then, run ../run_example.py example.yaml and press ENTER when prompted to go through the steps.