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 energy_star_certified_data_center_storage_block_io table in this repository, by referencing it like:
"energystar-gov/energy-star-certified-data-center-storage-block-io-3uec-2gqf:latest"."energy_star_certified_data_center_storage_block_io"or in a full query, like:
SELECT
":id", -- Socrata column ID
"workload_optimization_type", -- A configuration provided by the manufacturer may be optimized for the following workload types: transaction, streaming, or capacity. Transaction is a workload type optimized for random I/O usage measured in I/O per second per watt. Streaming is a workload type optimized primarily for sequential I/O usage, measured in MiB per second per watt. Capacity is a workload type optimized for maximum storage as measured by GB (Raw Capacity) per watt.
"trans_model_number_or_config_id", -- A distinguishing identifier, usually alphanumeric, assigned to the model or configuration by the manufacturer or private labeler. Trans indicates that this information is for the Transaction Workload Optimization Type.
"trans_devices_used_for_cache", -- The devices used for cache are identified here. This can be DRAM, SSD, or Other device.
"stream_device_1_optimal_point_seq_read_wrkld_test_mibps_w", -- The sequential read measurement for storage device 1 optimal point in MiB Per Second (MiBPS) per watt. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"trans_psu_manufacturer_name", -- The manufacturer of the installed PSU(s). If there is more than one power supply, each power supply's manufacturer name will be separated by a semicolon.
"stream_storage_device_2_rated_speed_rpm", -- The rated speed of storage device 2 in RPM. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"stream_storage_device_2_form_factor", -- The form factor of storage device 2 is either 2.5 inch, 3.5 inch, or Other. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"trans_psu_model_name", -- An identifier assigned by the manufacturer or private labeler to the PSU(s) for sales and marketing purposes. If there is more than one power supply, each power supply's model name will be separated by a semicolon.
"stream_total_amount_of_cache_gb", -- The total amount of cache available in GB. Cache is temporary storage used to transparently store transitory data and which is not directly addressable by end-user applications. Primarily used for expediting access to or from (typically) slower devices.
"trans_psus_80plus_certification", -- The 80PLUS certification level achieved by the PSU(s) installed. If there is more than one power supply, each power supply's certification level will be separated by a semicolon.
"trans_total_amount_of_cache_gb", -- The total amount of cache available in GB. Cache is temporary storage used to transparently store transitory data and which is not directly addressable by end-user applications. Primarily used for expediting access to or from (typically) slower devices.
"stream_physical_or_modeled_data_device_1_optimal_point", -- The data for the storage device 1 optimal point is obtained by physically testing the system or through the use of modeled data. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"stream_device_2_optimal_point_seq_write_wrkld_test_mibps_w", -- The sequential write measurement for storage device 2 optimal point in MiB Per Second (MiBPS) per watt. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"stream_device_2_optimal_point_ready_idle_wrkld_test_gb_w", -- The ready idle measurement for storage device 2 optimal point in GB per watt. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"stream_auto_tiering_enabled_optimal_point", -- If automated storage tiering (auto-tiering) was enabled during testing of the highest predicted deployed device(s) optimal point.
"trans_device_1_optimal_point_random_read_wrkld_test_iops_w", -- The random read measurement for storage device 1 optimal point in I/O Per Second (IOPS) per watt. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"trans_optimal_point_hot_band_workload_test_iops_w", -- The hot band measurement for the highest predicted deployed storage device optimal point in I/O Per Second (IOPS) per watt.
"trans_num_of_controllers_in_optimal_point", -- The total number of controllers installed during testing of the highest predicted deployed device(s) optimal point.
"stream_devices_used_for_cache", -- The devices used for cache are identified here. This can be DRAM, SSD, or Other device.
"automated_storage_tiering_enabled_in_hardware_on_shipment", -- If Intelligent Power Distribution Unit (iPDU) is enabled in hardware on shipment.
"date_available_on_market", -- The date that the model is available for purchase.
"stream_optimal_point_ready_idle_workload_test_gb_w", -- The ready idle measurement for the highest predicted deployed storage device optimal point in GB per watt.
"trans_storage_device_2_type", -- The type of storage device can be either a Hard Disk Drive (HDD) or a Solid State Drive (SSD). Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"stream_total_num_installed_storage_devices_optimal_point", -- The total number of storage devices installed during testing of the highest predicted deployed device(s) optimal point.
"stream_device_1_optimal_point_ready_idle_wrkld_test_gb_w", -- The ready idle measurement for storage device 1 optimal point in GB per watt. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"stream_other_devices_used_for_cache", -- If Other was chosen for Trans Device Used for Cache, the type of Other device is identified here.
"software_operating_environment_name", -- Software operating environment/system name supported by storage configuration(s).
"upc", -- UPC codes provided by partners for ENERGY STAR certified products. The brand, model name and model number continue to serve as the identifiers used to establish certification. The UPC code data below is intended to aid in identification of ENERGY STAR models. UPC code data is not provided for all certified models.
"stream_physical_or_modeled_data_device_2_optimal_point", -- The data for the storage device 2 optimal point is obtained by physically testing the system or through the use of modeled data. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"stream_psu_model_number", -- A distinguishing identifier, usually alphanumeric, assigned to the PSU(s) by the manufacturer or private labeler. If there is more than one power supply, each power supply's model number will be separated by a semicolon.
"stream_storage_device_1_type", -- The type of storage device can be either a Hard Disk Drive (HDD) or a Solid State Drive (SSD). Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"trans_device_1_optimal_point_ready_idle_wrkld_test_gb_w", -- The ready idle measurement for storage device 1 optimal point in GB per watt. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"trans_device_1_optimal_point_random_write_wrkld_test_iops_w", -- The random write measurement for storage device 1 optimal point in I/O Per Second (IOPS) per watt. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"trans_optimal_point_random_write_workload_test_iops_w", -- The random write measurement for the highest predicted deployed storage device optimal point in IOPS per watt.
"trans_psu_model_number", -- A distinguishing identifier, usually alphanumeric, assigned to the PSU(s) by the manufacturer or private labeler. If there is more than one power supply, each power supply's model number will be separated by a semicolon.
"trans_power_supply_unit_psu_type", -- The type(s) of power supply unit(s) installed. A Power Supply Unit (PSU) is a device that converts ac or dc input power to one or more dc power outputs for the purpose of powering a storage product. A storage PSU must be self-contained and physically separable from the system and must connect to the system via a removable or hard-wired electrical connection. If there is more than one power supply, each power supply's type will be separated by a semicolon.
"length_of_rolling_average_for_inlet_air_temperature_s", -- If configuration(s) is/are capable of calculating an inlet air temperature, the length of the rolling average is provided here.
"storage_controller_model_name", -- An identifier assigned by the manufacturer or private labeler to the storage controller or family/series of storage controllers for sales and marketing purposes.
"model_number", -- A distinguishing identifier, usually alphanumeric, assigned to a product by the manufacturer or private labeler.
"brand_name", -- An identifier assigned by the manufacturer or private labeler to a product or family/series of products for sales and marketing purposes.
"trans_num_redundant_controllers_optimal_point", -- The total number of redundant controllers installed during testing of the highest predicted deployed device(s) optimal point.
"stream_device_2_optimal_point_seq_read_wrkld_test_mibps_w", -- The sequential read measurement for storage device 2 optimal point in MiB Per Second (MiBPS) per watt. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"trans_storage_device_2_raw_capacity_gb", -- The raw capacity of storage device 2 in GB. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"automated_storage_tiering_capable", -- Automated Storage Tiering is the automatic movement of data between different types of storage devices. Tiering may occur within a single storage product or may span multiple storage products. For the purposes of ENERGY STAR certification, only tiering within a single storage product is applicable.
"stream_psu_model_name", -- An identifier assigned by the manufacturer or private labeler to the PSU(s) for sales and marketing purposes. If there is more than one power supply, each power supply's model name will be separated by a semicolon.
"trans_physical_or_modeled_data_device_1_optimal_point", -- The data for the storage device 1 optimal point is obtained by physically testing the system or through the use of modeled data. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"stream_ratio_devices_mixed_optimal_point", -- The ratio of installed storage devices with addressable storage (not used for cache) during testing of the highest predicted deployed device(s) optimal point. If there is more than one device in the highest predicted deployed storage device, the ratio of each storage device is separated by a semicolon.
"stream_num_of_controllers_in_optimal_point", -- The total number of controllers installed during testing of the highest predicted deployed device(s) optimal point.
"trans_storage_device_2_rated_speed_rpm", -- The rated speed of storage device 2 in RPM. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"stream_storage_device_1_rated_speed_rpm", -- The rated speed of storage device 1 in RPM. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"active_or_passive_cooling_enabled_in_hardware_on_shipment", -- If Active Cooling, Passive Cooling, or both is enabled in hardware on shipment.
"storage_controller_advanced_data_recovery_type", -- Advanced Data Recovery Capability is a collective term used in this specification to refer to error detection and correction features such as RAID, mirroring / grid technology, or other comparable advanced error detection and recovery systems.
"stream_storage_device_1_form_factor", -- The form factor of storage device 1 is either 2.5 inch, 3.5 inch, or Other. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"trans_total_num_installed_storage_devices_optimal_point", -- The total number of storage devices installed during testing of the highest predicted deployed device(s) optimal point.
"stream_psu_rated_output_w", -- The Rated Output per installed PSU in watts. If there is more than one power supply, each power supply's rated output will be separated by a semicolon.
"trans_ratio_devices_mixed_optimal_point", -- The ratio of installed storage devices with addressable storage (not used for cache) during testing of the highest predicted deployed device(s) optimal point. If there is more than one device in the highest predicted deployed storage device, the ratio of each storage device is separated by a semicolon.
"energy_star_partner", -- An organization that signed a Partnership Agreement with EPA to manufacture or private label ENERGY STAR qualified products.
"trans_installed_solid_state_devices_in_optimal_point", -- The total number of Solid State Devices installed during testing of the highest predicted deployed device(s) optimal point. If there is more than one device in the highest predicted deployed storage device, each device's number of solid state drives is separated by a semicolon.
"trans_storage_device_1_type", -- The type of storage device can be either a Hard Disk Drive (HDD) or a Solid State Drive (SSD). Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"trans_num_devices_storage_device_2_optimal_point", -- The number of devices installed in storage device 2 optimal point. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"trans_storage_device_2_form_factor", -- The form factor of storage device 2 is either 2.5 inch, 3.5 inch, or Other. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"stream_model_number_or_config_id", -- A distinguishing identifier, usually alphanumeric, assigned to the model or configuration by the manufacturer or private labeler. Stream indicates that this information is for the Streaming Workload Optimization Type.
"trans_device_2_optimal_point_random_read_wrkld_test_iops_w", -- The random read measurement for storage device 2 optimal point in I/O Per Second (IOPS) per watt. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"stream_psu_manufacturer_name", -- The manufacturer of the installed PSU(s). If there is more than one power supply, each power supply's manufacturer name will be separated by a semicolon.
"power_and_temperature_reporting_additional_information", -- If additional Power and Temperature Reporting information is available, it is provided here.
"stream_optimal_point_seq_read_workload_test_mibps_w", -- The sequential read measurement for the highest predicted deployed storage device optimal point in MiB Per Second (MiBPS) per watt.
"stream_number_of_redundant_psus_optimal_point", -- The total number of redundant PSUs installed during testing of the highest predicted deployed device(s) optimal point.
"trans_psu_rated_output_w", -- The Rated Output per installed PSU in watts. If there is more than one power supply, each power supply's rated output will be separated by a semicolon.
"stream_device_1_optimal_point_seq_write_wrkld_test_mibps_w", -- The sequential write measurement for storage device 1 optimal point in MiB Per Second (MiBPS) per watt. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"trans_storage_device_1_rated_speed_rpm", -- The rated speed of storage device 1 in RPM. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"stream_installed_rotational_devices_in_optimal_point", -- The total number of rotational devices installed during testing of the highest predicted deployed device(s) optimal point. If there is more than one device in the highest predicted deployed storage device, each device's number of rotational drives is separated by a semicolon.
"trans_storage_device_1_raw_capacity_gb", -- The raw capacity of storage device 1 in GB. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"energy_star_model_identifier", -- A unique string of characters assigned by certification bodies (CBs) to identify a model or set of models with the same performance characteristics. This identifier should remain the same for a model even if it is recertified to a new version of an ENERGY STAR specification. This string of characters is determined by CBs and is not the ENERGY STAR Unique ID assigned by EPA.
"trans_device_2_optimal_point_ready_idle_wrkld_test_gb_w", -- The ready idle measurement for storage device 2 optimal point in GB per watt. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"model_name", -- An identifier assigned by the manufacturer or private labeler to a product or family/series of products for sales and marketing purposes.
"trans_other_devices_used_for_cache", -- If Other was chosen for Trans Device Used for Cache, the type of Other device is identified here.
"stream_num_redundant_controllers_optimal_point", -- The total number of redundant controllers installed during testing of the highest predicted deployed device(s) optimal point.
"trans_automated_tiering_enabled_during_testing_device_1", -- If automated storage tiering (auto-tiering) was enabled during testing of the storage device 1. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"stream_optimal_point_seq_write_workload_test_mibps_w", -- The sequential write measurement for the highest predicted deployed storage device optimal point in MiB Per Second (MiBPS) per watt.
"stream_storage_device_2_type", -- The type of storage device can be either a Hard Disk Drive (HDD) or a Solid State Drive (SSD). Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"stream_automated_tiering_enabled_during_testing_device_1", -- If automated storage tiering (auto-tiering) was enabled during testing of the storage device 1. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"stream_psus_80plus_certification", -- The 80PLUS certification level achieved by the PSU(s) installed. If there is more than one power supply, each power supply's certification level will be separated by a semicolon.
"stream_num_devices_storage_device_2_optimal_point", -- The number of devices installed in storage device 2 optimal point. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"trans_number_of_redundant_psus_optimal_point", -- The total number of redundant PSUs installed during testing of the highest predicted deployed device(s) optimal point.
"stream_storage_device_2_raw_capacity_gb", -- The raw capacity of storage device 2 in GB. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"trans_device_1_optimal_point_hot_band_wrkld_test_iops_w", -- The hot band measurement for storage device 1 optimal point in I/O Per Second (IOPS) per watt. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"pd_id", -- The ENERGY STAR Unique ID (ESUID) is a string of seven numbers EPA assigns to an ENERGY STAR model or set of models with unique performance characteristics. This ESUID is unique to both the model and product specification version and is assigned by EPA upon receipt of certification information from the certification body. Each row within the product list will have a unique ESUID. Developers may wish to use this ESUID to track information on certified models in their information systems.
"additional_model_information", -- An identifier assigned by the manufacturer or private labeler to a product or family/series of products for sales and marketing purposes. This column includes alternative means to identify the model/model family (e.g., additional model names, additional model numbers, retailer SKUs, product descriptions).
"trans_storage_device_1_form_factor", -- The form factor of storage device 1 is either 2.5 inch, 3.5 inch, or Other. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"snia_online_taxonomy_category", -- The SNIA Taxonomy is a categorization scheme for use in segmenting the data center storage market by end-use application and key product characteristics. The three categories eligible for ENERGY STAR certification are Online 2, Online 3, and Online 4.
"trans_optimal_point_ready_idle_workload_test_gb_w", -- The ready idle measurement for the highest predicted deployed storage device optimal point in GB per watt.
"storage_controller_implementation", -- A storage controller can be implemented in two different ways. Scale-up storage is a storage product comprised of a discreet storage controller (with or without redundancy), which has a full view of all the storage devices in the storage product. Incremental storage capacity is added by the addition of storage devices under the control of the existing storage controller. While Scale-out storage is a storage product capable of being comprised of two or more discreet storage controllers (with or without redundancy), combined with an overall integration or aggregation function resulting in a single storage product view for attached servers. Each discreet storage controller often has a partial view to a partition of the overall system's storage devices, but this is not a fixed requirement. Incremental storage capacity is added by the addition of storage devices under the control of the existing storage controller(s) and/or addition of additional storage devices along with additional controller(s).
"trans_number_of_psus_optimal_point", -- The total number of PSUs installed during testing of the highest predicted deployed device(s) optimal point.
"storage_controller_manufacturer_name", -- The manufacturer of the installed storage controller(s).
"trans_installed_rotational_devices_in_optimal_point", -- The total number of rotational devices installed during testing of the highest predicted deployed device(s) optimal point. If there is more than one device in the highest predicted deployed storage device, each device's number of rotational drives is separated by a semicolon.
"trans_optimal_point_random_read_workload_test_iops_w", -- The random read measurement for the highest predicted deployed storage device optimal point in IOPS per watt.
"trans_physical_or_modeled_data_device_2_optimal_point", -- The data for the storage device 2 optimal point is obtained by physically testing the system or through the use of modeled data. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"storage_controller_model_number", -- A distinguishing identifier, usually alphanumeric, assigned to the storage controller(s) by the manufacturer or private labeler.
"trans_device_2_optimal_point_random_write_wrkld_test_iops_w", -- The random write measurement for storage device 2 optimal point in I/O Per Second (IOPS) per watt. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"stream_power_supply_unit_psu_type", -- The type(s) of power supply unit(s) installed. A Power Supply Unit (PSU) is a device that converts ac or dc input power to one or more dc power outputs for the purpose of powering a storage product. A storage PSU must be self-contained and physically separable from the system and must connect to the system via a removable or hard-wired electrical connection. If there is more than one power supply, each power supply's type will be separated by a semicolon.
"stream_storage_device_1_raw_capacity_gb", -- The raw capacity of storage device 1 in GB. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"stream_automated_tiering_enabled_during_testing_device_2", -- If automated storage tiering (auto-tiering) was enabled during testing of the storage device 2. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"date_qualified", -- The date on which the product was confirmed to meet the ENERGY STAR specification.
"stream_num_devices_storage_device_1_optimal_point", -- The number of devices installed in storage device 1 optimal point. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"length_of_rolling_average_for_input_power_s", -- If configuration(s) is/are capable of calculating an input power rolling average, the length of the rolling average is provided here.
"trans_automated_tiering_enabled_during_testing_device_2", -- If automated storage tiering (auto-tiering) was enabled during testing of the storage device 2. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"trans_device_2_optimal_point_hot_band_wrkld_test_iops_w", -- The hot band measurement for storage device 2 optimal point in I/O Per Second (IOPS) per watt. Storage device 2 is the second device in addition to the highest predicted deployed storage device.
"trans_num_devices_storage_device_1_optimal_point", -- The number of devices installed in storage device 1 optimal point. Storage device 1 is the first device in addition to the highest predicted deployed storage device.
"stream_installed_solid_state_devices_in_optimal_point", -- The total number of Solid State Devices installed during testing of the highest predicted deployed device(s) optimal point. If there is more than one device in the highest predicted deployed storage device, each device's number of solid state drives is separated by a semicolon.
"markets", -- Includes products sold in the U.S. and/or Canada and other ENERGY STAR partner countries.
"stream_number_of_psus_optimal_point", -- The total number of PSUs installed during testing of the highest predicted deployed device(s) optimal point.
"capacity_optimizing_methods_coms", -- Capacity Optimizing Methods (COMs) are the reduction of data stored on storage devices through a combination of hardware and / or software. Common COMs include thin provisioning, data deduplication, compression, and delta snapshots.
"trans_auto_tiering_enabled_optimal_point", -- If automated storage tiering (auto-tiering) was enabled during testing of the highest predicted deployed device(s) optimal point.
"software_operating_environment_version" -- Software operating environment/system version supported by storage configuration(s).
FROM
"energystar-gov/energy-star-certified-data-center-storage-block-io-3uec-2gqf:latest"."energy_star_certified_data_center_storage_block_io"
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 energystar-gov/energy-star-certified-data-center-storage-block-io-3uec-2gqf 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 energystar-gov/energy-star-certified-data-center-storage-block-io-3uec-2gqf: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 energystar-gov/energy-star-certified-data-center-storage-block-io-3uec-2gqfCheckout 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 energystar-gov/energy-star-certified-data-center-storage-block-io-3uec-2gqf:latestThis will download all the objects for the latest tag of energystar-gov/energy-star-certified-data-center-storage-block-io-3uec-2gqf 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 energystar-gov/energy-star-certified-data-center-storage-block-io-3uec-2gqf: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 energystar-gov/energy-star-certified-data-center-storage-block-io-3uec-2gqf: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, energystar-gov/energy-star-certified-data-center-storage-block-io-3uec-2gqf is just another Postgres schema.