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.