EBS on RDW
Comprehensive product and instrument reference data for EBS is available on the Reference Data Warehouse in the following tables:
v_product_ebs - all product reference data
v_instrument_ebs - all instrument reference data
Contents
Schemas
Product Schema
Instrument Schema
Sample Queries
Query For ON-SEF Products
SELECT * /*add specific fields or use star for all*/
FROM `/*insert project name */.cmeg_refdata_ebs.v_product_ebs`
WHERE on_sef_ind="Y" and run_date="2023-06-12" /* add query terms and run_date value to limit results */
Query For All eFIX Instruments Using BFIX Fixings
SELECT * /*add specific fields or use star for all*/
FROM `/*insert project name */.cmeg_refdata_ebs.v_instrument_ebs`
WHERE fixing_name LIKE "BFIX%" and run_date="2023-06-12"
How was your Client Systems Wiki Experience? Submit Feedback
Copyright © 2024 CME Group Inc. All rights reserved.