We are currently solving the following issue within our repository. Here is the issue text:
--- BEGIN ISSUE ---
CI: `example_load_file.py` isnt running
**Describe the bug**
 The `python-sdk/example_dags/example_load_file.py` example DAG in not running in our CI tests

**Version**
* Astro: [e.g. 0.6.0]
* OS: [eg. Debian]

**To Reproduce**
Steps to reproduce the behavior:
1. Write the DAG  '...'
2. Create connection '....'
3. Run using  '....'
4. See error

**Expected behavior**
A clear and concise description of what you expected to happen.

**Screenshots**
If applicable, add screenshots to help explain your problem.


**Additional context**
Add any other context about the problem here.


--- END ISSUE ---

Below are some code segments, each from a relevant file. One or more of these files may contain bugs.
--- BEGIN FILES ---
Path: `python-sdk/example_dags/example_load_file.py`
Content:
```
1 import os
2 import pathlib
3 from datetime import datetime, timedelta
4 
5 import sqlalchemy
6 from airflow.models import DAG
7 
8 from astro import sql as aql
9 from astro.constants import FileType
10 from astro.files import File
11 from astro.table import Metadata, Table
12 
13 # To create IAM role with needed permissions,
14 # refer: https://www.dataliftoff.com/iam-roles-for-loading-data-from-s3-into-redshift/
15 REDSHIFT_NATIVE_LOAD_IAM_ROLE_ARN = os.getenv("REDSHIFT_NATIVE_LOAD_IAM_ROLE_ARN")
16 
17 CWD = pathlib.Path(__file__).parent
18 default_args = {
19     "owner": "airflow",
20     "retries": 1,
21     "retry_delay": 0,
22 }
23 data_url = "https://archive.ics.uci.edu/ml/machine-learning-databases/iris/iris.data"  # URL for Iris data API
24 
25 dag = DAG(
26     dag_id="example_load_file",
27     start_date=datetime(2019, 1, 1),
28     max_active_runs=3,
29     schedule_interval=timedelta(minutes=30),
30     default_args=default_args,
31 )
32 
33 
34 with dag:
35     # [START load_file_example_1]
36     my_homes_table = aql.load_file(
37         input_file=File(path="s3://astro-sdk/sample.csv"),
38         output_table=Table(
39             conn_id="postgres_conn",
40         ),
41     )
42     # [END load_file_example_1]
43 
44     # [START load_file_example_2]
45     dataframe = aql.load_file(
46         input_file=File(path="s3://astro-sdk/sample.csv"),
47     )
48     # [END load_file_example_2]
49 
50     # [START load_file_example_3]
51     sample_table = aql.load_file(
52         input_file=File(path="s3://astro-sdk/sample.ndjson"),
53         output_table=Table(
54             conn_id="postgres_conn",
55         ),
56         ndjson_normalize_sep="__",
57     )
58     # [END load_file_example_3]
59 
60     # [START load_file_example_4]
61     new_table = aql.load_file(
62         input_file=File(path="s3://astro-sdk/sample.csv"),
63         output_table=Table(
64             conn_id="postgres_conn",
65         ),
66         if_exists="replace",
67     )
68     # [END load_file_example_4]
69 
70     # [START load_file_example_5]
71     custom_schema_table = aql.load_file(
72         input_file=File(path="s3://astro-sdk/sample.csv"),
73         output_table=Table(
74             conn_id="postgres_conn",
75             columns=[
76                 sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
77                 sqlalchemy.Column("name", sqlalchemy.String(60), nullable=False, key="name"),
78             ],
79         ),
80     )
81     # [END load_file_example_5]
82 
83     # [START load_file_example_6]
84     dataframe = aql.load_file(
85         input_file=File(path="s3://astro-sdk/sample.csv"),
86         columns_names_capitalization="upper",
87     )
88     # [END load_file_example_6]
89 
90     # [START load_file_example_7]
91     aql.load_file(
92         input_file=File("s3://tmp9/homes_main.csv", conn_id="aws_conn"),
93         output_table=Table(conn_id="bigquery", metadata=Metadata(schema="astro")),
94         use_native_support=False,
95     )
96     # [END load_file_example_7]
97 
98     # [START load_file_example_8]
99     aql.load_file(
100         input_file=File("s3://tmp9/homes_main.csv", conn_id="aws_conn"),
101         output_table=Table(conn_id="bigquery", metadata=Metadata(schema="astro")),
102         use_native_support=True,
103         native_support_kwargs={
104             "ignore_unknown_values": True,
105             "allow_jagged_rows": True,
106             "skip_leading_rows": "1",
107         },
108     )
109     # [END load_file_example_8]
110 
111     # [START load_file_example_9]
112     aql.load_file(
113         input_file=File("s3://tmp9/homes_main.csv", conn_id="aws_conn"),
114         output_table=Table(conn_id="bigquery", metadata=Metadata(schema="astro")),
115         use_native_support=True,
116         native_support_kwargs={
117             "ignore_unknown_values": True,
118             "allow_jagged_rows": True,
119             "skip_leading_rows": "1",
120         },
121         enable_native_fallback=False,
122     )
123     # [END load_file_example_9]
124 
125     # [START load_file_example_10]
126     my_homes_table = aql.load_file(
127         input_file=File(path=str(CWD.parent) + "/tests/data/homes*", filetype=FileType.CSV),
128         output_table=Table(
129             conn_id="postgres_conn",
130         ),
131     )
132     # [END load_file_example_10]
133 
134     # [START load_file_example_11]
135     aql.load_file(
136         input_file=File("s3://astro-sdk/sample_pattern", conn_id="aws_conn", filetype=FileType.CSV),
137         output_table=Table(conn_id="bigquery", metadata=Metadata(schema="astro")),
138         use_native_support=False,
139     )
140     # [END load_file_example_11]
141 
142     # [START load_file_example_12]
143     aql.load_file(
144         input_file=File(
145             "gs://astro-sdk/workspace/sample_pattern",
146             conn_id="bigquery",
147             filetype=FileType.CSV,
148         ),
149         output_table=Table(conn_id="bigquery", metadata=Metadata(schema="astro")),
150         use_native_support=False,
151     )
152     # [END load_file_example_12]
153 
154     # [START load_file_example_13]
155     aql.load_file(
156         input_file=File(
157             "s3://astro-sdk/sample_pattern",
158             conn_id="aws_conn",
159             filetype=FileType.CSV,
160         ),
161         output_table=Table(conn_id="redshift_conn", metadata=Metadata(schema="astro")),
162         use_native_support=False,
163     )
164     # [END load_file_example_13]
165 
166     # [START load_file_example_14]
167     aql.load_file(
168         input_file=File(
169             "gs://astro-sdk/workspace/sample_pattern",
170             conn_id="bigquery",
171             filetype=FileType.CSV,
172         ),
173         output_table=Table(conn_id="redshift_conn", metadata=Metadata(schema="astro")),
174         use_native_support=False,
175     )
176     # [END load_file_example_14]
177 
178     # [START load_file_example_15]
179     aql.load_file(
180         input_file=File(path=str(CWD.parent) + "/tests/data/homes*", filetype=FileType.CSV),
181         output_table=Table(
182             conn_id="postgres_conn",
183         ),
184     )
185     # [END load_file_example_15]
186 
187     # [START load_file_example_16]
188     aql.load_file(
189         input_file=File("s3://tmp9/homes_main.csv", conn_id="aws_conn"),
190         output_table=Table(conn_id="redshift_conn", metadata=Metadata(schema="astro")),
191         use_native_support=True,
192         native_support_kwargs={
193             "IGNOREHEADER": 1,
194             "REGION": "us-west-2",
195             "IAM_ROLE": REDSHIFT_NATIVE_LOAD_IAM_ROLE_ARN,
196         },
197     )
198     # [END load_file_example_16]
199 
200     # [START load_file_example_17]
201     aql.load_file(
202         input_file=File(
203             "gs://astro-sdk/workspace/sample_pattern",
204             conn_id="bigquery",
205             filetype=FileType.CSV,
206         ),
207         output_table=Table(conn_id="bigquery", metadata=Metadata(schema="astro")),
208         use_native_support=True,
209         native_support_kwargs={
210             "ignore_unknown_values": True,
211             "allow_jagged_rows": True,
212             "skip_leading_rows": "1",
213         },
214         enable_native_fallback=True,
215     )
216     # [END load_file_example_17]
217 
218     # [START load_file_example_18]
219     dataframe = aql.load_file(input_file=File(path=data_url, filetype=FileType.CSV))
220     # [END load_file_example_18]
221 
222     aql.cleanup()
223
```
--- END FILES ---

