Copyable SQL

SQL Import Script

-- 1. Import Customers
CREATE TABLE olist_customers AS 
SELECT * FROM read_csv_auto('olist_customers_dataset.csv');

-- 2. Import Sellers
CREATE TABLE olist_sellers AS 
SELECT * FROM read_csv_auto('olist_sellers_dataset.csv');

-- 3. Import Geolocation
CREATE TABLE olist_geolocation AS 
SELECT * FROM read_csv_auto('olist_geolocation_dataset.csv');

-- 4. Import Products
CREATE TABLE olist_products AS 
SELECT * FROM read_csv_auto('olist_products_dataset.csv');

-- 5. Import Product Category Translation
CREATE TABLE olist_product_category_translation AS 
SELECT * FROM read_csv_auto('product_category_name_translation.csv');

-- 6. Import Orders
CREATE TABLE olist_orders AS 
SELECT * FROM read_csv_auto('olist_orders_dataset.csv');

-- 7. Import Order Items
CREATE TABLE olist_order_items AS 
SELECT * FROM read_csv_auto('olist_order_items_dataset.csv');

-- 8. Import Order Payments
CREATE TABLE olist_order_payments AS 
SELECT * FROM read_csv_auto('olist_order_payments_dataset.csv');

-- 9. Import Order Reviews
CREATE TABLE olist_order_reviews AS 
SELECT * FROM read_csv_auto('olist_order_reviews_dataset.csv');

SQL Import Script

CustomerID