Query the Data Delivery Network
Query the DDNThe easiest way to query any data on Splitgraph is via the "Data Delivery Network" (DDN). The DDN is a single endpoint that speaks the PostgreSQL wire protocol. Any Splitgraph user can connect to it at data.splitgraph.com:5432 and query any version of over 40,000 datasets that are hosted or proxied by Splitgraph.
For example, you can query the feed_the_future_malawi_interim_survey_in_the_zone table in this repository, by referencing it like:
"datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-7s2q-5769:latest"."feed_the_future_malawi_interim_survey_in_the_zone"or in a full query, like:
SELECT
":id", -- Socrata column ID
"g404_a", -- Is there a GROUP in your community? GROUP Agricultural livestock fisheries producer s group (including marketing groups)
"g403", -- Do you feel comfortable speaking up in public to protest the misbehavior of authorities or elected officials?
"g301b_m", -- How many of ITEM does your household currently have? ITEM Other land not used for agricultural purposes (pieces plots, residential or commercial land)
"g202_f", -- How much input did you have in making decisions about ACTIVITY ? ACTIVITY Fishing or fishpond culture
"g301a_m", -- Does anyone in your household currently have any ITEM ? ITEM Other land not used for agricultural purposes (pieces plots, residential or commercial land)
"g309_b", -- Who makes the decision about what to do with the money item borrowed from SOURCE ? SOURCE Informal lender
"g305_d", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Chickens, ducks, turkeys, guinea fowl, and pigeons
"g201_a", -- Did you yourself participate in ACTIVITY in the past 12 months? ACTIVITY Food crop farming: These are crops that are grown primarily for household food consumption
"cluster", -- Cluster number
"g307_a", -- Has anyone in your household taken any loans or borrowed cash in-kind from SOURCE in the past 12 months? SOURCE Non-governmental organization (NGO)
"strata3", -- Stratification for subgroup 3
"zoi", -- Was the data collected by Westat or ICF?
"g501_b", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY The types of crops to grow
"g404_f", -- Is there a GROUP in your community? GROUP Trade and business association
"g111", -- What is your marital status now: are you widowed, divorced or separated?
"g301a_d", -- Does anyone in your household currently have any ITEM ? ITEM Chickens, ducks, turkeys, guinea fowl, and pigeons
"g309_e", -- Who makes the decision about what to do with the money item borrowed from SOURCE ? SOURCE Group based micro-finance or lending including merry-go-rounds, VSLAs (Village Savings and Loan Associations), ROSCAs (Rotating, Savings and Credit Associations)
"g401", -- Do you feel comfortable speaking up in public to help decide on infrastructure (like small wells, roads, water supplies) to be built in your community?
"g301b_h", -- How many of ITEM does your household currently have? ITEM Nonfarm business equipment (solar panels for recharging, solar inverter, solar battery, sewing machine, brewing equipment, fryers, generator, satellite dish, cooler boxes)
"g502_f", -- To what extent do you feel you can make your own personal decisions regarding these aspects of household life if you want(ed) to? ACTIVITY Major household expenditures (such as a large appliance for the house like a refrigerator)
"g201_e", -- Did you yourself participate in ACTIVITY in the past 12 months? ACTIVITY Wage and salary employment: This could be work that is paid for in cash or in-kind, including both agriculture and other wage work
"g304_d", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Chickens, ducks, turkeys, guinea fowl, and pigeons
"g308_e", -- Who made the decision to borrow from SOURCE ? SOURCE Group based micro-finance or lending including merry-go-rounds, VSLAs (Village Savings and Loan Associations), ROSCAs (Rotating, Savings and Credit Associations), SACCOs (Savings and Credit Co-Operat
"g302_d", -- Who would you say owns most of the ITEM ? ITEM Chickens, ducks, turkeys, guinea fowl, and pigeons
"g405_k", -- Are you an active member of this GROUP? GROUP Any other group or organization, specified
"g404_g", -- Is there a GROUP in your community? GROUP Civic groups (improving community) or charitable group (helping others)
"g304_e", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Fish pond or fishing equipment
"g404_b", -- Is there a GROUP in your community? GROUP Water users group
"g306_d", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Chickens, ducks, turkeys, guinea fowl, and pigeons
"g404_j", -- Is there a GROUP in your community? GROUP Other women s group (only if it does not fit into one of the other categories)
"g301a_j", -- Does anyone in your household currently have any ITEM ? ITEM Large consumer durables (refrigerator, TV, sofa, dining table sets, beds)
"g301b_j", -- How many of ITEM does your household currently have? ITEM Large consumer durables (refrigerator, TV, sofa, dining table sets, beds)
"g501_g", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY Minor household expenditures (such as food for daily consumption or other household needs)
"g301b_e", -- How many of ITEM does your household currently have? ITEM Fish pond or fishing equipment
"g404_k", -- Is there a GROUP in your community? GROUP Any other group or organization, specified
"g405_i", -- Are you an active member of this GROUP? GROUP Religious group
"survey", -- Two surveys were administered. This variable identifies whether the survey was the Interim Feed the Future survey or the Baseline Food for Peace survey.
"g501_c", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY Taking crops to the market (or not)
"g203_f", -- How much input did you have in decisions on the use of income generated from ACTIVITY ? ACTIVITY Fishing or fishpond culture
"g110", -- Have you ever been married or lived together with a man as if married?
"g502_b", -- To what extent do you feel you can make your own personal decisions regarding these aspects of household life if you want(ed) to? ACTIVITY The types of crops to grow
"g301b_c", -- How many of ITEM does your household currently have? ITEM Small livestock (goats, pigs, sheep, rabbits)
"g308_d", -- Who made the decision to borrow from SOURCE ? SOURCE Friends or relatives
"g109", -- Are you currently married or living together with a man as if married?
"g301b_b", -- How many of ITEM does your household currently have? ITEM Large livestock (oxen, cattle, donkeys)
"g501_e", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY Your own (singular) wage or salary employment
"g302_k", -- Who would you say owns most of the ITEM ? ITEM Small consumer durables (radio, CD DVD player, VCR player, cookware, iron, paraffin lamp, hot plate)
"g404_d", -- Is there a GROUP in your community? GROUP Credit or microfinance group (including merry-go-rounds, VSLAs (Village Savings and Loan Associations), ROSCAs (Rotating, Savings and Credit Associations), SACCOs (Savings and Credit Co-Operatives)
"g405_b", -- Are you an active member of this GROUP? GROUP Water users group
"g307_e", -- Has anyone in your household taken any loans or borrowed cash in-kind from SOURCE in the past 12 months? SOURCE Group based micro-finance or lending including merry-go-rounds, VSLAs (Village Savings and Loan Associations), ROSCAs (Rotating, Savings an
"g302_n", -- Who would you say owns most of the ITEM ? ITEM Means of transportation (bicycle, motorcycle, car, ox-cart)
"g404_h", -- Is there a GROUP in your community? GROUP Local government
"g202_d", -- How much input did you have in making decisions about ACTIVITY ? ACTIVITY Non-farm economic activities: This would include things like running a small business, self-employment, buy-and-sell
"g405_h", -- Are you an active member of this GROUP? GROUP Local government
"g201_c", -- Did you yourself participate in ACTIVITY in the past 12 months? ACTIVITY Livestock raising
"g304_c", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Small livestock (goats, pigs, sheep, rabbits)
"g404_i", -- Is there a GROUP in your community? GROUP Religious group
"g305_a", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Agricultural land (plots)
"g502_g", -- To what extent do you feel you can make your own personal decisions regarding these aspects of household life if you want(ed) to? ACTIVITY Minor household expenditures (such as food for daily consumption or other household needs)
"g502_c", -- To what extent do you feel you can make your own personal decisions regarding these aspects of household life if you want(ed) to? ACTIVITY Taking crops to the market (or not)
"g203_e", -- How much input did you have in decisions on the use of income generated from ACTIVITY ? ACTIVITY Wage and salary employment: This could be work that is paid for in cash or in-kind, including both agriculture and other wage work
"g404_c", -- Is there a GROUP in your community? GROUP Forest users group
"g301a_c", -- Does anyone in your household currently have any ITEM ? ITEM Small livestock (goats, pigs, sheep, rabbits)
"g405_d", -- Are you an active member of this GROUP? GROUP Credit or microfinance group (including merry-go-rounds, VSLAs (Village Savings and Loan Associations), ROSCAs (Rotating, Savings and Credit Associations), SACCOs (Savings and Credit Co-Operatives)
"g306_c", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Small livestock (goats, pigs, sheep, rabbits)
"g303_f", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Farm equipment (non-mechanized: hoe, sickle, animal-drawn ploughs, wheel barrow, sprayer, manual treadle pump)
"g305_c", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Small livestock (goats, pigs, sheep, rabbits)
"g305_e", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Fish pond or fishing equipment
"g405_e", -- Are you an active member of this GROUP? GROUP Mutual help or insurance group (including support groups)
"g302_h", -- Who would you say owns most of the ITEM ? ITEM Nonfarm business equipment (solar panels for recharging, solar inverter, solar battery, sewing machine, brewing equipment, fryers, generator, satellite dish, cooler boxes)
"g405_f", -- Are you an active member of this GROUP? GROUP Trade and business association
"g405_j", -- Are you an active member of this GROUP? GROUP Other women s group (only if it does not fit into one of the other categories)
"g405_c", -- Are you an active member of this GROUP? GROUP Forest users group
"g301a_h", -- Does anyone in your household currently have any ITEM ? ITEM Nonfarm business equipment (solar panels for recharging, solar inverter, solar battery, sewing machine, brewing equipment, fryers, generator, satellite dish, cooler boxes)
"g304_b", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Large livestock (oxen, cattle, donkeys)
"g202_b", -- How much input did you have in making decisions about ACTIVITY ? ACTIVITY Cash crop farming: These are crops that are grown primarily for sale in market
"g305_f", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Farm equipment (non-mechanized: hoe, sickle, animal-drawn ploughs, wheel barrow, sprayer, manual treadle pump)
"g301a_e", -- Does anyone in your household currently have any ITEM ? ITEM Fish pond or fishing equipment
"g306_e", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Fish pond or fishing equipment
"today", -- The day of interview as a string variable, MM-DD-YYYY
"country", -- These data were collected in Malawi
"g307_b", -- Has anyone in your household taken any loans or borrowed cash in-kind from SOURCE in the past 12 months? SOURCE Informal lender
"g402", -- Do you feel comfortable speaking up in public to ensure proper payment of wages for public works or other similar programs?
"g303_d", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Chickens, ducks, turkeys, guinea fowl, and pigeons
"g107", -- Are you 18 years old or older?
"g302_i", -- Who would you say owns most of the ITEM ? ITEM House or other structures
"g203_a", -- How much input did you have in decisions on the use of income generated from ACTIVITY ? ACTIVITY Food crop farming: These are crops that are grown primarily for household food consumption
"g302_c", -- Who would you say owns most of the ITEM ? ITEM Small livestock (goats, pigs, sheep, rabbits)
"subgroup3", -- The 7-district FTF FEEDBACK ZOI which will include district level data from rural areas only of Michinji, Lilongwe, Dedza, Mangochi, Ntcheu, Balaka, Machinga.
"weai_wt3", -- Individual sampling weight for primary female decisionmakers. This weight should be used for analyzing subgroup 3.
"g201_f", -- Did you yourself participate in ACTIVITY in the past 12 months? ACTIVITY Fishing or fishpond culture
"g104", -- Ability to be interviewed alone
"urbrur", -- Location type (urban rural)
"g306_b", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Large livestock (oxen, cattle, donkeys)
"g308_a", -- Who made the decision to borrow from SOURCE ? SOURCE Non-governmental organization (NGO)
"g306_g", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Farm equipment (mechanized: tractor-drawn plough, power tiller, motorized treadle pump groundnut sheller)
"g106", -- Please tell me how old you are. What was your age at your last birthday?
"g308_c", -- Who made the decision to borrow from SOURCE ? SOURCE Formal lender (bank financial institution e.g. OIBM, FINCA, PRIDE, CUMO)
"g201_d", -- Did you yourself participate in ACTIVITY in the past 12 months? ACTIVITY Non-farm economic activities: This would include things like running a small business, self-employment, buy-and-sell
"g203_b", -- How much input did you have in decisions on the use of income generated from ACTIVITY ? ACTIVITY Cash crop farming: These are crops that are grown primarily for sale in market
"g302_a", -- Who would you say owns most of the ITEM ? ITEM Agricultural land (plots)
"g309_c", -- Who makes the decision about what to do with the money item borrowed from SOURCE ? SOURCE Formal lender (bank financial institution e.g. OIBM, FINCA, PRIDE, CUMO)
"g502_d", -- To what extent do you feel you can make your own personal decisions regarding these aspects of household life if you want(ed) to? ACTIVITY Livestock raising
"g501_f", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY Major household expenditures (such as a large appliance for the house like a refrigerator)
"g202_e", -- How much input did you have in making decisions about ACTIVITY ? ACTIVITY Wage and salary employment: This could be work that is paid for in cash or in-kind, including both agriculture and other wage work
"g202_c", -- How much input did you have in making decisions about ACTIVITY ? ACTIVITY Livestock raising
"g302_m", -- Who would you say owns most of the ITEM ? ITEM Other land not used for agricultural purposes (pieces plots, residential or commercial land)
"g307_c", -- Has anyone in your household taken any loans or borrowed cash in-kind from SOURCE in the past 12 months? SOURCE Formal lender (bank financial institution e.g. OIBM, FINCA, PRIDE, CUMO)
"g601b", -- In the past 24 hours, did you work, either at home or outside the home, more than usual, about the same amount as usual, or less than usual?
"g301b_l", -- How many of ITEM does your household currently have? ITEM Cell phone
"g306_a", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Agricultural land (plots)
"g301b_k", -- How many of ITEM does your household currently have? ITEM Small consumer durables (radio, CD DVD player, VCR player, cookware, iron, paraffin lamp, hot plate)
"g502_e", -- To what extent do you feel you can make your own personal decisions regarding these aspects of household life if you want(ed) to? ACTIVITY Your own (singular) wage or salary employment
"g602", -- Next, I am going to ask you a question about how satisfied you are with the time you have to yourself to do things you enjoy. Please give your opinion on a scale of 1 to 10. 1 means you are not satisfied and 10 means you are very satisfied. If you are nei
"g301a_i", -- Does anyone in your household currently have any ITEM ? ITEM House or other structures
"g105_y", -- In what month and year were you born? Year
"g301b_n", -- How many of ITEM does your household currently have? ITEM Means of transportation (bicycle, motorcycle, car, ox-cart)
"g302_e", -- Who would you say owns most of the ITEM ? ITEM Fish pond or fishing equipment
"g405_a", -- Are you an active member of this GROUP? GROUP Agricultural livestock fisheries producer s group (including marketing groups)
"g304_a", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Agricultural land (plots)
"g308_b", -- Who made the decision to borrow from SOURCE ? SOURCE Informal lender
"g301a_b", -- Does anyone in your household currently have any ITEM ? ITEM Large livestock (oxen, cattle, donkeys)
"g301b_d", -- How many of ITEM does your household currently have? ITEM Chickens, ducks, turkeys, guinea fowl, and pigeons
"g309_a", -- Who makes the decision about what to do with the money item borrowed from SOURCE ? SOURCE Non-governmental organization (NGO)
"project", -- Identifies whether the record is used to report on Feed the Future (FTF), Food for Peace (FFP), Catholic Relief Services (CRS), or Project Concern International (PCI) programming. Due to coordinated survey collection, the same record may be used to evalu
"ghht", -- Derived gendered household type
"g303_a", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Agricultural land (plots)
"g305_g", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Farm equipment (mechanized: tractor-drawn plough, power tiller, motorized treadle pump groundnut sheller)
"g302_g", -- Who would you say owns most of the ITEM ? ITEM Farm equipment (mechanized: tractor-drawn plough, power tiller, motorized treadle pump groundnut sheller)
"g303_e", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Fish pond or fishing equipment
"g301a_l", -- Does anyone in your household currently have any ITEM ? ITEM Cell phone
"g301b_i", -- How many of ITEM does your household currently have? ITEM House or other structures
"g301b_f", -- How many of ITEM does your household currently have? ITEM Farm equipment (non-mechanized: hoe, sickle, animal-drawn ploughs, wheel barrow, sprayer, manual treadle pump)
"g301a_f", -- Does anyone in your household currently have any ITEM ? ITEM Farm equipment (non-mechanized: hoe, sickle, animal-drawn ploughs, wheel barrow, sprayer, manual treadle pump)
"g304_g", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Farm equipment (mechanized: tractor-drawn plough, power tiller, motorized treadle pump groundnut sheller)
"g405_g", -- Are you an active member of this GROUP? GROUP Civic groups (improving community) or charitable group (helping others)
"g309_d", -- Who makes the decision about what to do with the money item borrowed from SOURCE ? SOURCE Friends or relatives
"idcode", -- Woman s ID code
"g301a_n", -- Does anyone in your household currently have any ITEM ? ITEM Means of transportation (bicycle, motorcycle, car, ox-cart)
"g202_a", -- How much input did you have in making decisions about ACTIVITY ? ACTIVITY Food crop farming: These are crops that are grown primarily for household food consumption
"g302_b", -- Who would you say owns most of the ITEM ? ITEM Large livestock (oxen, cattle, donkeys)
"g301b_a", -- How many of ITEM does your household currently have? ITEM Agricultural land (plots)
"g303_c", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Small livestock (goats, pigs, sheep, rabbits)
"g303_g", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Farm equipment (mechanized: tractor-drawn plough, power tiller, motorized treadle pump groundnut sheller)
"g307_d", -- Has anyone in your household taken any loans or borrowed cash in-kind from SOURCE in the past 12 months? SOURCE Friends or relatives
"g301a_a", -- Does anyone in your household currently have any ITEM ? ITEM Agricultural land (plots)
"g301b_g", -- How many of ITEM does your household currently have? ITEM Farm equipment (mechanized: tractor-drawn plough, power tiller, motorized treadle pump groundnut sheller)
"g108", -- interviewer determined: Is the respondent 18 years old or older?
"g201_b", -- Did you yourself participate in ACTIVITY in the past 12 months? ACTIVITY Cash crop farming: These are crops that are grown primarily for sale in market
"g302_j", -- Who would you say owns most of the ITEM ? ITEM Large consumer durables (refrigerator, TV, sofa, dining table sets, beds)
"g301a_g", -- Does anyone in your household currently have any ITEM ? ITEM Farm equipment (mechanized: tractor-drawn plough, power tiller, motorized treadle pump groundnut sheller)
"g203_d", -- How much input did you have in decisions on the use of income generated from ACTIVITY ? ACTIVITY Non-farm economic activities: This would include things like running a small business, self-employment, buy-and-sell
"g302_f", -- Who would you say owns most of the ITEM ? ITEM Farm equipment (non-mechanized: hoe, sickle, animal-drawn ploughs, wheel barrow, sprayer, manual treadle pump)
"g105_m", -- In what month and year were you born? Month
"g203_c", -- How much input did you have in decisions on the use of income generated from ACTIVITY ? ACTIVITY Livestock raising
"g301a_k", -- Does anyone in your household currently have any ITEM ? ITEM Small consumer durables (radio, CD DVD player, VCR player, cookware, iron, paraffin lamp, hot plate)
"g304_f", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Farm equipment (non-mechanized: hoe, sickle, animal-drawn ploughs, wheel barrow, sprayer, manual treadle pump)
"g306_f", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Farm equipment (non-mechanized: hoe, sickle, animal-drawn ploughs, wheel barrow, sprayer, manual treadle pump)
"g502_a", -- To what extent do you feel you can make your own personal decisions regarding these aspects of household life if you want(ed) to? ACTIVITY Getting inputs for agricultural production
"g303_b", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Large livestock (oxen, cattle, donkeys)
"g302_l", -- Who would you say owns most of the ITEM ? ITEM Cell phone
"g501_d", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY Livestock raising
"g501_a", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY Getting inputs for agricultural production
"pbs_id", -- Administrative variable for identifying households
"g305_b", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Large livestock (oxen, cattle, donkeys)
"g404_e" -- Is there a GROUP in your community? GROUP Mutual help or insurance group (including support groups)
FROM
"datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-7s2q-5769:latest"."feed_the_future_malawi_interim_survey_in_the_zone"
LIMIT 100;Connecting to the DDN is easy. All you need is an existing SQL client that can connect to Postgres. As long as you have a SQL client ready, you'll be able to query datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-7s2q-5769 with SQL in under 60 seconds.
Query Your Local Engine
Install Splitgraph Locally
bash -c "$(curl -sL https://github.com/splitgraph/splitgraph/releases/latest/download/install.sh)"Read the installation docs.
Splitgraph Cloud is built around Splitgraph Core (GitHub), which includes a local Splitgraph Engine packaged as a Docker image. Splitgraph Cloud is basically a scaled-up version of that local Engine. When you query the Data Delivery Network or the REST API, we mount the relevant datasets in an Engine on our servers and execute your query on it.
It's possible to run this engine locally. You'll need a Mac, Windows or Linux system to install sgr, and a Docker installation to run the engine. You don't need to know how to actually use Docker; sgrcan manage the image, container and volume for you.
There are a few ways to ingest data into the local engine.
For external repositories, the Splitgraph Engine can "mount" upstream data sources by using sgr mount. This feature is built around Postgres Foreign Data Wrappers (FDW). You can write custom "mount handlers" for any upstream data source. For an example, we blogged about making a custom mount handler for HackerNews stories.
For hosted datasets (like this repository), where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Cloning Data
Because datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-7s2q-5769:latest is a Splitgraph Image, you can clone the data from Spltgraph Cloud to your local engine, where you can query it like any other Postgres database, using any of your existing tools.
First, install Splitgraph if you haven't already.
Clone the metadata with sgr clone
This will be quick, and does not download the actual data.
sgr clone datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-7s2q-5769Checkout the data
Once you've cloned the data, you need to "checkout" the tag that you want. For example, to checkout the latest tag:
sgr checkout datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-7s2q-5769:latestThis will download all the objects for the latest tag of datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-7s2q-5769 and load them into the Splitgraph Engine. Depending on your connection speed and the size of the data, you will need to wait for the checkout to complete. Once it's complete, you will be able to query the data like you would any other Postgres database.
Alternatively, use "layered checkout" to avoid downloading all the data
The data in datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-7s2q-5769:latest is 0 bytes. If this is too big to download all at once, or perhaps you only need to query a subset of it, you can use a layered checkout.:
sgr checkout --layered datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-7s2q-5769:latestThis will not download all the data, but it will create a schema comprised of foreign tables, that you can query as you would any other data. Splitgraph will lazily download the required objects as you query the data. In some cases, this might be faster or more efficient than a regular checkout.
Read the layered querying documentation to learn about when and why you might want to use layered queries.
Query the data with your existing tools
Once you've loaded the data into your local Splitgraph Engine, you can query it with any of your existing tools. As far as they're concerned, datahub-usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-7s2q-5769 is just another Postgres schema.