Lesson 1i: Connect via Python

https://factsanddimensions.co.uk
Facts and Dimensions provide 1000s of tables of publicly available stats and reference data, ready to query immediately.

See how to connect to your Facts and Dimensions Azure database using Python

If you get an error with your IP address, this means you need to send us that address so we can whitelist it.

If you get an error regarding Named Pipes or TCP and such, then you need to update your firewall to allow access to Azure. We are based in UK South data centre.

Update firewall as per:
a. See https://docs.microsoft.com/en-us/azure/sql-database/sql-database-control-access and
b. https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connectivity-architectur #azure-sql-database-gateway-ipaddresses.
Our Server is in UK South, so use the IP address for that Region if you want to restrict 1433 access.
c. You need to ensure TCP/IP is enabled in SQL Server Configuration Manager
d. Other useful URLs
i. https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-connect-overview
ii. https://docs.microsoft.com/en-us/sql/relational-databases/sql-server-configuration-manager?view=sql-server-2017

The website I used to help me make the video: https://learn.microsoft.com/en-us/sql/connect/python/pyodbc/step-3-proof-of-concept-connecting-to-sql-using-pyodbc?view=sql-server-ver16