Explanation:
The provided path includes two columns (year and month) for partitioning. Auto Loader is capable of inferring both columns as partition columns. For more details, refer to the documentation on partition inference in Auto Loader.
Ultimate access to all questions.
No comments yet.
Given the source path for an Auto Loader is set as s3://records/year=2023/month=11/season1.parquet, which of the following statements accurately describes the partitioning details inferred from this path?
A
The year column will be inferred as the partition column, as Auto Loader supports partitioning only on one column.
B
The month column will be inferred as the partition column, as Auto Loader supports partitioning only on one column.
C
Auto Loader does not support partitioning inference, hence no column will be selected as a partition column.
D
Both year and month columns will be inferred as the partition columns.
E
A new column named year_month will be created for partitioning.