Streamlit

Here is a summary of the tables available in the "bigquery-public-data.thelook_ecommerce" dataset:

1. products:

   • This table contains information about various products available in the e-commerce store.
   • Columns include id, cost, category, name, brand, retail_price, department, sku, and distribution_center_id.

2. events:

   • This table contains programatically generated web events for the e-commerce store.
   • Columns include id, user_id, sequence_number, session_id, created_at, ip_address, city, state, postal_code, browser, traffic_source, uri, and event_type.

3. orders:

   • This table contains programatically generated orders made in the e-commerce store.
   • Columns include order_id, user_id, status, gender, created_at, returned_at, shipped_at, delivered_at, and num_of_item.

4. distribution_centers:

   • This table contains information about distribution centers in the e-commerce store.
   • Columns include id, name, latitude, and longitude.

5. inventory_items:

   • This table contains programatically generated inventory data for the e-commerce store.
   • Columns include id, product_id, created_at, sold_at, cost, product_category, product_name, product_brand, product_retail_price, product_department, product_sku, and product_distribution_center_id.

6. order_items:

   • This table contains programatically generated order items data for the e-commerce store.
   • Columns include id, order_id, user_id, product_id, inventory_item_id, status, created_at, shipped_at, delivered_at, returned_at, and sale_price.

7. users:

   • This table contains programatically generated user data for the e-commerce store.
   • Columns include id, first_name, last_name, email, age, gender, state, street_address, postal_code, city, country, latitude, longitude, traffic_source, and created_at.

These tables contain various information related to products, events, orders, distribution centers, inventory items, order items, and users in the e-commerce store.