Virtual schema, pushdown to SQL in Python

drumcircle
Rising Star

Has anyone built anything like this to share with the community?

push_down_request = self.request_json_object.get("pushdownRequest")
# modify request json
push_down_sql = self.pushdown_to_sql(push_down_request,"EXASOL_DIALECT")
result = self.get_return_type_dict()
result["sql"] = pushdown_sql

 

1 REPLY 1

PeterK
Xpert

Hi @drumcircle - I'm not aware of any python virtual-schema-pushdown->SQL code available to the community. We had to write our own internally based on Exasol's official Java version. I hope to release our version soon on github. It would be good to have a python template out there to use as a basis for virtual schemas.