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-ta8n-dpmd:latest"."feed_the_future_nepal_interim_survey_in_the_zone"or in a full query, like:
SELECT
":id", -- Socrata column ID
"cluster", -- Cluster number
"w_nrvcc4", -- This measure identifies whether NRVCC was consumed in the prior day. The weighted mean of this measure will produce the Feed the Future prevalence indicator. NRVCC Mustard leaves, spinach, pumpkin leaves, yam leaves, coriander leaves, colocasia leaves, fermented green leafy vegetables, or any other dark leafy green vegetables
"w_grains", -- This measure indicates that the women consumed grains or starchy root vegetables.
"h16_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD White potatoes, white yams, colocasia bulbs, sweet potatoes, or any other foods made from roots?
"h19a_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any meat from domesticated animals, such as beef, pork, buffalo, lamb, goat, chicken, or duck?
"h17c_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any cabbage?
"survey", -- These data were collected in the 2015 Interim Zone of Influence Survey.
"w_dairy", -- This measure indicates that the women consumed milk, cheese, yogurt or other foods made from animal milk.
"h15_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Carrots, squash, or sweet potatoes that are yellow or orange inside?
"hresp", -- Line number of Module H respondent
"w_othfrt", -- This measure indicates that the women consumed other fruits.
"w_othveg", -- This measure indicates that the women consumed other vegetables.
"h24a_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any foods made from beans, peas, or lentils, including mixed pulse dishes, or any other legumes?
"h17b_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any cauliflower?
"stratum", -- Administrative variable for identifying the strata of sampling designs. Unstratified samples have a constant value of 1.
"h17c", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any cabbage?
"h24c_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any foods made from nuts or seeds, such as sesame seeds?
"h15_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Carrots, squash, or sweet potatoes that are yellow or orange inside?
"h18_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Ripe mangoes, ripe papayas, or apricots?
"h24b", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any food made from groundnut or groundnut products such as groundnut flour, peanut butter, roasted groundnuts, boiled groundnut snack, sauces, groundnut biscuits?
"w_nrvcc_any", -- This measure identifies whether the any of the targeted nutrient-rich value chain commodities were consumed in the prior day. The weighted mean of this measure will produce the Feed the Future prevalence indicator.
"w_vita", -- This measure indicates that the women consumed orange-fleshed fruits or vegetables, red palm products, or other foods high in vitamin A.
"h17f_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any bitter gourd?
"h27", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any sugary foods such as chocolates, sweets, candies, pastries, cakes, or biscuits?
"h19a", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any meat from domesticated animals, such as beef, pork, buffalo, lamb, goat, chicken, or duck?
"h19_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any liver, kidney, heart, or other organ meats from domesticated animals such as beef, pork, buffalo, lamb, goat, chicken, or duck?
"h30_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Foods made with red palm oil, red palm nut, or red palm nut pulp sauce?
"h24a", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any foods made from beans, peas, or lentils, including mixed pulse dishes, or any other legumes?
"w_foodmiss", -- This is a flag variable that indicates that questions H14 - H30 are all missing. This variable is created to exclude records missing the dietary information from analyses.
"ethnic", -- This variable represents the reported ethnic class of the household.
"w_foodsum10", -- Calculated as the sum of 10 food groups: w_grains, w_beans, w_nuts, w_dairy, w_eggs, w_meatfish, w_lfygrn, w_vita, w_othveg, w_othfrt
"bmicat", -- Underweight (BMI 18.5), Normal (18.5 BMI 25), Overweight Obese (BMI 25)
"h14", -- Yesterday during the day or night, did you drink eat any FOOD ? FOOD Food made from grains, such roti, rice, maize, millet, buckwheat, barley, noodles; porridge made from corn, millet or wheat flour; or any other foods made from grains?
"w_beans", -- This measure indicates that the women consumed beans or other types of legumes.
"h17e_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any okra?
"h06", -- Are you currently pregnant?
"h02_y", -- In what month and year were you born?
"ecozone", -- This variable identifies the ecological zone.
"w_nrvcc1", -- This measure identifies whether targeted nutrient-rich value chain commodity was consumed in the prior day. The weighted mean of this measure will produce the Feed the Future prevalence indicator. NRVCC Cauliflower
"h24c_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any foods made from nuts or seeds, such as sesame seeds?
"women_wt", -- Individual sampling weight for women aged 15 to 49 years
"h17_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any mustard leaves or spinach?
"h28_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Condiments for flavor, such as chilies, spices, herbs, fish powder or garlic?
"h17g_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any other vegetables?
"w_nrvcc5", -- This measure identifies whether NRVCC was consumed in the prior day. The weighted mean of this measure will produce the Feed the Future prevalence indicator. NRVCC Okra
"h04", -- Are you between the ages of 15 and 49 years old?
"h17a_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any pumpkin leaves, yam leaves, coriander leaves, colocasia leaves, fermented green leafy vegetables, or any other dark leafy green vegetables?
"h19_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any liver, kidney, heart, or other organ meats from domesticated animals such as beef, pork, buffalo, lamb, goat, chicken, or duck?
"h28_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Condiments for flavor, such as chilies, spices, herbs, fish powder or garlic?
"h17f_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any bitter gourd?
"h20", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any liver, kidney, heart, or other organ meats from wild animals such as deer, spotted deer, wild chicken, wild boar, or tahr?
"h16_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD White potatoes, white yams, colocasia bulbs, sweet potatoes, or any other foods made from roots?
"h26_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any oil, fats, or butter, or foods made with any of these?
"h15", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Carrots, squash, or sweet potatoes that are yellow or orange inside?
"h17b", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any cauliflower?
"h17e", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any okra?
"urbrur", -- Location type (urban rural)
"h17e_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any okra?
"h17a", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any pumpkin leaves, yam leaves, coriander leaves, colocasia leaves, fermented green leafy vegetables, or any other dark leafy green vegetables?
"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.
"w_nrvcc2", -- This measure identifies whether NRVCC was consumed in the prior day. The weighted mean of this measure will produce the Feed the Future prevalence indicator. NRVCC Cabbage
"h17d_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any pumpkin?
"h17", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any mustard leaves or spinach?
"bmi", -- Women s BMI calculated as height weight (squared)
"np_wrasample", -- This flag variable indicates that the woman is aged 15 to 49 years and not pregnant, based on question H06.
"h27_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any sugary foods such as chocolates, sweets, candies, pastries, cakes, or biscuits?
"h17b_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any cauliflower?
"w_nutsbeans", -- This measure indicates that the women consumed beans, other types of legumes, nuts, or seeds.
"h17d", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any pumpkin?
"w_organmeat", -- This measure indicates that the women consumed organ meat from wild or domesticated animals.
"h20a_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any flesh from wild animals, such as deer, spotted deer, wild chicken, wild boar, or tahr?
"h22_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Eggs, such as chicken eggs?
"w_eggs", -- This measure indicates that the women consumed eggs.
"h28", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Condiments for flavor, such as chilies, spices, herbs, fish powder or garlic?
"h29", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Grubs, snails or insects?
"h23", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Fresh or dried fish, shellfish, or seafood?
"h18", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Ripe mangoes, ripe papayas, or apricots?
"w_nrvcc6", -- This measure identifies whether NRVCC was consumed in the prior day. The weighted mean of this measure will produce the Feed the Future prevalence indicator. NRVCC Bitter gourd
"country", -- These data were collected in the Feed the Future Zone of Influence in Nepal.
"h24b_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any food made from groundnut or groundnut products such as groundnut flour, peanut butter, roasted groundnuts, boiled groundnut snack, sauces, groundnut biscuits?
"h20a_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any flesh from wild animals, such as deer, spotted deer, wild chicken, wild boar, or tahr?
"h17_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any mustard leaves or spinach?
"h23_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Fresh or dried fish, shellfish, or seafood?
"underwght", -- Prevalence of underweight (BMI 18.5) among non-pregnant women aged 15-49. This is a Feed the Future indicator.
"h26", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any oil, fats, or butter, or foods made with any of these?
"h18_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Ripe mangoes, ripe papayas, or apricots?
"h17g", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any other vegetables?
"h25_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Milk, cheese, yogurt, or other milk products?
"h25_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Milk, cheese, yogurt, or other milk products?
"h19", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any liver, kidney, heart, or other organ meats from domesticated animals such as beef, pork, buffalo, lamb, goat, chicken, or duck?
"h17c_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any cabbage?
"h24b_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any food made from groundnut or groundnut products such as groundnut flour, peanut butter, roasted groundnuts, boiled groundnut snack, sauces, groundnut biscuits?
"idcode", -- Woman s ID code
"w_nrvcc3", -- This measure identifies whether NRVCC was consumed in the prior day. The weighted mean of this measure will produce the Feed the Future prevalence indicator. NRVCC Pumpkin
"h24a_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any foods made from beans, peas, or lentils, including mixed pulse dishes, or any other legumes?
"h20a", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any flesh from wild animals, such as deer, spotted deer, wild chicken, wild boar, or tahr?
"h24c", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any foods made from nuts or seeds, such as sesame seeds?
"h20_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any liver, kidney, heart, or other organ meats from wild animals such as deer, spotted deer, wild chicken, wild boar, or tahr?
"h17d_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any pumpkin?
"h17f", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any bitter gourd?
"h29_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Grubs, snails or insects?
"h18a_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any other fruits such as peaches, apples or persimmon?
"h30", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Foods made with red palm oil, red palm nut, or red palm nut pulp sauce?
"h23_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Fresh or dried fish, shellfish, or seafood?
"w_nuts", -- This measure indicates that the women consumed nuts or seeds.
"h18a", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Any other fruits such as peaches, apples or persimmon?
"h22_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Eggs, such as chicken eggs?
"h26_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any oil, fats, or butter, or foods made with any of these?
"h05", -- interviewer determined: Is the respondent between the ages of 15 and 49?
"pbs_id", -- Administrative variable for identifying households
"h07", -- Measured weight in kilograms
"h08", -- Measured height in centimeters
"h22", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Eggs, such as chicken eggs?
"h25", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD Milk, cheese, yogurt, or other milk products?
"h18a_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any other fruits such as peaches, apples or persimmon?
"w_meatfish", -- This variable indicates that the women consumed organ or flesh meat from wild or domesticated animals.
"w_mdd", -- Calculated where 1 w_foodsum10 5 . This is the Feed the Future new indicator for women achieving a minimum dietary diversity, or 5 of the 10 food groups.
"h14_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Food made from grains, such roti, rice, maize, millet, buckwheat, barley, noodles; porridge made from corn, millet or wheat flour; or any other foods made from grains?
"h17a_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any pumpkin leaves, yam leaves, coriander leaves, colocasia leaves, fermented green leafy vegetables, or any other dark leafy green vegetables?
"h29_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Grubs, snails or insects?
"h14_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Food made from grains, such roti, rice, maize, millet, buckwheat, barley, noodles; porridge made from corn, millet or wheat flour; or any other foods made from grains?
"w_lfygrn", -- This measure indicates that the women consumed dark green leafy vegetables.
"w_othfrtveg", -- This variable indicates that the women consumed other fruits or vegetables.
"h02_m", -- In what month and year were you born?
"h03", -- Please tell me how old you are. What was your age your last birthday?
"h16", -- This variable combines the spontaneously reported and the prompted recall of consumption of FOOD ? FOOD White potatoes, white yams, colocasia bulbs, sweet potatoes, or any other foods made from roots?
"h17g_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any other vegetables?
"h19a_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any meat from domesticated animals, such as beef, pork, buffalo, lamb, goat, chicken, or duck?
"h20_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Any liver, kidney, heart, or other organ meats from wild animals such as deer, spotted deer, wild chicken, wild boar, or tahr?
"h30_s", -- Respondent reported eating FOOD while describing the food eaten the prior day. FOOD Foods made with red palm oil, red palm nut, or red palm nut pulp sauce?
"h27_p", -- When failing to mention FOOD during the reporting of foods eaten during the prior day, the respondents were asked, Yesterday, during the day or night, did you drink eat any FOOD ? FOOD Any sugary foods such as chocolates, sweets, candies, pastries, cakes, or biscuits?
"height", -- Women s height in meters, based on reported height in centimeters in h08.
"weight", -- Women s weight in kilograms as reported in h07.
"wrasample", -- This flag variable indicates that the woman is aged 15 to 49 years.
"w_flesh", -- This measure indicates that the women consumed flesh meat from wild or domesticated animals.
"w_foodsum9", -- Calculated as the sum of 9 food groups: w_grains, w_nutsbeans, w_dairy, w_eggs, w_organmeat, w_flesh, w_lfygrn, w_vita, w_othfrtveg. The weighted mean of this variable is a Feed the Future indicator of women s dietary diversity.
"today" -- Survey Date
FROM
"usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-ta8n-dpmd: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-ta8n-dpmd with SQL in under 60 seconds.
This repository is an "external" repository. That means it's hosted elsewhere, in this case at data.usaid.gov. When you queryusaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-ta8n-dpmd:latest on the DDN, we "mount" the repository using the socrata mount handler. The mount handler proxies your SQL query to the upstream data source, translating it from SQL to the relevant language (in this case SoQL).
We also cache query responses on the DDN, but we run the DDN on multiple nodes so a CACHE_HIT is only guaranteed for subsequent queries that land on the same node.
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 (like this repository), 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, where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Mounting Data
This repository is an external repository. It's not hosted by Splitgraph. It is hosted by data.usaid.gov, and Splitgraph indexes it. This means it is not an actual Splitgraph image, so you cannot use sgr clone to get the data. Instead, you can use the socrata adapter with the sgr mount command. Then, if you want, you can import the data and turn it into a Splitgraph image that others can clone.
First, install Splitgraph if you haven't already.
Mount the table with sgr mount
sgr mount socrata \
"usaid-gov/feed-the-future-nepal-interim-survey-in-the-zone-ta8n-dpmd" \
--handler-options '{
"domain": "data.usaid.gov",
"tables": {
"feed_the_future_nepal_interim_survey_in_the_zone": "ta8n-dpmd"
}
}'That's it! Now you can query the data in the mounted table like any other Postgres table.
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-ta8n-dpmd is just another Postgres schema.