run a query using a string

[raybellwaves]

What happens?

I try to write queries using f-strings because I setup auth in s3 like

query = f"""
SET TIMEZONE='UTC';
CREATE SECRET s3_secret (
    TYPE S3,
    KEY_ID '{aws_creds.access_key}',
    SECRET '{aws_creds.secret_key}',
    SESSION_TOKEN '{aws_creds.token}'
);
PRAGMA enable_print_progress_bar;
SET TIMEZONE='UTC';
CREATE TABLE tbl AS SELECT *
FROM read_parquet('s3://BUCKET/DATA.parquet/*/*.parquet');
"""

How can I then pass this to %sql ?

To Reproduce

NA

OS:

macOS

JupySQL Version:

0.10.14

Full Name:

Ray Bell

Affiliation:

Self