Creating a test and production environment
In this chapter, we will return to using PostgreSQL for both the extraction and loading of data. The data pipeline will require a test and production environment, each of which will have a staging and a warehouse table. To create the databases and tables, you will use PgAdmin4.
Creating the databases
- Browse to
http://localhostw/pgadmin4/l, enter your username and password, and then click the Login button. Once logged in, expand the server icon in the left panel.
- To create the databases, right-click on the databases icon and select Create | Database. Name the database
- Next, you will need to add the tables. To create the staging table, right-click on Tables | Create | Table. On the General tab, name the table
staging. Then, select the Columns tab. Using the plus sign, create the fields shown in the following screenshot: