Query text before execution about pyexasol HOT 3 CLOSED

Yes, of course.

q = "select name, val from {sn!i}.{tn!i}"
p = { "sn": "ETL", "tn": "METADATA" }
print(c.format.format(q, **p))

Reference for format() function: https://github.com/badoo/pyexasol/blob/master/docs/REFERENCE.md#format

General information about Exasols-specific formatting: https://github.com/badoo/pyexasol/blob/master/docs/SQL_FORMATTING.md

Enjoy!

from pyexasol.

Please note, the better way to specify schema for identifier is to use tuple.

q = "select name, val from {table!i}"
p = {"table": ("ETL", "METADATA")}
print(c.format.format(q, **p))

Result:

select name, val from ETL.METADATA

from pyexasol.

Please note, the better way to specify schema for identifier is to use tuple.

q = "select name, val from {table!i}"
p = {"table": ("ETL", "METADATA")}
print(c.format.format(q, **p))

Result:

select name, val from ETL.METADATA

Awesome. Thanks for the quick response. I'll update the code based on you recommendation of using the tuple.

from pyexasol.