This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
on - edited on by
DRay
Introduction
With the Python script below and the Window Scheduler, you can automate the download of csv files based on queries of the SQL API to the elasticube. This type of process comes in handy when a user needs to download information regularly to be consumed by other processes.
The script takes takes care of the authentication process and keeps the definition of the cube, query, and response file.
Prerequisites
1. install python 3.4 (download here)
2. python c++ compiler (download here)
3. python dependencies
- jwt (pip module PyJWT)
- parse (pip module parse)
- requests (pip module requests)
- django (pip module django)
All python dependencies can be downloaded with pip. In the command line, type the following for downloading PyJWT for instance:
pip install PyJWTScript
The sql_to_csv.py script is attached. Note the Settings section in the script to setup server location, name of the cube, query, user email and password, REST API token, and response file.
Windows Scheduler
See here how to schedule a task in Windows. You can read this stack overflow post about scheduling the task every hour.
The command that you need to set in the Scheduler is the following:
python sql_to_csv.py
