Skip to content

Instantly share code, notes, and snippets.

@bsullins
Created July 18, 2013 17:25
Show Gist options
  • Save bsullins/6031191 to your computer and use it in GitHub Desktop.
Save bsullins/6031191 to your computer and use it in GitHub Desktop.
DDL for Tableau Superstore 1B row table
create table numbers (
num int
);
create table superstore_orders (
RowID integer
, OrderID integer
, OrderDate varchar(50)
, OrderPriority varchar(50)
, OrderQuantity integer
, Sales decimal(8,2)
, Discount decimal(8,2)
, ShipMode varchar(50)
, Profit decimal(8,2)
, UnitPrice decimal(8,2)
, ShippingCost decimal(8,2)
, CustomerName varchar(200)
, City varchar(200)
, ZipCode varchar(50)
, State varchar(200)
, Region varchar(50)
, CustomerSegment varchar(200)
, ProductCategory varchar(200)
, ProductSubCategory varchar(200)
, ProductName varchar(500)
, ProductContainer varchar(200)
, ProductBaseMargin decimal(8,2)
, ShipDate varchar(50)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment