TypeError: string indices must be integers (apache-airflow-providers-snowflake==4.0.2rc1) [BUG]

[mag3141592]

Describe the bug
Similar to #1335 but with apache-airflow-providers-snowflake==4.0.2rc1

Version

• Astro-SDK: 1.3.0
• Airflow version: 2.4.3+astro.1

To Reproduce
Steps to reproduce the behavior:

1. Create connection "snowflake_default"
2. Run DAG:

from datetime import datetime

from airflow import DAG

from astro import sql as aql
from astro.table import Table

SNOWFLAKE_CONN_ID = 'snowflake_default'

START_DATE = datetime(2000, 1, 1)

def query() -> Table:
    return "SELECT 'hi'"

with DAG(
    "example_transform",
    schedule_interval=None,
    start_date=START_DATE,
    catchup=False,
) as dag:

    get_data = aql.transform(
            conn_id=SNOWFLAKE_CONN_ID,
            task_id="query_data",
        )(query)()