Please first localize the bug based on the issue statement, and then generate a patch according to the `git diff` format fenced by three backticks.

Here is an example:

```diff
diff --git a/examples/server_async.py b/examples/server_async.py
--- a/examples/server_async.py
+++ b/examples/server_async.py
@@ -313,4 +313,4 @@
 
 
 if __name__ == "__main__":
-    asyncio.run(run_async_server("."), debug=True)
+    asyncio.run(run_async_server(), debug=True)
diff --git a/examples/server_sync.py b/examples/server_sync.py
--- a/examples/server_sync.py
+++ b/examples/server_sync.py
@@ -313,5 +313,5 @@
 
 
 if __name__ == "__main__":
-    server = run_sync_server(".")
+    server = run_sync_server()
     server.shutdown()

```

diff --git a/python-sdk/example_dags/example_load_file.py b/python-sdk/example_dags/example_load_file.py
--- a/python-sdk/example_dags/example_load_file.py
+++ b/python-sdk/example_dags/example_load_file.py
@@ -142,7 +142,7 @@
     # [START load_file_example_12]
     aql.load_file(
         input_file=File(
-            "gs://astro-sdk/workspace/sample_pattern",
+            "gs://astro-sdk/workspace/sample_pattern.csv",
             conn_id="bigquery",
             filetype=FileType.CSV,
         ),
@@ -166,7 +166,7 @@
     # [START load_file_example_14]
     aql.load_file(
         input_file=File(
-            "gs://astro-sdk/workspace/sample_pattern",
+            "gs://astro-sdk/workspace/sample_pattern.csv",
             conn_id="bigquery",
             filetype=FileType.CSV,
         ),
@@ -200,7 +200,7 @@
     # [START load_file_example_17]
     aql.load_file(
         input_file=File(
-            "gs://astro-sdk/workspace/sample_pattern",
+            "gs://astro-sdk/workspace/sample_pattern.csv",
             conn_id="bigquery",
             filetype=FileType.CSV,
         ),

{"golden_diff": "diff --git a/python-sdk/example_dags/example_load_file.py b/python-sdk/example_dags/example_load_file.py\n--- a/python-sdk/example_dags/example_load_file.py\n+++ b/python-sdk/example_dags/example_load_file.py\n@@ -142,7 +142,7 @@\n     # [START load_file_example_12]\n     aql.load_file(\n         input_file=File(\n-            \"gs://astro-sdk/workspace/sample_pattern\",\n+            \"gs://astro-sdk/workspace/sample_pattern.csv\",\n             conn_id=\"bigquery\",\n             filetype=FileType.CSV,\n         ),\n@@ -166,7 +166,7 @@\n     # [START load_file_example_14]\n     aql.load_file(\n         input_file=File(\n-            \"gs://astro-sdk/workspace/sample_pattern\",\n+            \"gs://astro-sdk/workspace/sample_pattern.csv\",\n             conn_id=\"bigquery\",\n             filetype=FileType.CSV,\n         ),\n@@ -200,7 +200,7 @@\n     # [START load_file_example_17]\n     aql.load_file(\n         input_file=File(\n-            \"gs://astro-sdk/workspace/sample_pattern\",\n+            \"gs://astro-sdk/workspace/sample_pattern.csv\",\n             conn_id=\"bigquery\",\n             filetype=FileType.CSV,\n         ),\n", "issue": "CI: `example_load_file.py` isnt running\n**Describe the bug**\r\n The `python-sdk/example_dags/example_load_file.py` example DAG in not running in our CI tests\r\n\r\n**Version**\r\n* Astro: [e.g. 0.6.0]\r\n* OS: [eg. Debian]\r\n\r\n**To Reproduce**\r\nSteps to reproduce the behavior:\r\n1. Write the DAG  '...'\r\n2. Create connection '....'\r\n3. Run using  '....'\r\n4. See error\r\n\r\n**Expected behavior**\r\nA clear and concise description of what you expected to happen.\r\n\r\n**Screenshots**\r\nIf applicable, add screenshots to help explain your problem.\r\n\r\n\r\n**Additional context**\r\nAdd any other context about the problem here.\r\n\n", "before_files": [{"content": "import os\nimport pathlib\nfrom datetime import datetime, timedelta\n\nimport sqlalchemy\nfrom airflow.models import DAG\n\nfrom astro import sql as aql\nfrom astro.constants import FileType\nfrom astro.files import File\nfrom astro.table import Metadata, Table\n\n# To create IAM role with needed permissions,\n# refer: https://www.dataliftoff.com/iam-roles-for-loading-data-from-s3-into-redshift/\nREDSHIFT_NATIVE_LOAD_IAM_ROLE_ARN = os.getenv(\"REDSHIFT_NATIVE_LOAD_IAM_ROLE_ARN\")\n\nCWD = pathlib.Path(__file__).parent\ndefault_args = {\n    \"owner\": \"airflow\",\n    \"retries\": 1,\n    \"retry_delay\": 0,\n}\ndata_url = \"https://archive.ics.uci.edu/ml/machine-learning-databases/iris/iris.data\"  # URL for Iris data API\n\ndag = DAG(\n    dag_id=\"example_load_file\",\n    start_date=datetime(2019, 1, 1),\n    max_active_runs=3,\n    schedule_interval=timedelta(minutes=30),\n    default_args=default_args,\n)\n\n\nwith dag:\n    # [START load_file_example_1]\n    my_homes_table = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.csv\"),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n        ),\n    )\n    # [END load_file_example_1]\n\n    # [START load_file_example_2]\n    dataframe = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.csv\"),\n    )\n    # [END load_file_example_2]\n\n    # [START load_file_example_3]\n    sample_table = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.ndjson\"),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n        ),\n        ndjson_normalize_sep=\"__\",\n    )\n    # [END load_file_example_3]\n\n    # [START load_file_example_4]\n    new_table = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.csv\"),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n        ),\n        if_exists=\"replace\",\n    )\n    # [END load_file_example_4]\n\n    # [START load_file_example_5]\n    custom_schema_table = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.csv\"),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n            columns=[\n                sqlalchemy.Column(\"id\", sqlalchemy.Integer, primary_key=True),\n                sqlalchemy.Column(\"name\", sqlalchemy.String(60), nullable=False, key=\"name\"),\n            ],\n        ),\n    )\n    # [END load_file_example_5]\n\n    # [START load_file_example_6]\n    dataframe = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.csv\"),\n        columns_names_capitalization=\"upper\",\n    )\n    # [END load_file_example_6]\n\n    # [START load_file_example_7]\n    aql.load_file(\n        input_file=File(\"s3://tmp9/homes_main.csv\", conn_id=\"aws_conn\"),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=False,\n    )\n    # [END load_file_example_7]\n\n    # [START load_file_example_8]\n    aql.load_file(\n        input_file=File(\"s3://tmp9/homes_main.csv\", conn_id=\"aws_conn\"),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=True,\n        native_support_kwargs={\n            \"ignore_unknown_values\": True,\n            \"allow_jagged_rows\": True,\n            \"skip_leading_rows\": \"1\",\n        },\n    )\n    # [END load_file_example_8]\n\n    # [START load_file_example_9]\n    aql.load_file(\n        input_file=File(\"s3://tmp9/homes_main.csv\", conn_id=\"aws_conn\"),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=True,\n        native_support_kwargs={\n            \"ignore_unknown_values\": True,\n            \"allow_jagged_rows\": True,\n            \"skip_leading_rows\": \"1\",\n        },\n        enable_native_fallback=False,\n    )\n    # [END load_file_example_9]\n\n    # [START load_file_example_10]\n    my_homes_table = aql.load_file(\n        input_file=File(path=str(CWD.parent) + \"/tests/data/homes*\", filetype=FileType.CSV),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n        ),\n    )\n    # [END load_file_example_10]\n\n    # [START load_file_example_11]\n    aql.load_file(\n        input_file=File(\"s3://astro-sdk/sample_pattern\", conn_id=\"aws_conn\", filetype=FileType.CSV),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=False,\n    )\n    # [END load_file_example_11]\n\n    # [START load_file_example_12]\n    aql.load_file(\n        input_file=File(\n            \"gs://astro-sdk/workspace/sample_pattern\",\n            conn_id=\"bigquery\",\n            filetype=FileType.CSV,\n        ),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=False,\n    )\n    # [END load_file_example_12]\n\n    # [START load_file_example_13]\n    aql.load_file(\n        input_file=File(\n            \"s3://astro-sdk/sample_pattern\",\n            conn_id=\"aws_conn\",\n            filetype=FileType.CSV,\n        ),\n        output_table=Table(conn_id=\"redshift_conn\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=False,\n    )\n    # [END load_file_example_13]\n\n    # [START load_file_example_14]\n    aql.load_file(\n        input_file=File(\n            \"gs://astro-sdk/workspace/sample_pattern\",\n            conn_id=\"bigquery\",\n            filetype=FileType.CSV,\n        ),\n        output_table=Table(conn_id=\"redshift_conn\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=False,\n    )\n    # [END load_file_example_14]\n\n    # [START load_file_example_15]\n    aql.load_file(\n        input_file=File(path=str(CWD.parent) + \"/tests/data/homes*\", filetype=FileType.CSV),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n        ),\n    )\n    # [END load_file_example_15]\n\n    # [START load_file_example_16]\n    aql.load_file(\n        input_file=File(\"s3://tmp9/homes_main.csv\", conn_id=\"aws_conn\"),\n        output_table=Table(conn_id=\"redshift_conn\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=True,\n        native_support_kwargs={\n            \"IGNOREHEADER\": 1,\n            \"REGION\": \"us-west-2\",\n            \"IAM_ROLE\": REDSHIFT_NATIVE_LOAD_IAM_ROLE_ARN,\n        },\n    )\n    # [END load_file_example_16]\n\n    # [START load_file_example_17]\n    aql.load_file(\n        input_file=File(\n            \"gs://astro-sdk/workspace/sample_pattern\",\n            conn_id=\"bigquery\",\n            filetype=FileType.CSV,\n        ),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=True,\n        native_support_kwargs={\n            \"ignore_unknown_values\": True,\n            \"allow_jagged_rows\": True,\n            \"skip_leading_rows\": \"1\",\n        },\n        enable_native_fallback=True,\n    )\n    # [END load_file_example_17]\n\n    # [START load_file_example_18]\n    dataframe = aql.load_file(input_file=File(path=data_url, filetype=FileType.CSV))\n    # [END load_file_example_18]\n\n    aql.cleanup()\n", "path": "python-sdk/example_dags/example_load_file.py"}], "after_files": [{"content": "import os\nimport pathlib\nfrom datetime import datetime, timedelta\n\nimport sqlalchemy\nfrom airflow.models import DAG\n\nfrom astro import sql as aql\nfrom astro.constants import FileType\nfrom astro.files import File\nfrom astro.table import Metadata, Table\n\n# To create IAM role with needed permissions,\n# refer: https://www.dataliftoff.com/iam-roles-for-loading-data-from-s3-into-redshift/\nREDSHIFT_NATIVE_LOAD_IAM_ROLE_ARN = os.getenv(\"REDSHIFT_NATIVE_LOAD_IAM_ROLE_ARN\")\n\nCWD = pathlib.Path(__file__).parent\ndefault_args = {\n    \"owner\": \"airflow\",\n    \"retries\": 1,\n    \"retry_delay\": 0,\n}\ndata_url = \"https://archive.ics.uci.edu/ml/machine-learning-databases/iris/iris.data\"  # URL for Iris data API\n\ndag = DAG(\n    dag_id=\"example_load_file\",\n    start_date=datetime(2019, 1, 1),\n    max_active_runs=3,\n    schedule_interval=timedelta(minutes=30),\n    default_args=default_args,\n)\n\n\nwith dag:\n    # [START load_file_example_1]\n    my_homes_table = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.csv\"),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n        ),\n    )\n    # [END load_file_example_1]\n\n    # [START load_file_example_2]\n    dataframe = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.csv\"),\n    )\n    # [END load_file_example_2]\n\n    # [START load_file_example_3]\n    sample_table = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.ndjson\"),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n        ),\n        ndjson_normalize_sep=\"__\",\n    )\n    # [END load_file_example_3]\n\n    # [START load_file_example_4]\n    new_table = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.csv\"),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n        ),\n        if_exists=\"replace\",\n    )\n    # [END load_file_example_4]\n\n    # [START load_file_example_5]\n    custom_schema_table = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.csv\"),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n            columns=[\n                sqlalchemy.Column(\"id\", sqlalchemy.Integer, primary_key=True),\n                sqlalchemy.Column(\"name\", sqlalchemy.String(60), nullable=False, key=\"name\"),\n            ],\n        ),\n    )\n    # [END load_file_example_5]\n\n    # [START load_file_example_6]\n    dataframe = aql.load_file(\n        input_file=File(path=\"s3://astro-sdk/sample.csv\"),\n        columns_names_capitalization=\"upper\",\n    )\n    # [END load_file_example_6]\n\n    # [START load_file_example_7]\n    aql.load_file(\n        input_file=File(\"s3://tmp9/homes_main.csv\", conn_id=\"aws_conn\"),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=False,\n    )\n    # [END load_file_example_7]\n\n    # [START load_file_example_8]\n    aql.load_file(\n        input_file=File(\"s3://tmp9/homes_main.csv\", conn_id=\"aws_conn\"),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=True,\n        native_support_kwargs={\n            \"ignore_unknown_values\": True,\n            \"allow_jagged_rows\": True,\n            \"skip_leading_rows\": \"1\",\n        },\n    )\n    # [END load_file_example_8]\n\n    # [START load_file_example_9]\n    aql.load_file(\n        input_file=File(\"s3://tmp9/homes_main.csv\", conn_id=\"aws_conn\"),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=True,\n        native_support_kwargs={\n            \"ignore_unknown_values\": True,\n            \"allow_jagged_rows\": True,\n            \"skip_leading_rows\": \"1\",\n        },\n        enable_native_fallback=False,\n    )\n    # [END load_file_example_9]\n\n    # [START load_file_example_10]\n    my_homes_table = aql.load_file(\n        input_file=File(path=str(CWD.parent) + \"/tests/data/homes*\", filetype=FileType.CSV),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n        ),\n    )\n    # [END load_file_example_10]\n\n    # [START load_file_example_11]\n    aql.load_file(\n        input_file=File(\"s3://astro-sdk/sample_pattern\", conn_id=\"aws_conn\", filetype=FileType.CSV),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=False,\n    )\n    # [END load_file_example_11]\n\n    # [START load_file_example_12]\n    aql.load_file(\n        input_file=File(\n            \"gs://astro-sdk/workspace/sample_pattern.csv\",\n            conn_id=\"bigquery\",\n            filetype=FileType.CSV,\n        ),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=False,\n    )\n    # [END load_file_example_12]\n\n    # [START load_file_example_13]\n    aql.load_file(\n        input_file=File(\n            \"s3://astro-sdk/sample_pattern\",\n            conn_id=\"aws_conn\",\n            filetype=FileType.CSV,\n        ),\n        output_table=Table(conn_id=\"redshift_conn\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=False,\n    )\n    # [END load_file_example_13]\n\n    # [START load_file_example_14]\n    aql.load_file(\n        input_file=File(\n            \"gs://astro-sdk/workspace/sample_pattern.csv\",\n            conn_id=\"bigquery\",\n            filetype=FileType.CSV,\n        ),\n        output_table=Table(conn_id=\"redshift_conn\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=False,\n    )\n    # [END load_file_example_14]\n\n    # [START load_file_example_15]\n    aql.load_file(\n        input_file=File(path=str(CWD.parent) + \"/tests/data/homes*\", filetype=FileType.CSV),\n        output_table=Table(\n            conn_id=\"postgres_conn\",\n        ),\n    )\n    # [END load_file_example_15]\n\n    # [START load_file_example_16]\n    aql.load_file(\n        input_file=File(\"s3://tmp9/homes_main.csv\", conn_id=\"aws_conn\"),\n        output_table=Table(conn_id=\"redshift_conn\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=True,\n        native_support_kwargs={\n            \"IGNOREHEADER\": 1,\n            \"REGION\": \"us-west-2\",\n            \"IAM_ROLE\": REDSHIFT_NATIVE_LOAD_IAM_ROLE_ARN,\n        },\n    )\n    # [END load_file_example_16]\n\n    # [START load_file_example_17]\n    aql.load_file(\n        input_file=File(\n            \"gs://astro-sdk/workspace/sample_pattern.csv\",\n            conn_id=\"bigquery\",\n            filetype=FileType.CSV,\n        ),\n        output_table=Table(conn_id=\"bigquery\", metadata=Metadata(schema=\"astro\")),\n        use_native_support=True,\n        native_support_kwargs={\n            \"ignore_unknown_values\": True,\n            \"allow_jagged_rows\": True,\n            \"skip_leading_rows\": \"1\",\n        },\n        enable_native_fallback=True,\n    )\n    # [END load_file_example_17]\n\n    # [START load_file_example_18]\n    dataframe = aql.load_file(input_file=File(path=data_url, filetype=FileType.CSV))\n    # [END load_file_example_18]\n\n    aql.cleanup()\n", "path": "python-sdk/example_dags/example_load_file.py"}]}