The recommended way of installation is through the dev-containvers VS Code extension.
- Run the containers.
- Create the data folder and add the .csv data files.
- Open up the docker database container.
(This step might be automated, but I was limited on time.)
Find the container ID by running the following command:
docker ps
Paster the ID here and run the following command:
docker exec -it <ID> /bin/bash
Inside container:
/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'YourStrong!Passw0rd'
1> CREATE DATABASE property_db;
2> GO
- Populate the databse by running the analyze.ipynb notebook. It might take up to 30 minutes. I wasn't concerned much, since I only had to do it once.