Add variable to a triple quote string issue

Question

I ran the following code below in Python:

configuration_str= """
    configuration={
                "query": {
                "query": "CALL `{0}.{1}.{2}`(); ",
                "useLegacySql": False,
            }
            },

""".format("server_name", "dataset_name", "sp_name")

I got the error below:

Traceback (most recent call last):
    File "<stdin>", line 1, in <module>
KeyError: '\n                    "query"'

What is the issue and how to fix it?

You need to escape the braces that _aren't_ supposed to be `str.format`ted. — jonrsharpe, Aug 19 '21 at 13:21
Why are you appearing to generate Python code as string in the first place…? — deceze, Aug 19 '21 at 13:24

score 0 · Accepted Answer · answered Aug 19 '21 at 13:29

how about using f string

server_name = 'A'
dataset_name = 'B'
sp_name ='C'

configuration_str = f"""configuration={{
                "query": {{
                "query": "CALL '{server_name}.{dataset_name}.{sp_name}'(); ",
                "useLegacySql": False,
            }}
            }}"""

print(configuration_str)

output

configuration={
                "query": {
                "query": "CALL 'A.B.C'(); ",
                "useLegacySql": False,
            }
            }

f-strings have the same problem as OP's code, which you just silently fixed without explanation… — deceze, Aug 19 '21 at 13:31

Add variable to a triple quote string issue

1 Answers1