Create Scripts

create.sql

--postgresql
CREATE TABLE transaction (
	transaction_id serial PRIMARY KEY,
    store_name VARCHAR ( 100 ),
	transaction_date TIMESTAMP,
	price VARCHAR ( 50 ),
	last_updated TIMESTAMP
);

--bigquery
CREATE OR REPLACE TABLE reporting.transaction_model (
	transaction_id STRING,
    store_name STRING,
	transaction_date TIMESTAMP,
	price STRING,
	last_updated TIMESTAMP
);