Can I write a data mart back to an on-prem server?

Once I combine data sources on Panoply, can I write a table back to an on-prem server on a scheduled basis?

Hi there :slight_smile:

We do not have a solution for writing from Panoply to an on-prem server in the platform, but of course, there are solutions for this.

  1. Third-Party ETL Provider - You can use the service of a third party ETL provider to move the data from Panoply to your on-prem server, you can search Google for "ETL from Redshift to ". Panoply is based on Redshift so anything that can do ETL from Redshift can also do ETL from Panoply.
  2. Code it yourself - Pulling data from Panoply with Python is super easy. You can connect to Panoply with the psycopg2 Python library. After you pull the data you can write it to your server with Python. Connecting and running a query with Python example:
import psycopg2

host = 'db.panoply.io'
dbname = 'XXX'
user = 'XXX'
password = 'XXX'
query = 'SELECT * FROM "<schema>"."<table>"'

conn = psycopg2.connect(dbname=dbname,
                        host=host,
                        user=user,
                        password=password)
cursor = conn.cursor()
cursor.execute(query)

results = cursor.fetchall()

I hope this helps,
Gal

1 Like