Fetch first 10 hotels from Bronze layer (normalized data)

SELECT * FROM atlas.hotels LIMIT 10

Filter hotels by supplier ID (change supplier value as needed)

SELECT hotel_name, hotel_code, supplier, address_city, address_country
FROM atlas.hotels
WHERE supplier = '7'
LIMIT 20

Hotels in United States, sorted by star rating

SELECT hotel_name, hotel_code, address_city, address_country, star_rating
FROM atlas.hotels
WHERE address_country = 'US'
ORDER BY star_rating DESC
LIMIT 25

Hotels that have description text available

SELECT hotel_name, hotel_code, hotel_description
FROM atlas.hotels
WHERE hotel_description IS NOT NULL
LIMIT 15

View translation enrichments (if table exists)

SELECT record_id, language_code, translation_status, translated_fields
FROM atlas.translations
LIMIT 10

View key facts extractions (if table exists)

SELECT record_id, key_facts, extraction_timestamp
FROM atlas.key_facts
LIMIT 10

Hotels with amenity information

SELECT hotel_name, hotel_code, amenities
FROM atlas.hotels
WHERE amenities IS NOT NULL
LIMIT 10

Most recently ingested hotels

SELECT hotel_name, hotel_code, supplier, ingestion_timestamp
FROM atlas.hotels
ORDER BY ingestion_timestamp DESC
LIMIT 20