# HiveSQL for Python developers

Use the following code to connect to HiveSQL using Python:

```
import pypyodbc
connection = pypyodbc.connect('Driver={ODBC Driver 13 for SQL Server};'
                              'Server=vip.hivesql.io;'
                              'Database=DBHive;'
                              'uid=[your_hivesql_account];'
                              'pwd=[your_hivesql_password]')
cursor = connection.cursor() 
SQLCommand = ("YOUR SQL QUERY”)
cursor.execute(SQLCommand)
# do whatever you want with the retrieved data
connection.close()
```

Remember you need to have ODBC drivers installed on your computer.

**How to install the Microsoft ODBC Driver for SQL Server on Linux and macOS**

On Debian 9

```
sudo curl https://ift.tt/2OlWDWn > /etc/apt/sources.list.d/mssql-release.list
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install msodbcsql17
```

*Optional for bcp and sqlcmd*

```
sudo ACCEPT_EULA=Y apt-get install mssql-tools
echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ >> ~/.bash_profile
echo ‘export PATH=”$PATH:/opt/mssql-tools/bin”‘ >> ~/.bashrc
source ~/.bashrc
```

*Optional for unixODBC development headers*

```
sudo apt-get install unixodbc-dev
```

For more details on how to install Microsoft SQL ODBC drivers, you can read [this post](https://steemit.com/utopian-io/@geekgirl/making-sql-queries-to-steemsql-com-with-python-scripts-on-macos) published by @geekgirl