ValueError: unsupported format character when CREATE TABLE is executed

[VMois]

Describe the bug
I am using Meltano to run pipelinewise-target-snowflake. When the target tries to create a table with "%" it fails with "ValueError: unsupported format character 'A' (0x41) at index 50". The example query:

CREATE TABLE IF NOT EXISTS TAP_S3_CSV."TABLE1" ("%AVG" text, "_SDC_EXTRA" variant, "_SDC_SOURCE_BUCKET" text, "_SDC_SOURCE_FILE" text, "_SDC_SOURCE_LINENO" number) data_retention_time_in_days = 1

To Reproduce
Try to import the data that has a column with "%" in it.

Expected behavior
The table should be created with no errors.

Screenshots
N/A

Your environment

• Version of target: 2.2.0
• Version of python: 3.9.16

Additional context
Initially, I thought it might be a problem with missing quotas for column names, but the target takes care of it. After that, I found this issue - snowflakedb/snowflake-sqlalchemy#327. It might provides an explanation and possible solution.