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_nepal_interim_survey_in_the_zone table in this repository, by referencing it like:
"usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-7h5n-zy2q:latest"."feed_the_future_nepal_interim_survey_in_the_zone"or in a full query, like:
SELECT
":id", -- Socrata column ID
"g306_d", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Chickens, ducks, turkeys, and pigeons
"g304_c", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Small livestock (for example, goats, pigs, sheep)
"g501_a", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY Getting inputs for agricultural production
"g303_f", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Farm equipment (non-mechanized: for example, hand tools, animal-drawn ploughs)
"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
"g305_f", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Farm equipment (non-mechanized: for example, hand tools, animal-drawn ploughs)
"g201_f", -- Did you yourself participate in ACTIVITY in the past 12 months? ACTIVITY Fishing or fishpond culture
"survey", -- These data were collected in the 2015 Interim Zone of Influence Survey.
"g501_d", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY Livestock raising
"g302_k", -- Who would you say owns most of the ITEM ? ITEM Small consumer durables (for example, radio, cookware, pressure cooker, LPG gas stove and gas cylinder, fan)
"g303_e", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Fish pond or fishing equipment
"g302_a", -- Who would you say owns most of the ITEM ? ITEM Agricultural land (for example, parcels)
"g404_g", -- Is there a GROUP in your community? GROUP Civic groups (improving community) or charitable group (helping others)
"g302_e", -- Who would you say owns most of the ITEM ? ITEM Fish pond or fishing equipment
"g309_b", -- Who makes the decision about what to do with the money item borrowed from SOURCE ? SOURCE informal lender (money lender)
"g405_b", -- Are you an active member of this GROUP? GROUP Water users group
"g302_i", -- Who would you say owns most of the ITEM ? ITEM House or other structures
"g306_a", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Agricultural land (for example, parcels)
"g303_b", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Large livestock (for example, oxen, cattle)
"weai_wt", -- Individual sampling weight for primary female decisionmakers
"g405_f", -- Are you an active member of this GROUP? GROUP Trade and business association (Chamber of Commerce, FNCCI, Gorahi traders association)
"g304_b", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Large livestock (for example, oxen, cattle)
"g304_e", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Fish pond or fishing equipment
"g301b_a", -- How many of ITEM does your household currently have? ITEM Agricultural land (for example, parcels)
"g301b_j", -- How many of ITEM does your household currently have? ITEM Large consumer durables (for example, refrigerator, TV, sofa)
"g301b_g", -- How many of ITEM does your household currently have? ITEM Farm equipment (mechanized: for example, tractor-drawn plough, power tiller, treadle pump)
"g110", -- Have you ever been married?
"g305_b", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Large livestock (for example, oxen, cattle)
"g305_d", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Chickens, ducks, turkeys, and pigeons
"g202_f", -- How much input did you have in making decisions about ACTIVITY ? ACTIVITY Fishing or fishpond culture
"g304_a", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Agricultural land (for example, parcels)
"g301b_f", -- How many of ITEM does your household currently have? ITEM Farm equipment (non-mechanized: for example, hand tools, animal-drawn ploughs)
"urbrur", -- Location type (urban rural)
"g309_a", -- Who makes the decision about what to do with the money item borrowed from SOURCE ? SOURCE Non-governmental organization (NGO)
"g302_h", -- Who would you say owns most of the ITEM ? ITEM Nonfarm business equipment (for example, blacksmith, cobbler, tailor, auto-repair shop)
"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
"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 neither satisfied nor dissatisfied, this would be in the middle, or 5, on the scale. How satisfied are you with your available time for leisure activities like visiting neighbors, watching TV, listening to the ratio, seeing movies or doing sports?
"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)
"zoi", -- This variable indicates that a record is included in the Feed the Future Zone of Influence. The ZOI includes the Far-Western, Mid-Western and Western regions.
"g405_a", -- Are you an active member of this GROUP? GROUP Agricultural livestock fisheries producer s group (including marketing groups)
"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 VSLAs, saving and credit group, farmer s group cooperatives, commodity-based groups, or cooperatives registered under cooperatives act of Nepal
"g306_e", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Fish pond or fishing equipment
"g301a_k", -- Does anyone in your household currently have any ITEM ? ITEM Small consumer durables (for example, radio, cookware, pressure cooker, LPG gas stove and gas cylinder, fan)
"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
"g308_c", -- Who made the decision to borrow from SOURCE ? SOURCE formal lender (bank financial institution, such as Commercial bank, or a microfinance bank)
"g301b_k", -- How many of ITEM does your household currently have? ITEM Small consumer durables (for example, radio, cookware, pressure cooker, LPG gas stove and gas cylinder, fan)
"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?
"g404_f", -- Is there a GROUP in your community? GROUP Trade and business association (Chamber of Commerce, FNCCI, Gorahi traders association)
"g306_b", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Large livestock (for example, oxen, cattle)
"g202_c", -- How much input did you have in making decisions about ACTIVITY ? ACTIVITY Livestock raising
"g301b_b", -- How many of ITEM does your household currently have? ITEM Large livestock (for example, oxen, cattle)
"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?
"g306_f", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Farm equipment (non-mechanized: for example, hand tools, animal-drawn ploughs)
"g305_a", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Agricultural land (for example, parcels)
"g303_c", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Small livestock (for example, goats, pigs, sheep)
"g305_c", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Small livestock (for example, goats, pigs, sheep)
"g303_d", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Chickens, ducks, turkeys, and pigeons
"g301a_e", -- Does anyone in your household currently have any ITEM ? ITEM Fish pond or fishing equipment
"g301a_a", -- Does anyone in your household currently have any ITEM ? ITEM Agricultural land (for example, parcels)
"stratum", -- Administrative variable for identifying the strata of sampling designs. Unstratified samples have a constant value of 1.
"g105_y", -- In what month and year were you born? Year
"g308_a", -- Who made the decision to borrow from SOURCE ? SOURCE Non-governmental organization (NGO)
"g405_g", -- Are you an active member of this GROUP? GROUP Civic groups (improving community) or charitable group (helping others)
"g301a_m", -- Does anyone in your household currently have any ITEM ? ITEM Other land not used for agricultural purposes (for example, parcels of residential or commercial land)
"g301a_h", -- Does anyone in your household currently have any ITEM ? ITEM Nonfarm business equipment (for example, blacksmith, cobbler, tailor, auto-repair shop)
"g301b_i", -- How many of ITEM does your household currently have? ITEM House or other structures
"g303_g", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Farm equipment (mechanized: for example, tractor-drawn plough, power tiller, treadle pump)
"g405_i", -- Are you an active member of this GROUP? GROUP Religious group (such as shiva sena, swargadwari guthi)
"g306_c", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Small livestock (for example, goats, pigs, sheep)
"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
"g302_j", -- Who would you say owns most of the ITEM ? ITEM Large consumer durables (for example, refrigerator, TV, sofa)
"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)
"g203_c", -- How much input did you have in decisions on the use of income generated from ACTIVITY ? ACTIVITY Livestock raising
"g405_e", -- Are you an active member of this GROUP? GROUP Mutual help or insurance group (including traditional associations that help on occasions such as weddings, religious ceremonies, cremations or burials, etc.)
"g308_e", -- Who made the decision to borrow from SOURCE ? SOURCE Group based micro-finance or lending including VSLAs, saving and credit group, farmer s group cooperatives, commodity-based groups, or cooperatives registered under cooperatives act of Nepal
"g501_b", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY The types of crops to grow
"country", -- These data were collected in the Feed the Future Zone of Influence in Nepal.
"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_d", -- Does anyone in your household currently have any ITEM ? ITEM Chickens, ducks, turkeys, and pigeons
"g302_m", -- Who would you say owns most of the ITEM ? ITEM Other land not used for agricultural purposes (for example, parcels of residential or commercial land)
"g301b_h", -- How many of ITEM does your household currently have? ITEM Nonfarm business equipment (for example, blacksmith, cobbler, tailor, auto-repair shop)
"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, such as Commercial bank, or a microfinance bank)
"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_b", -- Does anyone in your household currently have any ITEM ? ITEM Large livestock (for example, oxen, cattle)
"g302_n", -- Who would you say owns most of the ITEM ? ITEM Means of transportation (for example, bicycle, motorcycle, car, tractor, animal driven cart)
"g501_e", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY Your own (singular) wage or salary employment
"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 (for example, parcels of residential or commercial land)
"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
"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
"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
"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)
"pbs_id", -- Administrative variable for identifying households
"g303_a", -- Who would you say can decide whether to sell ITEM most of the time? ITEM Agricultural land (for example, parcels)
"g106", -- Please tell me how old you are. What was your age at your last birthday?
"g203_f", -- How much input did you have in decisions on the use of income generated from ACTIVITY ? ACTIVITY Fishing or fishpond culture
"g301a_j", -- Does anyone in your household currently have any ITEM ? ITEM Large consumer durables (for example, refrigerator, TV, sofa)
"g304_d", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Chickens, ducks, turkeys, and pigeons
"g302_b", -- Who would you say owns most of the ITEM ? ITEM Large livestock (for example, oxen, cattle)
"g309_d", -- Who makes the decision about what to do with the money item borrowed from SOURCE ? SOURCE Friends or relatives
"g402", -- Do you feel comfortable speaking up in public to ensure proper payment of wages for public works or other similar programs?
"g305_e", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Fish pond or fishing equipment
"g301a_c", -- Does anyone in your household currently have any ITEM ? ITEM Small livestock (for example, goats, pigs, sheep)
"g302_d", -- Who would you say owns most of the ITEM ? ITEM Chickens, ducks, turkeys, and pigeons
"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 VSLAs, saving and credit group, farmer s group cooperatives, commodity-based groups, or cooperatives registered under cooperatives act of Nepal
"g404_b", -- Is there a GROUP in your community? GROUP Water users group
"g302_f", -- Who would you say owns most of the ITEM ? ITEM Farm equipment (non-mechanized: for example, hand tools, animal-drawn ploughs)
"g404_c", -- Is there a GROUP in your community? GROUP Forest users group
"g501_c", -- When decisions are made regarding ACTIVITY , who is it that normally takes the decision? ACTIVITY Taking crops to the market (or not)
"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_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)
"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)
"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
"g301b_d", -- How many of ITEM does your household currently have? ITEM Chickens, ducks, turkeys, and pigeons
"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
"g302_g", -- Who would you say owns most of the ITEM ? ITEM Farm equipment (mechanized: for example, tractor-drawn plough, power tiller, treadle pump)
"g404_d", -- Is there a GROUP in your community? GROUP Credit or microfinance group (for example, VSLAs, saving and credit group, farmer s group cooperatives, commodity-based groups, or cooperatives registered under cooperatives act of Nepal)
"g111", -- What is your marital status now: are you widowed, divorced, or separated?
"today", -- Survey Date
"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
"idcode", -- Woman s ID code
"g301b_l", -- How many of ITEM does your household currently have? ITEM Cell phone
"g301a_i", -- Does anyone in your household currently have any ITEM ? ITEM House or other structures
"g301a_l", -- Does anyone in your household currently have any ITEM ? ITEM Cell phone
"g308_d", -- Who made the decision to borrow from SOURCE ? SOURCE Friends or relatives
"g305_g", -- Who would you say can decide to mortgage or rent out ITEM most of the time? ITEM Farm equipment (mechanized: for example, tractor-drawn plough, power tiller, treadle pump)
"g201_c", -- Did you yourself participate in ACTIVITY in the past 12 months? ACTIVITY Livestock raising
"g306_g", -- Who contributes most to decisions regarding a new purchase of ITEM ? ITEM Farm equipment (mechanized: for example, tractor-drawn plough, power tiller, treadle pump)
"g105_m", -- In what month and year were you born? Month
"g301b_c", -- How many of ITEM does your household currently have? ITEM Small livestock (for example, goats, pigs, sheep)
"g108", -- interviewer determined: Is the respondent 18 years old or older?
"g405_h", -- Are you an active member of this GROUP? GROUP Local government (Village Development Committee, District Development Committee)
"g405_d", -- Are you an active member of this GROUP? GROUP Credit or microfinance group (for example, VSLAs, saving and credit group, farmer s group cooperatives, commodity-based groups, or cooperatives registered under cooperatives act of Nepal)
"g301a_f", -- Does anyone in your household currently have any ITEM ? ITEM Farm equipment (non-mechanized: for example, hand tools, animal-drawn ploughs)
"g405_c", -- Are you an active member of this GROUP? GROUP Forest users group
"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)
"g109", -- Are you currently married?
"g309_c", -- Who makes the decision about what to do with the money item borrowed from SOURCE ? SOURCE formal lender (bank financial institution, such as Commercial bank, or a microfinance bank)
"g107", -- Are you 18 years old or older?
"g404_h", -- Is there a GROUP in your community? GROUP Local government (Village Development Committee, District Development Committee)
"g308_b", -- Who made the decision to borrow from SOURCE ? SOURCE informal lender (money lender)
"interidg", -- Module G interviewer code
"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 (money lender)
"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
"g301a_n", -- Does anyone in your household currently have any ITEM ? ITEM Means of transportation (for example, bicycle, motorcycle, car, tractor, animal driven cart)
"g301b_n", -- How many of ITEM does your household currently have? ITEM Means of transportation (for example, bicycle, motorcycle, car, tractor, animal driven cart)
"g301a_g", -- Does anyone in your household currently have any ITEM ? ITEM Farm equipment (mechanized: for example, tractor-drawn plough, power tiller, treadle pump)
"g302_c", -- Who would you say owns most of the ITEM ? ITEM Small livestock (for example, goats, pigs, sheep)
"g404_a", -- Is there a GROUP in your community? GROUP Agricultural livestock fisheries producer s group (including marketing groups)
"g404_k", -- Is there a GROUP in your community? GROUP Any other group or organization, specified
"g304_g", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Farm equipment (mechanized: for example, tractor-drawn plough, power tiller, treadle pump)
"g404_e", -- Is there a GROUP in your community? GROUP Mutual help or insurance group (including traditional associations that help on occasions such as weddings, religious ceremonies, cremations or burials, etc.)
"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
"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
"g104", -- Ability to be interviewed alone
"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
"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_l", -- Who would you say owns most of the ITEM ? ITEM Cell phone
"g404_i", -- Is there a GROUP in your community? GROUP Religious group (such as shiva sena, swargadwari guthi)
"cluster", -- Cluster number
"g304_f", -- Who would you say can decide whether to give away ITEM most of the time? ITEM Farm equipment (non-mechanized: for example, hand tools, animal-drawn ploughs)
"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
"g301b_e" -- How many of ITEM does your household currently have? ITEM Fish pond or fishing equipment
FROM
"usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-7h5n-zy2q:latest"."feed_the_future_nepal_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 usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-7h5n-zy2q 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 usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-7h5n-zy2q: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 usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-7h5n-zy2qCheckout 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 usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-7h5n-zy2q:latestThis will download all the objects for the latest tag of usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-7h5n-zy2q 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 usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-7h5n-zy2q: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 usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-7h5n-zy2q: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, usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-7h5n-zy2q is just another Postgres schema.