Q&A BY TAG 'Python'

You must sign in to ask a question. If you do not have an account, you can register here

How to fetch execution time for Denodo query by python
answered 16-06-2021 08:24:13 -0400

Hi team, Do we have some way about how to fetch execution time for Denodo query by python script? Or do we have some pre-defined store procedure can be used for this property, we have the requirement to auto-collect the query running time. Thanks.

Answers: 1

Denodo python query execution time

Denodo dialect for python
answered 28-04-2021 11:54:21 -0400

Hi, I downloaded the denodo dialect for python connexion to use with sqlAlchemy on the support site. (Denodo Dialect for SQLAlchemy). I tried to add the dialect like I was told in this article : https://community.denodo.com/docs/html/document/denodoco...

Answers: 3

python dialect

python cur.execute result is not the same as the query result from VDP
answered 29-03-2021 08:20:44 -0400

Hi team, I used jdbc connect VDP on linux server, I am execute below query in my python script: select * from view_a limit 3; Its result is below: [('2021-03-27', '1970-01-19 10:39:21.600000', '', 'EF\x01\x01', None, None, None, None, None, None, None,...

Answers: 1

python VDP cur.result not correct

query return different value in VDP and python script connect denodo via JDBC driver
answered 08-03-2021 07:10:09 -0500

Hi Team, I ran below two command in VDP and python script (via JDBC driver), thry show different value, why? I want to have the python script running have the same return result as the VDP return result. DESC VIEW view_1 VDP result: include name, expre...

Answers: 1

python VDP return result different

VQL Parser for Python
answered 19-02-2021 07:17:32 -0500

Hi, I would like to parse a VQL in Python in order to retrieve all elements of a VQL in a correct AST. Could you please tell me if such kind of parser already exists or if there is a way to get the VQL grammar somewhere ? I already found some fragment...

Answers: 3

VQL parsing Python

How to connect denodo from airflow
answered 28-12-2020 06:50:53 -0500

I would like to connect to denodo views to read the created views from airflow. Pls advice

Answers: 1

DENODO JDBC Python

Using com.denodo.scheduler
answered 20-10-2020 04:06:40 -0400

Hi, I'm using Denodo 7.0 update 20200803 and attempting to use the scheduler api via Python/Jpype. Is there a particular jar file I need for the Scheduler? The code below is my attempt. import jpype import jpype.imports from jpype.types import * jp...

Answers: 1

Denodo Scheduler 7.0 API Python

Properties of ODBC driver
answered 06-10-2020 08:28:10 -0400

We are developing a project where we have to connect to our Denodo server from a Python script. We basically load the ODBC driver dynamically, connect to the server and then send the query. Very standard process. Here is the snippent of code where we d...

Answers: 1

C# ODBC Python

python to run vql shell (select , create view, desc view)
answered 31-08-2020 07:20:47 -0400

Hi Team, I am using python to connect Denodo ad want to run some vql, I am using JDBC connection to connect denodo with python library "jaydebeapi", when I ran some select vql query, it works. But I encounter below two problems, can you help check: ...

Answers: 1

vql shell python create view desc view

SqlAlchemy
answered 15-04-2020 13:19:11 -0400

Hello, Thank you for explain that, that's very usefull. Is it possible to use SqlAlchemy instead of those connectors ? If yes can you have a document wich explain that ? Yesterday i tried to do that but it's not work. Thx.

Answers: 1
Related to: How to connect to Denodo from Python - a starter for Data Scientists

Denodo data catalog SQLAlchemy Python