ENERGY STAR Certified Enterprise Servers

CREATE TABLE table_1 (
  "energy_star_unique_id" BIGINT,
  "energy_star_partner" VARCHAR,
  "brand_name" VARCHAR,
  "model_name" VARCHAR,
  "model_number" VARCHAR,
  "additional_model_information" VARCHAR,
  "upc" VARCHAR,
  "form_factor" VARCHAR,
  "product_processor_socket_count" VARCHAR,
  "single_server" VARCHAR,
  "storage_heavy_server" VARCHAR,
  "resilient_system" VARCHAR,
  "number_of_nodes_for_multi_node" DOUBLE,
  "error_correcting_code" VARCHAR,
  "error_correcting_code_enabled_in_hardware_as_shipped" VARCHAR,
  "available_expansion_slots" BIGINT,
  "operating_systems_supported" VARCHAR,
  "operating_system_used_for_testing" VARCHAR,
  "power_saving_features_available" VARCHAR,
  "power_saving_features_enabled" VARCHAR,
  "end_user_required_power_saving_features" VARCHAR,
  "other_power_saving_feature_1_description" VARCHAR  -- Other Power Saving Feature 1: Description,
  "other_power_saving_feature_1_enabled_on_shipment" VARCHAR  -- Other Power Saving Feature 1: Enabled On Shipment,
  "other_power_saving_feature_1_end_user_enabling_required" VARCHAR  -- Other Power Saving Feature 1: End-User Enabling Required,
  "other_power_saving_feature_2_description" VARCHAR  -- Other Power Saving Feature 2: Description,
  "other_power_saving_feature_2_enabled_on_shipment" VARCHAR  -- Other Power Saving Feature 2: Enabled On Shipment,
  "other_power_saving_feature_2_end_user_enabling_required" VARCHAR  -- Other Power Saving Feature 2: End-User Enabling Required,
  "other_power_saving_feature_3_description" VARCHAR  -- Other Power Saving Feature 3: Description,
  "other_power_saving_feature_3_enabled_on_shipment" VARCHAR  -- Other Power Saving Feature 3: Enabled On Shipment,
  "other_power_saving_feature_3_end_user_enabling_required" VARCHAR  -- Other Power Saving Feature 3: End-User Enabling Required,
  "apa_1_model_name" VARCHAR  -- APA #1 Model Name,
  "apa_1_model_number" VARCHAR  -- APA #1 Model Number,
  "apa_1_reported_idle_power_watts" DOUBLE  -- APA #1 Reported Idle Power (Watts),
  "apa_2_model_name" VARCHAR  -- APA #2 Model Name,
  "apa_2_model_number" VARCHAR  -- APA #2 Model Number,
  "apa_2_reported_idle_power_watts" DOUBLE  -- APA #2 Reported Idle Power (Watts),
  "apa_3_model_name" VARCHAR  -- APA #3 Model Name,
  "apa_3_model_number" VARCHAR  -- APA #3 Model Number,
  "apa_3_reported_idle_power_watts" DOUBLE  -- APA #3 Reported Idle Power (Watts),
  "processor_power_management_enabled_in_hardware_on_shipment" VARCHAR,
  "processor_power_management_additional_information" VARCHAR,
  "storage_power_management_enabled_in_hardware_on_shipment" VARCHAR,
  "storage_power_management_additional_information" VARCHAR,
  "memory_power_management_enabled_in_hardware_on_shipment" VARCHAR,
  "memory_power_management_additional_information" VARCHAR,
  "i_o_power_management_enabled_in_hardware_on_shipment" VARCHAR,
  "i_o_power_management_additional_information" VARCHAR,
  "processor_dynamic_voltage_scaling_enabled_on_shipment" VARCHAR,
  "processor_dynamic_frequency_scaling_enabled_on_shipment" VARCHAR,
  "processor_dynamic_voltage_scaling_end_user_enabling_required" VARCHAR,
  "processor_dynamic_frequency_scaling_end_user_enabling_required" VARCHAR,
  "processor_or_core_reduced_power_states_enabled_on_shipment" VARCHAR,
  "processor_or_core_reduced_power_states_enabling_required" VARCHAR,
  "power_capping_enabled_on_shipment" VARCHAR,
  "power_capping_end_user_enabling_required" VARCHAR,
  "variable_speed_fan_control_enabled_on_shipment" VARCHAR,
  "variable_speed_fan_control_end_user_enabling_required" VARCHAR,
  "low_power_memory_states_enabled_on_shipment" VARCHAR,
  "low_power_memory_states_end_user_enabling_required" VARCHAR,
  "low_power_i_o_states_enabled_on_shipment" VARCHAR,
  "low_power_i_o_states_end_user_enabling_required" VARCHAR,
  "liquid_cooling_capability_enabled_on_shipment" VARCHAR,
  "liquid_cooling_capability_end_user_enabling_required" VARCHAR,
  "available_dimm_slots" BIGINT,
  "maximum_memory_capacity_gb" DOUBLE  -- Maximum Memory Capacity (GB),
  "maximum_number_blade_slots" DOUBLE,
  "sert_version" VARCHAR,
  "sert_version_other" VARCHAR,
  "model_number_or_config_id_for_low_end_performance_configuration" VARCHAR,
  "model_number_or_config_id_for_typical_or_single_configuration" VARCHAR,
  "model_number_or_config_id_for_high_end_performance_con_0c3e1828" VARCHAR  -- Model Number Or Config ID For High-end Performance Configuration,
  "installed_processors_for_low_end_performance_configuration" DOUBLE,
  "installed_processors_for_typical_or_single_configuration" BIGINT,
  "installed_processors_for_high_end_performance_configuration" DOUBLE,
  "cores_per_processor_low_end_performance_configuration" DOUBLE,
  "cores_per_processor_typical_or_single_configuration" BIGINT,
  "cores_per_processor_high_end_performance_configuration" DOUBLE,
  "number_of_threads_for_low_end_performance_configuration" DOUBLE,
  "number_of_threads_for_typical_or_single_configuration" BIGINT,
  "number_of_threads_for_high_end_performance_configuration" DOUBLE,
  "processor_brand_low_end_performance_configuration" VARCHAR,
  "processor_brand_typical_or_single_configuration" VARCHAR,
  "processor_brand_high_end_performance_configuration" VARCHAR,
  "processor_model_name_low_end_performance_configuration" VARCHAR,
  "processor_model_name_typical_or_single_configuration" VARCHAR,
  "processor_model_name_high_end_performance_configuration" VARCHAR,
  "processor_speed_for_low_end_performance_configuration_ghz" DOUBLE  -- Processor Speed For Low-end Performance Configuration (GHz),
  "processor_speed_for_typical_or_single_configuration_ghz" DOUBLE  -- Processor Speed For Typical Or Single Configuration (GHz),
  "processor_speed_for_high_end_performance_configuration_ghz" DOUBLE  -- Processor Speed For High-end Performance Configuration (GHz),
  "num_of_ddr_channels_for_low_end_performance_configuration" DOUBLE  -- Num. Of DDR Channels For Low-end Performance Configuration,
  "num_of_ddr_channels_for_typical_or_single_configuration" BIGINT  -- Num. Of DDR Channels For Typical Or Single Configuration,
  "num_of_ddr_channels_for_high_end_performance_configuration" DOUBLE  -- Num. Of DDR Channels For High-end Performance Configuration,
  "memory_manufacturer_for_low_end_performance_configuration" VARCHAR,
  "memory_manufacturer_for_typical_or_single_configuration" VARCHAR,
  "memory_manufacturer_for_high_end_performance_configuration" VARCHAR,
  "memory_model_number_low_end_performance_configuration" VARCHAR,
  "memory_model_number_typical_or_single_configuration" VARCHAR,
  "memory_model_number_high_end_performance_configuration" VARCHAR,
  "memory_speed_low_end_performance_configuration_ghz" DOUBLE  -- Memory Speed Low-end Performance Configuration (GHz),
  "memory_speed_typical_or_single_configuration_ghz" DOUBLE  -- Memory Speed Typical Or Single Configuration (GHz)
);