Skip to content

Instantly share code, notes, and snippets.

@mkhorasani

mkhorasani/data_warehouse_engine

Last active December 26, 2022 23:44
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mkhorasani/2eaab72eb2d7002d73a990dc78172714 to your computer and use it in GitHub Desktop.
Save mkhorasani/2eaab72eb2d7002d73a990dc78172714 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
data_warehouse_engine
engine = create_engine("postgresql://<username>:<password>@localhost:5432/records_db")
engine_dataset = create_engine("postgresql://<username>:<password>@localhost:5432/datasets_db")
engine.execute("CREATE TABLE IF NOT EXISTS records (name text PRIMARY KEY, details text[])")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment