Tag: postgresql
-
Migrating data from SQL Server to PostgreSQL
Prerequisites Steps Python Code for testing connection Sample content of .env file Installed python packages Use requirements.txt file to install necessary packages. Content of the file listed below:
-
Data layer security and permission in a multi-tenancy data warehouse
In this article we will discuss various approaches for achieving data isolation or data layer security in a multi-tenancy data warehouse. I will refer multi-tenancy data warehouse as an architecture where an instance of OLAP database is shared by many customers. In a multi-tenancy platform data isolation (row level data access) is usually performed in…
-
Read and write data using SQLAlchemy and Pandas dataframe
SQLAlchemy has made it easy to read and write data from databases. I am using Google Colab and free databases to store and manipulate data. In this article, I will read data from MySQL database and save the result to a PostgreSQL using Pandas dataframe to_sql method. Steps Prerequisites Needed following Python packages – Google…
-
Install PostgreSQL on AWS CloudShell
PostgreSQL on AWS CloudShell, please use the the command below: