dbt-glue has the code sql.replace(‘"’, ‘’) which is stripping off double quotes within the data.
Any idea why it is there?
Detailed Excerpt pasted below:-
SQLPROXY = """
import json
import base64
class SqlWrapper2:
i = 0
dfs = {}
@classmethod
def execute(cls,sql,output=True):
sql = sql.replace('"', '')