Using variables in redshift insert command - Python lambda function

Question

I am trying to insert records to a redshift table using a lambda function. I am using

boto3.client('redshift-data')

for the same. Now I have the query as below.

query1 = "insert into dbname.tablename values('aaaa','bbbb','cccc')"

response = rsclient.execute_statement(
        ClusterIdentifier='xxxxx',
        Database='yyyy',
        DbUser='zzzz',
        Sql= query1,
        StatementName='examplestatement'
        )

This works fine. But I want to pass variables here instead of values. For instance,

var1 = 'aaaa'
var2 = 'bbbb'
var3 = 'cccc'

Then try the query as below but it it doesn't work, I think it something silly to do with quotes.

query1 = "insert into dbname.tablename values(var1,var2,var3)"

How can I achieve this. I write lambda function using python3. Any help is appreciated.

Marcin · Accepted Answer · 2022-08-23 10:04:54Z

1

You can use f-strings:

query1 = f"insert into dbname.tablename values('{var1}','{var2}','{var3}')"

answered Aug 23, 2022 at 10:04

Marcin

241k16 gold badges315 silver badges368 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using variables in redshift insert command - Python lambda function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related