Python

How to connect your tukan query to a Python script?

Getting the connection URL

Once you've created your query, head over to the queries module, and click on the export button for the query you wish to connect.

Next, select the Python tab and click the Copy link button to copy the query's "connection string" to your clipboard.

This "connection string" is essentially a pandas read_csv command to import the query to your script as a DataFrame.

---

On you Pyhton script or Jupyter notebook, simply import the following libraries:

import pandas as pd

# --- Paste your "connection string" here.

df = YOUR_CONNECTION_STRING