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 final_report_of_the_asian_american_quality_of_life table in this repository, by referencing it like:
"datahub-austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z:latest"."final_report_of_the_asian_american_quality_of_life"or in a full query, like:
SELECT
":id", -- Socrata column ID
"grandchild", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"drinking", -- Section 3: Question 6. Has anyone ever told you that you have a drinking problem?
"cancer", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions?
"homemaker", -- Question 9. What is your current employment status? (Check all that apply)
"heart_dis", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions?
"retired", -- Question 9. What is your current employment status? (Check all that apply)
"us_born", -- Section 2: Question 1. Were you born in the United States?
"identity", -- Section 2: Question 8. How closely do you identify with people of your ethnic origin?
"occ_oth", -- Question 10. IF YOU ARE EMPLOYED, what kind of work do you do?
"eng_prim", -- Section 2: Question 3. Is English your primary language?
"encul", -- Section 2: Question 7. How would you rate your level of familiarity with the culture and custom of your ethnic origin?
"howlongus", -- Section 2: Question 2. How long have you lived in the United States? __________ years
"smoking", -- Section 3: Question 5. Are you currently using tobacco products?
"oth_ncb_eth_dscrb", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"access_comp_int", -- Section 7: Question 17. Do you have access to a computer and the Internet?
"emp_oth", -- Question 9. What is your current employment status? (Check all that apply)
"trans_oth", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis?
"heal_info_othr", -- Section 3: Question 21. Where do you get health-related information?
"website_ncb_gen", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"carpooling", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis?
"smk_detect", -- Section 7: Question 12. Do you have smoke detection alarms in your home?
"concerns", -- Section 7: Question 25. Please describe any concerns you may have as an Austin Resident.
"fs3", -- Section 6: Question 3. Things work well for us as a family.
"satisf_housing", -- Question 10. How much are you satisfied with your current housing condition?
"mhs4", -- Section 4: Question 7. Please indicate if you have used each of the following professionals during the past 12 months about a problem with your emotional or mental health.
"sroh", -- Section 3: Question 3. How would you rate your dental/oral health at the present time?
"d_willingc", -- Section 4: Question 8. If you have depression, would you be willing to use counseling?
"own_home", -- Section 7: Question 9. Do you (and your family) own your home, rent it, or what?
"place_live", -- Section 7: Question 2. The City of Austin as a place to live
"free_fire_alarm", -- Section 7: Question 7. Do you know that Fire Department provides free smoke detection alarms for your home?
"hypertension", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions?
"visit_aarc_freq", -- Section 7: Question 5. How often do you visit AARC?
"place_traffic", -- Section 7: Question 2. Traffic in the City of Austin
"acc", -- Section 2: Question 6. How would you rate your level of familiarity with the culture and custom of mainstream America?
"sns_ncb_gen", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"court", -- Section 7: Question 3. Municipal court services (i.e. traffic, fine collection)
"healthydiet", -- Section 3: Question 8. Do you maintain a healthy diet?
"howlong_aus", -- Section 7: Question 1. How long have you lived in Austin area? __________ years
"paper_ncb_gen", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"sns_ncb_eth", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"rel_imp", -- Section 6: Question 5. How important is religion in your life?
"paper_cb", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"fs10", -- Section 6: Question 3. Family togetherness is very important to our family.
"fs9", -- Section 6: Question 3. My family members feel very close to each other.
"fs6", -- Section 6: Question 3. We are proud of our family.
"fs2", -- Section 6: Question 3. We share similar values and beliefs as a family.
"website_cb", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"car_share", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis?
"n6", -- Section 6: Question 2. How many friends do you feel close to such that you could call on them for help?
"n4", -- Section 6: Question 2. How many of your friends do you see or hear from at least once a month?
"n2", -- Section 6: Question 1. How many family/relatives do you feel at ease with that you can talk about private matters?
"n1", -- Section 6: Question 1. How many family/relatives do you see or hear from at least once a month?
"arthritis", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions?
"fgd_city", -- Section 7: Question 20. Participated in a survey or focus groups (online or in-person) conducted by the City
"vote", -- Section 7: Question 20. Voted in a City election (in the past 18 to 24 months)
"ad_cure", -- Section 5: Question 8. Scientists will find cure for Alzheimer’s disease soon.
"ad_embarassing", -- Section 5: Question 8. It is embarrassing to have a family member with Alzheimer’s disease.
"ad_plan", -- Section 5: Question 4. Have you made plans for the possibility of you or your family getting Alzheimer’s disease?
"mhs2", -- Section 4: Question 7. Please indicate if you have used each of the following professionals during the past 12 months about a problem with your emotional or mental health.
"oth_way", -- Section 3: Question 21. Where do you get health-related information?
"ppl_ncb_eth", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"ride", -- Section 3: Question 16. For your medical visit, do you need someone who can provide a ride for you?
"public_trans", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis?
"phy_check", -- Section 3: Question 10. Please indicate if you have used each of the following services during the past 12 months.
"hepatitis", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions?
"mobile_devices", -- Section 7: Question 18. Do you use a cellphone, smartphone, or other mobile devices?
"actlimit", -- Section 3: Question 4. Do you need help with daily activities like bathing, dressing, eating, or using the toilet?
"asian_lang_mag", -- Section 7: Question 7. Do you know that public libraries have newspapers, books and magazines in Asian languages?
"contact_city", -- Section 7: Question 20. E-mailed or phoned a City official or staff person
"paper_ncb_eth", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"srmh", -- Section 3: Question 2. How would you rate your mental/emotional health at the present time?
"place_arts_culture", -- Section 7: Question 2. The City of Austin as a place to enjoy arts and culture
"coh3", -- Section 6: Question 6. People in my ethnic community share the same values.
"fs7", -- Section 6: Question 3. We can express our feelings with our family.
"copd", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions?
"ad_concern2", -- Section 5: Question 3. How concerned are you that you may someday have to provide care for someone with Alzheimer’s disease?
"d_nocure", -- Section 4: Question 8. Do you think people with mental problems will never recover?
"eng_inter", -- Section 2: Question 5. How much does your English speaking ability interfere with daily life?
"swl_1", -- Section 4: Question 2. In most ways my life is close to my ideal.
"urgentcare", -- Section 3: Question 10. Please indicate if you have used each of the following services during the past 12 months.
"folkmedicine", -- Section 3: Question 10. Please indicate if you have used each of the following services during the past 12 months. Folk medicine provider (e.g., herbalist, acupuncturist, etc.)
"unemployed", -- Question 9. What is your current employment status? (Check all that apply)
"oth_ncb_eth", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"svc_911", -- Section 7: Question 7. Do you know what 911 service is?
"place_qol", -- Section 7: Question 2. Quality of life in the City of Austin
"unmet_f_need", -- Question 12. Thinking of your household’s total monthly income, would you say that your household is able to make ends meet?
"ad_normalaging", -- Section 5: Question 8. Alzheimer’s disease is a normal process of aging.
"unmet_h_need", -- Section 3: Question 14. Was there a time in the past 12 months when you needed medical care but couldn’t get it?
"d_disclosure", -- Section 4: Question 8. Do you think keeping emotional troubles to oneself is a virtue?
"unmet_d_need", -- Section 3: Question 15. Was there a time in the past 12 months when you needed dental care but couldn’t get it?
"heal_pro", -- Section 3: Question 21. Where do you get health-related information?
"d_insurance", -- Section 3: Question 13. Do you have dental insurance?
"interpretation", -- Section 3: Question 17. For your medical visit, do you need someone who can do interpretation for you?
"prefered_type", -- Section 7: Question 24. What is your most preferred type of communication for City-related information?
"income", -- Question 11. How much was your household income (before tax) for the past year?
"ppl_ncb_gen", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"eng_spk", -- Section 2: Question 4. How well do you speak English?
"friends", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"no_one", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"emp_oth_dscrb", -- Question 9. What is your current employment status? (Check all that apply)
"oth_cb_dscrb", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"info_interest", -- Section 7: Question 21. How interested are you in keeping informed about City events and City government?
"public_meeting", -- Section 7: Question 20. Attended a City hosted public meeting
"full", -- Question 9. What is your current employment status? (Check all that apply)
"concordance", -- Section 3: Question 19. If you could choose, would you prefer to be treated by a doctor of your own ethnic group?
"home_phone", -- Section 7: Question 19. Do you have a home phone line (wired, landline)?
"place_raise_child", -- Section 7: Question 2. The City of Austin as a place to raise children
"personal_car", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis?
"liv_oth_dscrb", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"bro_sis", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"spouse", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"compost", -- Section 7: Question 14. Do you compost?
"coh1", -- Section 6: Question 6. My ethnic community is a close-knit community.
"have_advdir", -- Section 5: Question 10. An advance directive is a type of legal document that designates someone who can make medical decisions in the event that you are unable to do so. Do you have such a document?
"marital", -- Section 1: Question 4. What is your current relationship status?
"nursing_home", -- Section 7: Question 11. Are you willing to use a nursing home in the future?
"id", -- Identification of a single survey
"den_check", -- Section 3: Question 10. Please indicate if you have used each of the following services during the past 12 months.
"council_dist", -- Section 7: Question 7. Do you know which council district you are in?
"council_meeting", -- Section 7: Question 20. Attended a City Council meeting
"housing_cate", -- Section 7: Question 8. What kind of housing do you live in?
"eng_class", -- Section 7: Question 7. Do you know that there are free English learning classes?
"free_pc_wifi", -- Section 7: Question 7: Do you know that public libraries offer free access to computers and WiFi?
"ems_class", -- Section 7: Question 7. Do you know that Emergency Medical Services (EMS) offers a variety of free Injury prevention classes (e.g., child passenger and infant safety education, CPR training, etc.)?
"heard_aarc", -- Section 7: Question 4. Have you heard about the Asian American Resource Center (AARC) on Cameron Road?
"diabetes", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions?
"sb_assist", -- Section 7: Question 7. Do you know that the City offers small business assistance services?
"oth_cb", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"pc_training", -- Section 7: Question 7: Do you know that there are free public computer training programs?
"parti_act_freq", -- Section 7: Question 6. How often do you participate in Asian-specific activities and events in Austin?
"self_full", -- Question 9. What is your current employment status? (Check all that apply)
"fam_mem", -- Section 3: Question 21. Where do you get health-related information?
"place_sml_bus", -- Section 7: Question 2. The City of Austin as a place to build small business
"hs_sat_users", -- Section 3: Question 20. How satisfied are you with the healthcare services you received in the past 12 months?
"fs1", -- Section 6: Question 3. My family members respect one another.
"airport", -- Section 7: Question 3. Austin-Bergstrom International Airport
"close_friend", -- Section 3: Question 21. Where do you get health-related information?
"ad_eduprg", -- Section 5: Question 5. Do you know any educational programs on Alzheimer’s disease?
"mhs1", -- Section 4: Question 7. Please indicate if you have used each of the following professionals during the past 12 months about a problem with your emotional or mental health.
"aus_energy", -- Section 7: Question 3. Electric utility service by Austin Energy
"ad_have", -- Section 5: Question 2. Do any of your family members or friends have Alzheimer’s disease?
"d_concordance", -- Section 4: Question 8. If you use counseling, would you prefer a counselor of your own ethnic group?
"social_health_svcs", -- Section 7: Question 3. Social services/ public health services provided by the City
"d_everrecc", -- Section 4: Question 8. Have you ever received psychological counseling or treatment?
"acquaintances", -- Section 3: Question 21. Where do you get health-related information?
"d_addictive", -- Section 4: Question 8. Do you think antidepressant medicines are addictive?
"citizenship_class", -- Section 7: Question 7. Do you know that public libraries provide free citizenship classes?
"qol", -- Section 4: Question 1. How would you rate your overall quality of life?
"ol_communities", -- Section 3: Question 21. Where do you get health-related information?
"heal_website", -- Section 3: Question 21. Where do you get health-related information?
"scl_ntwking_sites", -- Section 3: Question 21. Where do you get health-related information?
"city_effort", -- Section 7: Question 22. In general, how satisfied are you with City government efforts to keep you informed about City services, issues, events, and programs?
"swl_2", -- Section 4: Question 2. I am satisfied with my life.
"mobile_apps", -- Section 3: Question 21. Where do you get health-related information?
"mhs3", -- Section 4: Question 7. Please indicate if you have used each of the following professionals during the past 12 months about a problem with your emotional or mental health.
"users",
"language", -- Question 3. What is your ethnic origin? (Check all that apply)
"d_weakness", -- Section 4: Question 8. Do you think depression is a sign of personal weakness?
"h_insurance", -- Section 3: Question 12. Are you currently covered by any healthcare insurance?
"place_safety", -- Section 7: Question 2. Safety in the City of Austin
"sns_cb", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"tv_radio_ncb_gen", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"medical_home", -- Section 3: Question 11. Is there a place that you usually go to when you get sick?
"age", -- Section 1: Question 1. What is your age?
"belonging", -- Section 2: Question 9. How much do you feel that you belong to the community of your ethnic origin?
"disabled", -- Question 9. What is your current employment status? (Check all that apply)
"liv_oth", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"place_retire", -- Section 7: Question 2. The City of Austin as a place to retire
"d_disappoint", -- Section 4: Question 8. Do you think if you have depression, your family would be disappointed with you?
"gender", -- Section 1: Question 2. What is your gender?
"place_work", -- Section 7: Question 2. The City of Austin as a place to work
"coh4", -- Section 6: Question 6. People in my ethnic community generally get along with each other.
"ethnicity", -- Section 1: Question 3. What is your ethnic origin? (Check all that apply)
"other_rel", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"coh2", -- Section 6: Question 6. People in my ethnic community are willing to help each other
"hsize", -- Section 1: Question 6. Including yourself, how many people live in your household?
"ad_know", -- Section 5: Question 1. How much do you know about Alzheimer’s disease?
"rel_att4", -- Section 6: Question 4. How often do you attend religious services?
"fs8", -- Section 6: Question 3. My family members like to spend free time with each other.
"fs5", -- Section 6: Question 3. My family members feel loyal to the family.
"d_danger", -- Section 4: Question 8. Do you think people with mental problems are dangerous to others?
"culturalbelif", -- Section 5: Question 11. How much do you agree with the following statement?: “One should avoid speaking about bad things (e.g., disease and death) because it might cause them to happen.”
"n5", -- Section 6: Question 2. How many friends do you feel at ease with that you can talk about private matters?
"ad_avoidance", -- Section 5: Question 8. Social interactions with an Alzheimer’s disease patient should be avoided.
"ad_service", -- Section 5: Question 6. Do you know any local services and programs for Alzheimer’s disease patients and family?
"kidney_prob", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions?
"occupation", -- Question 10. IF YOU ARE EMPLOYED, what kind of work do you do?
"srh", -- Section 3: Question 1. How would you rate your overall health at the present time?
"trans_oth_dscrp", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis?
"rel_oth", -- Section 1: Question 8. What is your religious affiliation?
"asthma", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions?
"d_shame", -- Section 4: Question 8. Do you think having a depressed family member brings a shame to the whole family?
"stroke", -- Section 3: Question 9. Has a doctor ever told you that you had any of the following conditions?
"tv_radio_ncb_eth", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"lib", -- Section 7: Question 3. Libraries
"oth_ncb_gen_dscrb", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"com_prob", -- Section 3: Question 18. Have you had an experience that you could not understand what the doctor/nurse said?
"regexercise", -- Section 3: Question 7. Do you exercise regularly?
"park_rec", -- Section 7: Question 3. Parks and recreational services
"ppl_cb", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"housing_cate_oth", -- Section 7: Question 8. What kind of housing do you live in?
"discrim", -- Section 2: Question 10. Have you ever been treated unfairly because of your race or ethnic origin?
"ad_fate", -- Section 5: Question 8. Alzheimer’s disease is a cause of fate.
"ad_langauge", -- Section 5: Question 7. Do you think your language and/or culture would interfere with your participation in such programs?
"edu", -- Section 1: Question 5. Please circle the highest year of school completed.
"email", -- Section 3: Question 21. Where do you get health-related information?
"ad_concern3", -- Section 5: Question 3. How important do you think it is to plan for the possibility of getting Alzheimer’s disease in the future?
"parent", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"apd_lang", -- Section 7: Question 7. Do you know that Austin Police Department provides services in any language?
"svc_311", -- Section 7: Question 7. Do you know what 311 service is?
"grandparent", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"own_home_oth", -- Section 7: Question 9. Do you (and your family) own your home, rent it, or what?
"bicycling", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis?
"recycle", -- Section 7: Question 13. Do you recycle/reuse in your household?
"walking", -- Section 7: Question 15. Which modes of transportation do you use on a regular basis?
"religion", -- Question 8. What is your religious affiliation?
"tv_radio_cb", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"coh5", -- Section 6: Question 6. People in my ethnic community can be trusted.
"public_safety", -- Section 7: Question 2. Public safety services (i.e. police, fire, and ambulance)
"place_qosvcs", -- Section 7: Question 2. Quality of services provided by the City of Austin
"part", -- Section 1: Question 9. What is your current employment status? (Check all that apply)
"self_part", -- Question 9. What is your current employment status? (Check all that apply)
"website_ncb_eth", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"oth_ncb_gen", -- Section 7: Question 23. Please indicate the types of communication that you rely on to stay informed about the City of Austin.
"children", -- Section 1: Question 7. Who lives with you? (Check all that apply)
"student", -- Question 9. What is your current employment status? (Check all that apply)
"ad_concern1", -- Section 5: Question 3. How concerned are you that YOU may have Alzheimer’s disease someday?
"fs4", -- Section 6: Question 3. We really do trust and confide in each other.
"n3", -- Section 6: Question 1. How many family/relatives do you feel close to such that you could call on them for help?
"ad_nursing", -- Section 5: Question 8. It is not right to place a family member with Alzheimer’s disease in a nursing home.
"heard_advdir" -- Section 5: Question 9. Have you heard about advance directives?
FROM
"datahub-austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z:latest"."final_report_of_the_asian_american_quality_of_life"
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-austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z 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-austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z: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-austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62zCheckout 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-austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z:latestThis will download all the objects for the latest tag of datahub-austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z 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-austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z: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-austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z: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-austintexas-gov/final-report-of-the-asian-american-quality-of-life-hc5t-p62z is just another Postgres schema.