mirror of
https://github.com/open-metadata/OpenMetadata.git
synced 2025-07-05 08:05:28 +00:00
25 lines
2.1 KiB
Plaintext
25 lines
2.1 KiB
Plaintext
query,cost,user
|
|
"select * from shopify.raw_product_catalog",10,admin
|
|
"select * from shopify.raw_product_catalog",12,admin
|
|
"select comments, products from shopify.raw_product_catalog",2,
|
|
"select comments, products from shopify.raw_product_catalog",3,
|
|
"select comments, products from shopify.raw_product_catalog",9,
|
|
"select cust.customer_id, fact_order.order_id from dim_customer cust join fact_order on cust.customer_id = fact_order.customer_id",0.222,
|
|
"select sale.sale_id, cust.customer_id, fact_order.order_ir from shopify.fact_sale sale join dim_customer cust on sale.customer_id = cust.customer_id join fact_order on fact_order.order_id = sale.order_id",0.234,
|
|
"select sale.sale_id, cust.customer_id, fact_order.order_ir from shopify.fact_sale sale join dim_customer cust on sale.customer_id = cust.customer_id join fact_order on fact_order.order_id = sale.order_id",0.5,
|
|
"select sale.sale_id, cust.customer_id, fact_order.order_ir from shopify.fact_sale sale join dim_customer cust on sale.customer_id = cust.customer_id join fact_order on fact_order.order_id = sale.order_id",0.65,
|
|
"select case when net_sales > 100 then 'high' else 'low' end as map_sales from shopify.fact_sale",2,
|
|
"select ROW_NUMBER() OVER (PARTITION BY sale_id, customer_id) AS sale_row from shopify.fact_sale",5,
|
|
"select * from shopify.raw_customer",19,admin
|
|
"select * from shopify.raw_customer",19,admin
|
|
"select * from shopify.raw_customer",18,admin
|
|
"select * from shopify.raw_customer",17,admin
|
|
"select * from shopify.raw_customer",16,admin
|
|
"select * from shopify.raw_customer",20,admin
|
|
"select * from shopify.raw_customer",21,admin
|
|
"select * from shopify.raw_customer",22,admin
|
|
"select * from shopify.raw_customer",15,admin
|
|
"select * from shopify.raw_customer",12,admin
|
|
"create table shopify.dim_address_clean as select address_id, shop_id, first_name, last_name, address1 as address, company, city, region, zip, country, phone from shopify.dim_address",0.5,admin
|
|
"create table shopify.dim_address_clean as select address_id, shop_id, first_name, last_name, address1 as address, company, city, region, zip, country, phone from shopify.dim_address",0.5,admin
|
|
"select * from shopify.raw_customer limit 1",12,admin |